🚀 go-pugleaf

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

Releasing interface. You may set Variant to Unassigned or Null.

> 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?

Execute 2 insert statements. To ensure that value in Name column is unique,
add unique key to your table.

> 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?

Yes, it exists. You need it to examine resultset returned by SQL SELECT
query or table contents. If I am not wrong, recordset is empty when both BOF
and EOF are true. If not, execute MoveFirst() and see whether EOF is true.
You get field with recordet.Fields[i].Value or
recordset.Fields["fieldName"].Value. Iterate with MoveFirst() and
MoveNext().

//------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.managed-vcl.com
http://www.oledbdirect.com




"Ted Byers" <r.ted.byers@sympatico.ca> �������/�������� � ��������
���������: news:3fa2c14e$1@newsgroups.borland.com...
> 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
>
>