Thread View: borland.public.cppbuilder.database.ado
5 messages
5 total messages
Started by sam
Wed, 03 Jan 2007 07:07
Help!! ADO Refresh causes error
Author: sam
Date: Wed, 03 Jan 2007 07:07
Date: Wed, 03 Jan 2007 07:07
17 lines
1128 bytes
1128 bytes
Help The following line of code DataMaster->MYTable->Refresh(); gives me the following Message Debugger Exception Notification Project my.exe raised exception class EOleException with Message 'Insuffient key column information for updating or refreshing' How can I resolve this. TIA Sam
Re: Help!! ADO Refresh causes error
Author: Vassiliev V. V.
Date: Wed, 03 Jan 2007 10:27
Date: Wed, 03 Jan 2007 10:27
34 lines
1904 bytes
1904 bytes
Ensure that you have PK or at least unique index in table you are refreshing. //------------------------------------------ Regards, Vassiliev V. V. http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + ADO.Net http://www.oledbdirect.com - The fastest way to access MS SQL Server, MS Jet (Access) and Interbase (through OLEDB) "sam" <sam@nospam.com> �������/�������� � �������� ���������: news:459b560c$2@newsgroups.borland.com... > Help > > The following line of code > DataMaster->MYTable->Refresh(); > > gives me the following Message > > Debugger Exception Notification > Project my.exe raised exception class EOleException with Message > 'Insuffient key column information for updating or > refreshing' > > How can I resolve this. > > TIA > > Sam > > >
Re: Help!! ADO Refresh causes error
Author: sam
Date: Thu, 04 Jan 2007 00:14
Date: Thu, 04 Jan 2007 00:14
54 lines
2318 bytes
2318 bytes
Vassiliev Thank you for your reply. I have a PK in the Table What happens is if a record is changed by a second user on another PC And I then change the record in the datagrid the application gives me a error when I move to the next record. How do I overcome this? How do I refresh a client dataset without getting errors? Thanks in Advance Sam "Vassiliev V. V." <support@oledbdirect.com> wrote in message news:459b8503@newsgroups.borland.com... > Ensure that you have PK or at least unique index in table you are > refreshing. > > //------------------------------------------ > Regards, > Vassiliev V. V. > http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + > ADO.Net > http://www.oledbdirect.com - The fastest way to access MS SQL Server, > MS Jet (Access) and Interbase (through OLEDB) > > > "sam" <sam@nospam.com> �������/�������� � �������� ���������: > news:459b560c$2@newsgroups.borland.com... >> Help >> >> The following line of code >> DataMaster->MYTable->Refresh(); >> >> gives me the following Message >> >> Debugger Exception Notification >> Project my.exe raised exception class EOleException with Message >> 'Insuffient key column information for updating or >> refreshing' >> >> How can I resolve this. >> >> TIA >> >> Sam >> >> >> > >
Re: Help!! ADO Refresh causes error
Author: Vassiliev V. V.
Date: Thu, 04 Jan 2007 21:30
Date: Thu, 04 Jan 2007 21:30
69 lines
3084 bytes
3084 bytes
Try to set recordset property 'Update Criteria' to adCriteriaKey. //------------------------------------------ Regards, Vassiliev V. V. http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + ADO.Net http://www.oledbdirect.com - The fastest way to access MS SQL Server, MS Jet (Access) and Interbase (through OLEDB) "sam" <sam@nospam.com> �������/�������� � �������� ���������: news:459c47d0@newsgroups.borland.com... > Vassiliev > > Thank you for your reply. > I have a PK in the Table > What happens is if a record is changed by a second user on another PC > And I then change the record in the datagrid the application gives me a > error > when I move to the next record. > How do I overcome this? > > How do I refresh a client dataset without getting errors? > > Thanks in Advance > > Sam > > "Vassiliev V. V." <support@oledbdirect.com> wrote in message > news:459b8503@newsgroups.borland.com... >> Ensure that you have PK or at least unique index in table you are >> refreshing. >> >> //------------------------------------------ >> Regards, >> Vassiliev V. V. >> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + >> ADO.Net >> http://www.oledbdirect.com - The fastest way to access MS SQL Server, >> MS Jet (Access) and Interbase (through OLEDB) >> >> >> "sam" <sam@nospam.com> �������/�������� � �������� ���������: >> news:459b560c$2@newsgroups.borland.com... >>> Help >>> >>> The following line of code >>> DataMaster->MYTable->Refresh(); >>> >>> gives me the following Message >>> >>> Debugger Exception Notification >>> Project my.exe raised exception class EOleException with Message >>> 'Insuffient key column information for updating or >>> refreshing' >>> >>> How can I resolve this. >>> >>> TIA >>> >>> Sam >>> >>> >>> >> >> > >
Re: Help!! ADO Refresh causes error
Author: sam
Date: Fri, 05 Jan 2007 07:32
Date: Fri, 05 Jan 2007 07:32
86 lines
3455 bytes
3455 bytes
Vassiliev Again Thank you very much for your help. DataMaster->MYTable->Requery(); Did the trick It updates the local dataset from the server Then I perform the update and all is OK Regards Sam "Vassiliev V. V." <support@oledbdirect.com> wrote in message news:459d71ab$1@newsgroups.borland.com... > Try to set recordset property 'Update Criteria' to adCriteriaKey. > > //------------------------------------------ > Regards, > Vassiliev V. V. > http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + > ADO.Net > http://www.oledbdirect.com - The fastest way to access MS SQL Server, > MS Jet (Access) and Interbase (through OLEDB) > > > "sam" <sam@nospam.com> �������/�������� � �������� ���������: > news:459c47d0@newsgroups.borland.com... >> Vassiliev >> >> Thank you for your reply. >> I have a PK in the Table >> What happens is if a record is changed by a second user on another PC >> And I then change the record in the datagrid the application gives me a >> error >> when I move to the next record. >> How do I overcome this? >> >> How do I refresh a client dataset without getting errors? >> >> Thanks in Advance >> >> Sam >> >> "Vassiliev V. V." <support@oledbdirect.com> wrote in message >> news:459b8503@newsgroups.borland.com... >>> Ensure that you have PK or at least unique index in table you are >>> refreshing. >>> >>> //------------------------------------------ >>> Regards, >>> Vassiliev V. V. >>> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + >>> ADO.Net >>> http://www.oledbdirect.com - The fastest way to access MS SQL Server, >>> MS Jet (Access) and Interbase (through OLEDB) >>> >>> >>> "sam" <sam@nospam.com> �������/�������� � �������� ���������: >>> news:459b560c$2@newsgroups.borland.com... >>>> Help >>>> >>>> The following line of code >>>> DataMaster->MYTable->Refresh(); >>>> >>>> gives me the following Message >>>> >>>> Debugger Exception Notification >>>> Project my.exe raised exception class EOleException with Message >>>> 'Insuffient key column information for updating or >>>> refreshing' >>>> >>>> How can I resolve this. >>>> >>>> TIA >>>> >>>> Sam >>>> >>>> >>>> >>> >>> >> >> > >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads