1. Norman Faught
  2. Valentina Studio
  3. 月, 11月 20 2017, 10:27 AM
  4.  メールで購読
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.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Norman,

Could you please make a screenshot of SQL Editor right after the query execution?
コメント
There are no comments made yet.
Norman Faught 承諾済みの回答
Screenshot attached
添付ファイル
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
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.
添付ファイル
コメント
There are no comments made yet.
Norman Faught 承諾済みの回答
Perfect.
Thank you very much that solved it.
添付ファイル
コメント
There are no comments made yet.
dimkas dimkas 承諾済みの回答
You should add a button for a restoring a normal size of result area ;) It will be useful
コメント
There are no comments made yet.
  • ページ :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
申し訳ありませんが、現在このディスカッションはロックされており、返信を投稿することができません。

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