1. Norman Faught
  2. Valentina Studio
  3. Понедельник, Ноябрь 20 2017, 10:27 AM
  4.  Подписаться через 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.
Комментарий
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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories