Hi Tim,

Using ElevateDB and the EWB Server, will EWB support Update and Delete queries at some point?

Cheers,
Paul

Paul,

<< Using ElevateDB and the EWB Server, will EWB support Update and Delete queries at some point? >>

I'm not quite sure what you're asking.  Are you asking whether you'll be able to *specify* the update and delete queries for datasets in EWB 3 ?  If so, then the answer is yes.  The datasets in EWB 3 allow you to specify the select, insert, update, and delete SQL, as this is necessary for allowing access to SQL Server, etc. to use output parameters to echo generated/computed column values back to the EWB client application for inclusion in the dataset on the client.

Tim Young
Elevate Software
www.elevatesoft.com

Tim

<<The datasets in EWB 3 allow you to specify the select, insert, update, and delete SQL. >>

Will we also be able to BACKUP DATABASE, RESTORE RESTORE and SET BACKUPS STORES statements?

Richard

Hi Tim,

Tim Young [Elevate Software] wrote:

<< If so, then the answer is yes.

Yes, this is what I meant. Excellent, sounds great.

Cheers,
Paul

Richard,

<< Will we also be able to BACKUP DATABASE, RESTORE RESTORE and SET BACKUPS STORES statements? >>

Sure, but you'll have to execute those from a server-side application.  IOW, you can't use datasets for DDL, only for DML operations.

Tim Young
Elevate Software
www.elevatesoft.com