using LAST_INSERT_ID without being provider-specific

using LAST_INSERT_ID without being provider-specific

Postby linarms » Tue 23 Aug 2005 01:34

Hi,

I'm considering purchasing unidirect.net but its usefulness will be limited if I can't get the last inserted primary key back in a generic way. Obviously the query for MySQL is SELECT LAST_INSERT_ID() and for SqlServer it's SELECT @@IDENTITY, but I don't want my application code to even need to check which provider it's using.

Any ideas?

Cheers,

Luke
linarms
 
Posts: 1
Joined: Tue 23 Aug 2005 01:33

Postby Oleg » Wed 31 Aug 2005 08:11

UniDirect does not process SQL statements for different SQL servers. UniDirect just serves to provide universal data access. In the next versions we plan to work on this issue.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect Universal