[Message Prev][Message
Next][Thread Prev][Thread Next][Message
Index][Thread Index]
Whoops - Typo ....Re: xPLMediaNet - Need some .net oledb help
please
- Subject: Whoops - Typo ....Re: xPLMediaNet - Need some .net
oledb help please
- From: "Keith Doxey" <ukha@xxxxxxxxxxx>
- Date: Tue, 26 Jul 2005 08:20:59 -0000
> Another option which should work for any type of database is
>
> INSERT INTO <table> (KeyField, FieldOne, FieldTwo) VALUES (MAX
(KeyField+1), 'Wibble', 'Wobble')
>
Slight typo....
Should be ....
INSERT INTO <table> (KeyField, FieldOne, FieldTwo) VALUES (MAX
(KeyField)+1, 'Wibble', 'Wobble')
eg MAX(KeyField)+1 NOT (Max(KeyField+1)
Why do mistakes ONLY show after sending :-(
Keith
xPL Links: http://www.xplproject.org.uk http://www.xplhal.com http://www.xpl.myby.co.uk
To Post a Message: ukha_xpl@xxxxxxx
To Subscribe: ukha_xpl-subscribe@xxxxxxx
To Unsubscribe: ukha_xpl-unsubscribe@xxxxxxx
xPL Main Index |
xPL Thread Index |
xPL Home |
Archives Home
|