DataSource

Return to Introduction  Previous page  Next page

Returned by datasources.datasourceid from anywhere in the document.

 

Methods

 

executeSQL(command, [storedatasetid])

Executes the SQL 'cmd' string on this connection.  If you pass a second string of a dataset id, this is where the results of the SQL command will be stored.

setSQL(command, datasetid)

Changes the SQL selection command on a dataset in this connection.

 

Examples

 

datasources.datasource_1.executeSQL('DELETE FROM Log'); // empty the Log table

 

See Also

 

Script Reference



Copyright ©2004 Worldweaver Ltd. DX Studio Home