🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #2556

Re: Using Builder 5 with Access 2000

#2556
From: Viatcheslav V. Vassiliev
Date: Mon, 26 May 2003 14:56
40 lines
2845 bytes
Speed. Variant::OleProperty, Variant::OleFunction (their equivalents) are
great for script languages, but in BCB you can call functions directly.

With TCOM_XXX you call interface functions directly, with
Variant::OleProperty, Variant::OleFunction you make a call through
automation - that is function/property name is converted into id, id into
function pointer, all parameters are converted from Variant to their type -
this takes quite much time, specially if you do this inside cycle. Another
plus is that with TCOM_XXX you will have code completion working.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Steve_Aletto" <steve_alettoANTI@SPAMhotmail.com> �������/�������� �
�������� ���������: news:3ed22079@newsgroups.borland.com...
> Maybe I'm boring you now but...
>
> Viatcheslav V. Vassiliev <support@oledbdirect.com> wrote in
> message 3ed21b77@newsgroups.borland.com...
> > I mean using ADO is CreateObject(ADODB.xxx) and using
> Access as COM server -
> > CreateObject(Access.xxx), for example,
> CreateObject(Access.Application).
> OK, clear.
>
> > You may have better results with importing ADODB type
> library and using
> > TCOM_Connection, TCOM_Recordset etc. than using Variant
> methods.
> That is my current solution in fact. In what it is better
> than using Variant methods? Speed, size, it's a more
> standard solution, ...?
>
> Steve.
>
>
Technical Details
Message-ID: <3ed22c1c$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <1lcecvstv6us8thh5pf3vhlrlncd0ju3op@4ax.com> <3eca2102$1@newsgroups.borland.com> <3ed1e749$1@newsgroups.borland.com> <3ed1ee7f@newsgroups.borland.com> <3ed1fc73$1@newsgroups.borland.com> <3ed21b77@newsgroups.borland.com> <3ed22079@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,448006c343e7d41
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-05-26 08:09:24 PST
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References:  <1lcecvstv6us8thh5pf3vhlrlncd0ju3op@4ax.com> <3eca2102$1@newsgroups.borland.com> <3ed1e749$1@newsgroups.borland.com> <3ed1ee7f@newsgroups.borland.com> <3ed1fc73$1@newsgroups.borland.com> <3ed21b77@newsgroups.borland.com> <3ed22079@newsgroups.borland.com>
Subject: Re: Using Builder 5 with Access 2000
Date: Mon, 26 May 2003 18:56:44 +0400
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 213.247.201.57
Message-ID: <3ed22c1c$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1053961244 213.247.201.57 (26 May 2003 08:00:44 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail