PowerBuilder - IDENTITYCOLUMN in MSSQL

Author

IDENTITYCOLUMN in MSSQL

Jeppe Havelund

2004-06-29, 4:09 pm

When I use the identitycolumn in datawindows on MSSQL, the generated
SQL-syntax for fetching the identitycolumn is "SELECT MAX(IDENTITYCOL)
FROM TABEL" instead of @@IDENTITY. We don't like that - we want the true
@@IDENTITY to be returned into the datawindow. Does anyone have a
solution to this topic?

--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Jeppe Havelund

2004-07-01, 4:01 pm

Got help from somewhere else. A DBParm callede AtAtIdentity exists -
setting this to 1 changes the query!
BR,
Jeppe

"Jeppe Havelund" <jeppe@havelund.dk> wrote in message
news:0c0f6b5e3c6dce2f0c870e02846bf654.82598@mygate.mailgate.org

> When I use the identitycolumn in datawindows on MSSQL, the generated
> SQL-syntax for fetching the identitycolumn is "SELECT MAX(IDENTITYCOL)
> FROM TABEL" instead of @@IDENTITY. We don't like that - we want the true
> @@IDENTITY to be returned into the datawindow. Does anyone have a
> solution to this topic?

--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Sponsored Links