SQL Queries

cpt_tom · Post by **cpt_tom** » Thu Mar 08, 2012 5:35 pm

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

Nick Hunter · Post by **Nick Hunter** » Fri Mar 09, 2012 8:36 am

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.