SQL Queries

Our genealogy database program.

Moderator: Nick Hunter

Post Reply
cpt_tom
Posts: 1
Joined: Thu Mar 08, 2012 5:30 pm
Location: United States

SQL Queries

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
Posts: 669
Joined: Sun Dec 18, 2005 9:36 am
Location: SpanSoft, Scotland
Contact:

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.

Post Reply