1. Norman Faught
  2. Valentina Studio
  3. Montag, November 20 2017, 10:27 AM
  4.  Abonnieren via E-Mail
On the latest version 7.5.4 64bit on windows 10.
Nov 15 2017.

Query that works in Query editor does not open the results windows in sql editor.
SELECT
"public"."school"."name" AS "school_name"
, "public"."student"."student_id"AS"student_id"
, "public"."student"."name"AS"student_name"
, "public"."student"."id"AS"edusctock_id"
, "public"."grades"."name"AS"Grade_name"
, "public"."student"."active"
, "public"."student"."parent_phone"
, "public"."student"."parent_email"
FROM "student_grades"
JOIN "grades"
ON "student_grades"."grades_id" = "grades"."id"
JOIN "student"
ON "student_grades"."student_id" = "student"."id"
JOIN "school"
ON "student"."school_id" = "school"."id"
ORDER BY"public"."school"."name", "public"."grades"."name", "public"."student"."name"

Even though the query is successful.
12:03:40 Query time: 34 millisecond(s), Number of affected records: 5613

So I am unable to export the results of the query.
Please assist?

Would be better if results could be directly exported from query editor.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Norman,

Could you please make a screenshot of SQL Editor right after the query execution?
Kommentar
There are no comments made yet.
Norman Faught Akzeptierte Antwort
Screenshot attached
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Looks like the splitter is moved to the bottom and there is no indication of it on Windows.

Try to move it to the top and you should see the result.
Anhänge
Kommentar
There are no comments made yet.
Norman Faught Akzeptierte Antwort
Perfect.
Thank you very much that solved it.
Anhänge
Kommentar
There are no comments made yet.
dimkas dimkas Akzeptierte Antwort
You should add a button for a restoring a normal size of result area ;) It will be useful
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Das Thema ist derzeit gesperrt. Du kannst derzeit keine Antwort erstellen.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories