FlySpeed SQL Query broken after updating

Avatar
  • updated
  • Completed
Fired up SQL Query, program asked if I wanted to update, said yes, updated to 3.1.0.6, program started again, but when I open any existing query, nothing appears in either the query builder of SQL text screens.

Updated last week sometime, and all was well -- but today's update leaves program pretty much useless.

Restarted computer, no help . . . any advice? Can I roll back easily?

Thanks in advance for your help.

JB
Avatar
Anonymous
Hello, Jeff.

Sorry for this problem. 

You can downgrade to version 3.0.2.4 by downloading it here, but I'm kindly asking you for assistance in order to investigate this problem. Can you please send me a screenshot of the Connection Properties dialog and a query that the tool has failed to load? You can find the queries in the "%USERPROFILE%/AppData/Local/ActiveDBSoft/FlySpeed SQL Query/<your connection name>/" folder.

Thank you in advance for helping us to make our software better.
Avatar
Anonymous



Select Distinct
stars3.stu_base.student_id,
stars3.stu_base.last_name As studentLast,
stars3.stu_base.first_name As studentFirst,
stars3.stu_sch.building,
stars3.contact_link.contact_seq_number,
stars3.contact_link.priority,
stars3.contact.first_name As parentFirst,
stars3.contact.last_name As parentLast,
stars3.contact.email1
From
stars3.stu_sch Inner Join
stars3.stu_sche On stars3.stu_sche.student_id = stars3.stu_sch.student_id And stars3.stu_sche.start_yy = stars3.stu_sch.start_yy And stars3.stu_sche.school = stars3.stu_sch.school Inner Join
stars3.meets On stars3.meets.start_yy = stars3.stu_sche.start_yy And stars3.meets.school = stars3.stu_sche.school And stars3.meets.class_cd = stars3.stu_sche.class_cd And stars3.meets.section = stars3.stu_sche.section Left Join
stars3.stu_meet On stars3.meets.start_yy = stars3.stu_meet.start_yy And stars3.meets.school = stars3.stu_meet.school And stars3.meets.class_cd = stars3.stu_meet.class_cd And stars3.stu_meet.section = stars3.meets.section And stars3.stu_meet.sub_section = stars3.meets.sub_section And stars3.stu_sche.student_id = stars3.stu_meet.student_id Inner Join
stars3.course On stars3.course.start_yy = stars3.meets.start_yy And stars3.course.school = stars3.meets.school And stars3.course.class_cd = stars3.meets.class_cd Inner Join
stars3.stu_base On stars3.stu_sche.student_id = stars3.stu_base.student_id And stars3.stu_sch.student_id = stars3.stu_base.student_id Inner Join
stars3.contact_link On stars3.stu_base.student_id = stars3.contact_link.student_id Inner Join
stars3.contact On stars3.contact_link.contact_seq_number = stars3.contact.contact_seq_number Inner Join
conferences.eighthGradeWorkshops On conferences.eighthGradeWorkshops.scheduleStudentID = stars3.stu_base.student_id
Where
stars3.contact_link.priority = '1' And
stars3.stu_sche.class_cd = '896' And
stars3.meets.semester = 'S1' And
stars3.stu_sch.start_yy = '13' And
stars3.stu_sch.school = '3000' And
stars3.stu_sch.grade = '08'
Order By
stars3.stu_base.last_name, stars3.stu_base.first_name, stars3.stu_base.student_id

Avatar
Jeff Busha
Downgrade to version 3.0.2.4 fixed program for me. 

Let me know if you need any more info . . . love your product and was very surprised it failed after update today.

Thanks for the quick reply!

JB
Avatar
Anonymous
Hello, 

Thank you for your report. The problem is fixed in the new version 3.1.0.7.