Accessing DB similar to how it's done in ASP using builder.

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

Article #50

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

#50

From: a
Date: Mon, 19 Jan 2009 02:02

28 lines
2087 bytes

Hi 

I apologise if this has already been asked in some form.

I am well used to accessing and manipulating an MS SLQ database using
ASP (and to a lesser extent PHP).

 I am used to using commands such as...

sqlquery = "select * from table"

rs = conn.execute(sqlquery)


and then looping through the results with 'rs('field')'


my question is this:  Is it possible to use, in builder, the same sort
of commands that are commonly used to manipulate ADO results in ASP,
and then use the results with VCL commands (for example query a
database of filenames and ids with a random number for the id, then
load an image on the form with the filename)
(or  loop through all the files in a directory adding them to the
table using...

conn.execute("insert into table (filename) values (" +
filename.c_str() + ")");

Technical Details

Message-ID: <pfm7n4hgdbg9i0db1b36nvvjlfnsuanc70@4ax.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!Xl.tags.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local02.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,9dce41453cfd5dfc,start
X-Google-Attributes: gid10698b,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!Xl.tags.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local02.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Sun, 18 Jan 2009 20:02:08 -0600
From: a@a.com
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Accessing DB similar to how it's done in ASP using builder.
Date: Mon, 19 Jan 2009 02:02:13 +0000
Message-ID: <pfm7n4hgdbg9i0db1b36nvvjlfnsuanc70@4ax.com>
X-Newsreader: Forte Agent 3.1/32.783
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 28
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-ufwDjms6JGEVREyGeBRZM5os+LXJxiYpPSLd8zbP8c09Qs4l2zQEa7W75cJwVpnvppSbhm87gNG5c71!5MBRTrUIrfEd+BF3ch6Qcp2zBAV39Ur9En1yq0VxaTSoB4wlRChZDpXvHci2VbVQiYqVvg==
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.39