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 ---- Original Message ----- From: "Rafael Copquin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2008 2:38 PM Subject: autoincremental values >I have a table with two fields configured as integer autoinc.This is a >father table. The child table is invdetails. > > Both tables are within a transaction > > The table is replicated in a cursor adapter, ie, the actual table is > invtotals.dbf and the cursor adapter is called curInvTotals > The autoinc fields are: > > id int autoinc with a current value of 1234 > ctl int autoinc with a current value of 5687 > > I append a record to the cursor (curInvTotals), add the data for all > fields, remove both autoinc fields from the CA and save everything with > tableupdate() > (the buffering is set to 5) The removal is done so as to avoid an error > since the autoinc fields are readonly (I do not want to use set > autoincerror) > > As a result of the addition of 1 record, the first field, (the PK) becomes > 1235. I obtain its value with getautoincvalue() and store it into a > property to be used for including in every record in the child table > (invdetails) > > My question is, how can I determine the value of the ctl field (which > should now have become 5688)? The getautoincvalue function only gives me > the increment value of the first field in the table (id), but not the > value of the second field (ctl) > > The pseudocode of what I am doing is: > > begin transaction > append one record to the father table (both autoinc fields add 1 to the > number already there) > replace the remaining records with the invoice total, taxes, date,customer > number, etc > remove both autoinc fields from the cursor (a cursor adapter) > save this table with tableupdate > get the PK value from the autoincremental field with getautoincvalue() > if save is OK proceed to saving all records in the child table > select child table > replace foreign key field in all records with PK from father table > (obtained with getautoincvalue) > save child table with tableupdate > if save is ok then end transaction otherwise rollback > > I need the second autoincremental value from the father table, the control > field ctl, to replace in the appropriate field in the child table. > > So again, how can I obtain this value? > > TIA > Rafael Copquin > > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ 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.
