Build from Assisted SQL doesn't work correctly

Post any suggestions or enhancement requests about the Verj.io platform or this Forum

Moderators: Jon, Steve, Ian, Dave

Segi
Ebase User
Posts: 649
Joined: Mon Dec 09, 2013 6:37 pm

Build from Assisted SQL doesn't work correctly

#1

Postby Segi » Tue Apr 11, 2017 5:53 pm

As of 5.2, Build from Assisted SQL doesn't work correctly. I always add all of the resource fields before clicking on "Build from Assisted SQL"

If I click on this button for the SELECT, it creates this SQL:

Code: Select all

select  
from 
For Update, it creates an incomplete SQL statement because it creates this insert statement without the table name:

Code: Select all

update set fieldname1=&&fieldname1, fieldname2=&&fieldname2 where primarykeyid=&&primarykeyid
The same goes for delete and the insert statements where the table name is missing
0 x

Jon
Moderator
Moderator
Posts: 1342
Joined: Wed Sep 12, 2007 12:49 pm

#2

Postby Jon » Wed Apr 12, 2017 7:42 am

It needs the boxes filled in on the Assisted SQL page:
Select columns
Select from tables
Where clause (if there is one)
0 x

Segi
Ebase User
Posts: 649
Joined: Mon Dec 09, 2013 6:37 pm

#3

Postby Segi » Wed Apr 12, 2017 3:33 pm

Jon,

Are you saying that you can only use Build from Assisted SQL which is part of Native SQL after filling in the fields in the assisted SQL boxes ?
0 x

Jon
Moderator
Moderator
Posts: 1342
Joined: Wed Sep 12, 2007 12:49 pm

#4

Postby Jon » Thu Apr 13, 2017 8:54 am

Yes exactly, that's what it does. It isn't all that much use. But you could import a table structure from a database - which creates a resource with assisted SQL - then change it to Native SQL, so it would be of some use at this point.
0 x


Who is online

Users browsing this forum: No registered users and 5 guests