[dba-VB] Command Objects within Data Environments

paul.hartland at fsmail.net paul.hartland at fsmail.net
Mon Jun 16 10:05:53 CDT 2003

To all,

I have a DataEnvironment (DEEmploy), which has a command tblEmps which uses a SQL Statement to get all the records from tblEmps like so :


Now I have reached a point where I only want to bring one employee back from the back-end, so what I need to know is can I build a SQL statement on the fly (something like (SELECT TOP 1 * FROM tblEmps) or (SELECT * FROM tblEmps WHERE (Criteria)) ) and assign that select statement to the Command object tblEmps so that it only returns employees that meet the criteria thats been built on the fly....

Thanks in advance for any help


Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application.

More information about the dba-VB mailing list