🚀 go-pugleaf

Thanks,

This is greatly appreciated.

What exactly is the purpose of statements like:
> cat = null;
> conn = null;

I assume they're equivalent to:
// assuming Variant cat,comm;
// & assuming cat and conn are initialized as in our example code
cat = null;
conn = null;

Do you have an example of the SQL required to update a pair of tables
related to each other through an autoincremented index field like the two
shown in your example?  For example, suppose I have the following
(deliberately using variable names matching the coresponding fields in the
two tables):

AnsiString Name("carrot"), col2(something else);

What would be the SQL statement to place the values held by these two
variables into the two tables in the database, while ensuring that the value
"carrot" is not duplicated in the table called JUNK?

Is there also a "ADODB.RecordSet"?  If so, how does one determine if it is
empty, and how does one get the values for a given field using it when it is
not empty, and how does one iterate through it's records?

Thanks again,

Ted