Bizarre way to get MySql AutoIncrement to work....

[jorgemir]

Hi. Some time ago I posted this question on the forum. At the time there where no solution and I went into other chores. Now, I'm working again on the subjet. A form won't let you insert a record with an autoincrement field. Problem is: Valid values can not be zero or blank, and you can not give it a value because it must go with zero value to the MySql database in order to get autoincremented. Gray hair until I casually discovered tha priming the field with -1 actually do works Ok. Record is entered with right next autoincrement value and everything is ok.
I don't know real mechanism of this behavior. Maybe next NTWS version won't budge, but right now, with PR35 is working.
Cheers.
Jorge

[Bruce]

Hi Jorge,

Sounds like you've got the field set as "cannot be zero or blank" set in your dictionary. That would be where the NT validation comes from.

The -1 setting is a neat trick though, and one well worth knowing for MySql.

Cheers
Bruce