Re: VB Resync - Mailing list pgsql-odbc
Thank you, it works. Now, I have a single ADO control bound to my table "clients". To add a new record I do this: adoClients.Recordset.AddNew ... block of sentences ... adoClients.Recordset.Update And that works very fine. However when I make some changes and try to update, it raises an error adoClients.Recordset.Update "Row cannot be located for updating. Some values may have been changed since it was last read" Any Ideas, Best regards, MAGO -------Mensaje original------- keep track of the current value of the serial: dataenvironment.connection.execute "Insert Into Detail (FK, Field1, Field2, FieldN) select currval('whatever_the_PK\'s_sequence_name'),'" & intData1 & "','" & intData2 & "','" & intDataN & "');" HTH --- MRGonzalez <magotemp@hotmail.com> wrote: > I have an application where I save the information of a bill and its detail. > The PK of the header its a serial. > > I need to save the header and get the number of the serial to save it as a > FK in the detail. > > This is the way I wrote but it raise an error: > > header.recordset.update > header.recordset.resync adAffectCurrent, adResyncAllValues > > dataenvironment.connection.execute "Insert Into Detail (FK, Field1, Field2, > FieldN) Values (" & header.recordset!PK & "," & intData1 & "," & intData2 & > ," & intDataN & ")" > > Any suggestions? > > Thank you in advanced, > > > MAGO __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com | |||
Attachment
pgsql-odbc by date: