Subj : Re: retreiving records from a MS SQL table
To   : borland.public.cpp.borlandcpp
From : mike
Date : Thu Jul 22 2004 07:10 pm

>    We are using ODBC & MS SQL to create a database table.  I'm trying to
> write the database table contents to a text file.  I'm using the Find()
and
> Next() methods to traverse the the table's records and the property
> RecordSize to allocate a buffer. When I use the method
> GetCurrentRecord(buffer)  only the first field is returned, not the entire
> record.  I've checked to make sure that the buffer is the correct size.
> What am I doing wrong ??

i assume you have your datasource all setup? from there you should use the
SQL API. for example SQLBind () will setup the table with the query you
spcify. you can then loop through SQLFetch () for each row.

since you didn't paste any code, i assume you setup the datasource
connection and connected to the database properly with no errors.

aloha,
mike

.