1. Norman Faught
  2. Valentina Studio
  3. Monday, November 20 2017, 10:27 AM
  4.  Subscribe via email
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.
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Norman,

Could you please make a screenshot of SQL Editor right after the query execution?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Norman Faught Accepted Answer
Screenshot attached
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Sergey Pashkov Accepted Answer
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.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Norman Faught Accepted Answer
Perfect.
Thank you very much that solved it.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
dimkas dimkas Accepted Answer
You should add a button for a restoring a normal size of result area ;) It will be useful
Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.

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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories