Save to a text file

[nazbad]

Hi,

I'm new at C++ Builder,

How do I save a records set return by ADO Query to a text file?

Thanks

 

[Ginka]

I think there isn't a direct way to do that.

What you have to do is to write your own function and copy each record into a text file.

Something like this:

TStringList *MyTextFile = new TStringList ();
MyQuery->First();
for (int i=0; i<MyQuery->RecordCount; i++)
{
   /*You have to add the string conaining all the record, you can use delimitiers as ',' or tab characters, ro whatever you want*/

   MyTextFile->Append (YourPreparedString);  
   MyQuery->Next();
}
MyTextFile->SaveToFile ("AnyPath");
delete MyTextFile;

Your prepared string might be something like this:

AnsiString YourPreparedString;
YourPreparedString = MyQuery_Field1 + ", " + MyQuery_Field2 + ... etc;