Question about INIT.

ForeverBlue

hi,

I create a form that user will input some data and a button to record into a table. in the button I have the following code.

record.init;
record.name := name;
record.address := address;
..... ....
... ...

record.insert;
commit;

The Table primary key is a field name ID and it's integer. I have set the property AutoIncrement = Yes and on the form level I have set AutoSplitKey = yes.

now the problem is after i save the first record, change the value on the form try to save it as a new record, it will give me a error of primary key is already exist. Correct me if I am wrong, I thought INIT will create a new record with new primary key?

bbrown

INIT does not clear the primary key.

ForeverBlue

hmmmm
I move record from global to the button's OnPush local and fix the problem.

bbrown

Yes, that would work since your record variable would go out of scope each time the OnPush code ends. Also that hard commit is not needed if this is all in the OnPush trigger.

kriki

Check here (http://www.mibuso.com/howtoinfo.asp?FileID=22) for some info on INIT (and other info).