Article View: borland.public.cppbuilder.database.ado
Article #498Re: "Index does not exists" error
From: Foo Tze Wan
Date: Tue, 23 Aug 2005 09:35
Date: Tue, 23 Aug 2005 09:35
23 lines
1828 bytes
1828 bytes
Thanks Viatcheslav, for your insight. Will also read up on "forward-only" datasets to understand more. I have posted yet another question on blob fields... Regards, Tze Wan "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message news:4305ed48$1@newsgroups.borland.com... I do not known OLEDB provider other than MS Jet that supports Seek. AFAIK, Interbase/Firebird support only forward-only datasets in their API, so using Seek needs cache of rows implemented somewhere. Use client-side cursor and Locate if you have not much data, or execute query with WHERE ID = 1234. //------------------------------------------ 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)
Technical Details
Message-ID:
<430aedd3@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!npeer.de.kpn-eurorings.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<4305af80@newsgroups.borland.com> <4305ed48$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,33bf2af7391abfed X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII-7-bit Reply-To: "Foo Tze Wan" <twfoo@nospam.com> From: "Foo Tze Wan" <twfoo@nospam.com> Newsgroups: borland.public.cppbuilder.database.ado References: <4305af80@newsgroups.borland.com> <4305ed48$1@newsgroups.borland.com> Subject: Re: "Index does not exists" error Date: Tue, 23 Aug 2005 17:35:31 +0800 Lines: 27 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 NNTP-Posting-Host: 210.24.189.100 Message-ID: <430aedd3@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1124789715 210.24.189.100 (23 Aug 2005 02:35:15 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!npeer.de.kpn-eurorings.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail