----- Original Message ----- From: "Rafael Copquin" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, September 24, 2008 4:24 PM Subject: Re: autoincremental values
> > Further to the below, I just discovered that in reality, it is the second > autoinc field that getautoincvalue() takes its value from. But my problem > is > still the same. I simply moved the pk field from position 1 in the table > to > the last position, ie it becomes the last field in the table. > Getautoincvalue gets its value from this field. > > Now, in order to get the autoinc value from the first field (Ctl), I do a > tableupdate and immediately afterwards I read the PK autoinc value with > the > above function and the CTL field autoinc value directly from the table > (not > the cursor adapter) > > Is there a better way? > Rafael Copquin Hello Rafael. I would like to know : why do you need a second autoincremented field to be copîed in each record of the child table ? Using normal form, you might just put the pk in the child table, and access to the father table to retrieve the second field ! Gérard. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
