The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[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

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.