Page 1 of 1

SQL Queries

Posted: Thu Mar 08, 2012 5:35 pm
by cpt_tom
I have not bought it yet, Is the SQL Query limited to Select commands or can I also run Replace Commands? I would like to be able to do some mass changes, I have a background in manipulating databases, but most of the programs do not allow access.

Thanks,

Larry Thomas

Posted: Fri Mar 09, 2012 8:36 am
by Nick Hunter
Hi,

Sorry, the SQL query function is limited to SELECT statements - you cannot use UPDATE. However, you can edit the data in the results of a query if that helps.

There may be a third party DBISAM database editor available.