Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread 4.46 problem
Mon, Mar 4 2019 6:03 AMPermanent Link

Mirco Malagoli

Hi,
after upgrade from 4.43b4 to 4.46b1 this query no longer works:

INSERT INTO classProva
(idClass, prova) VALUES ( LASTAUTOINC( 'classif'), -1)

The lastautoinc values is always 0 but in 4.43 the value is correct.
Is this normal?
Thanks!
Mirco
Mon, Mar 4 2019 2:03 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mirco,

<< after upgrade from 4.43b4 to 4.46b1 this query no longer works:

INSERT INTO classProva
(idClass, prova) VALUES ( LASTAUTOINC( 'classif'), -1)

The lastautoinc values is always 0 but in 4.43 the value is correct. >>

Yes, this is an issue with INSERT statements and LASTAUTOINC (SELECT works fine) that was broken during one of the updates in-between.

I'll have a new build out soon with a fix.

Tim Young
Elevate Software
www.elevatesoft.com
Image