Re: Getting the primary key in an update query

2003-09-10 Thread Daniel Rossi
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

2003-09-10 Thread Roger Baklund
* 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

Getting the primary key in an update query

2003-09-10 Thread 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 each table and i'm trying t