Radicore Forum: Bug Reports » Insertorupdate and autoincrement

Home » RADICORE development » Bug Reports » Insertorupdate and autoincrement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Insertorupdate and autoincrement [message #1803 is a reply to message #1793]

Sat, 08 November 2008 11:11

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

I have modified the insertOrUpdate() method so that it calls isPkeyComplete() before performing the database lookup. If the primary key is not complete, such as when an auto_increment column has not been specified, then it will skip the lookup and force an INSERT.

It is therefore imperative that when wanting to perform an INSERT on a table which contains an auto_increment key that the column does not appear in the field array. If it appears with any value, even NULL or ZERO, then isPkeyComplete() will return TRUE and a lookup will be performed.

Please see the attached file for the patched code.

Attachment: radicore-2008-11-08-update2.zip
(Size: 133.90KB, Downloaded 1366 times)

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Insertorupdate and autoincrement By: bonzo_bcn on Thu, 06 November 2008 05:46
		Re: Insertorupdate and autoincrement By: AJM on Thu, 06 November 2008 09:09
		Re: Insertorupdate and autoincrement By: AJM on Sat, 08 November 2008 11:11

Previous Topic:	Multi2 -> popup2 not calling _cm_pre_updateRecord?
Next Topic:	Problem with accentuated char and Uppercase

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Aug 17 10:42:47 EDT 2025

Total time taken to generate the page: 0.01145 seconds