Select ROWID From MS SQL 2000

[Do Mai Huy]

 Posted by:  Do Mai Huy 

Hi All

I connect my Application to ms sql 2000 but I can not select ROWID same SQL
Base.
Help me Select it.

Thank you

DMH

[Kris]

 Posted by:  Kris 

In mssql you should create timestamp type of column with name i.e,
'timestamp'
and bind it to string var/column (colTimestamp ) in GTD.
later if you would like to make update/delete using this rowid just do like
this 'update table set col1 = :GtdCol1 where timestamp = :colTimestamp '
or 'update table set col1 = 51 where timestamp = 0x' || sTimestamp ' if you
can not use bind vars (i.e. OdrExecuteProc)

hth
Kris

[Jeff Luther]

 Posted by:  Jeff Luther 

In another msg. Kris shows you how to substitute timestamp for SQLBase's ROWID.

"I can not select ROWID" - this is because there is no ROWID column with MS
SQLServer. ROWID and its behaviour in changing for any insert/update of the
row is specific to SQLBase. (Oracle has a ROWID column, but works in a
different way.)

Best Regards,
Jeff @ PC Design
info. & samples: www.JeffLuther.net/gupta/