Logic to determine if to use ExecSQL() or Open() ...

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

Article #292

Back to borland.public.cppbuilder.database.ado Previous Next

#292

From: Vladimir Stefanovic
Date: Tue, 27 Jun 2006 08:40

18 lines
1243 bytes

Hi,

I use BCB6, ADO, MS Access, Jet4.0.

If the user is free to write a query himself, what is the
best way to find out if to use ExecSQL() or Open()
command for the execution.

Is it enough to check for the speciffic keyword existence,
(SELECT, DELETE, ...) like with: StrPos() or similar, or
I should be aware of something else.




-- 
Best Regards,
Vladimir Stefanovic

Technical Details

Message-ID: <44a0eefa@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news4.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,e18a9574d33ec485,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Vladimir Stefanovic" <antivari@po.sbb.co.yu>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Logic to determine if to use ExecSQL() or Open() ...
Date: Tue, 27 Jun 2006 10:40:25 +0200
Lines: 20
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
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 82.117.212.65
Message-ID: <44a0eefa@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1151397626 82.117.212.65 (27 Jun 2006 01:40:26 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news4.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail