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

[a...@a.com]

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() + ")");