Re: Getting the primary key in an update query

that works cheers >>> "Roger Baklund" <[EMAIL PROTECTED]> 09/11/03 10:48am >>> * Daniel Rossi > Hi there i was wondering if there was anyway to determine the > primary key field instead of explicitly setting it in an update > sql query ? > > for instance i'd like to go update table *** where prima

Re: Getting the primary key in an update query

* Daniel Rossi > Hi there i was wondering if there was anyway to determine the > primary key field instead of explicitly setting it in an update > sql query ? > > for instance i'd like to go update table *** where primarykey=1 > instead of where id=1 as the primary key is named differentrly > for e