Select ROWID From MS SQL 2000

forum.sourcecode (2000-2005) & (2005-2010)
Do Mai Huy

Select ROWID From MS SQL 2000

Post by Do Mai Huy » 23 Jun 2007, 14:53

 Posted by:  Do Mai Huy 

Hi All

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

Thank you



Re: Select ROWID From MS SQL 2000

Post by Kris » 23 Jun 2007, 17:45

 Posted by:  Kris 

In mssql you should create timestamp type of column with name i.e,
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)


Jeff Luther
Site Admin
Site Admin
United States of America
Posts: 2370
Joined: 04 Mar 2017, 18:34
Location: Palm Springs, California

Re: Select ROWID From MS SQL 2000

Post by Jeff Luther » 23 Jun 2007, 19:07

 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:

Return to “td.sourcecode”

Who is online

Users browsing this forum: [Ccbot] and 0 guests