🚀 go-pugleaf

Heres the link to the tutorial.

http://cslp.comp.nus.edu.sg/luakt/programming/Using%20ADO%20with%20Borland%2
0C++%20Builder%204.htm

Things to note, as far as I am aware if you have CBuilder5 and later you
have components at your disposal to use. [Ado Express] I only have Cbuilder
4 so I had to do it with code.

Also when you import the type libraries check the headers for syntax, my
TLB's had underscores added to some of the names ie, in the Tut it says

FieldPtr p = rs->Fields->get_Item(TVariant("CITY"));

my code would only compile with

Field* p = rs->Fields_->get_Item(TVariant("CITY"));

notice the difference

FieldPtr = Field* and Fields = Fields_

I admit, before I wrote the program I needed I never had worked with adodb
before, or automation.

Some other references I used are the ObjectModel for adodb 2.1 [This Helps
put it into perspective]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaxctrl/ht
ml/ado_objm.asp

or look up Kenneth Lassesen at the microsoft site.

and also I found this helpful

http://www.connectionstrings.com/

Most of the info I read on Vb is pretty much the same because it is a com
object and you use the Type Library.

I wrote the application in CBuilder and VB, it worked just as well in VB as
in CBuilder, except I had to write a binary/insertion sort for the listbox
on VB. My program fills a list box from a 40000 line excel spreadsheet, the
VB version actually fills the listbox faster. I am not quite sure why that
is, I would have expected the CBuilder version to be faster.

Hope this helps

regards Shaun