SQL

SQL

Post by Dan Perlma » Wed, 15 Aug 2001 00:52:29



Hi,

I have been trying to find the answer to this for a week now.

I am trying to select a record from an access table using an sql statement
in a data environment command.

It seems like whatever I do I get "Failed getting rowsets from current data
source"

The database is cost.mdb, the table is ROS, the field name is "Job ID" and
the record I want to get is the one that matches FormROS.TextJobID.Text

Does the sql box in the data environment command actually work?
I am starting to think not.

As always,

I appreciate any advise,

Thanks,

Dan