ROW ID problem  
Author Message
Elvira Zeinalova





PostPosted: 2003-12-5 18:21:00 Top

java-programmer, ROW ID problem Hi,
I am wtiting JAVA application and getting datas from MS SQL.
This is the code:

QueryDataSet ds = new QueryDataSet();
ds.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor
(db,"select * from myTable"));

In myTable there is one column defined as "primary key".
But dataset(ds) does not get rowID automatically. I have
to disable updateRowID in MetaDataUpdate for dataset, and
then set rowID to the column manually

I had no problem in Sybase, but now I have changed to MS
SQL. Any idea? May be it is some connection property I
have not checked out?

Thanks beforehand.