TADOQuery->SQL->LoadFromFile ???

Thread View: borland.public.cppbuilder.database.ado

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Stephane Baillargeon Fri, 11 Aug 2006 23:31

#341

Author: Stephane Baillargeon
Date: Fri, 11 Aug 2006 23:31

16 lines
1405 bytes

I'm trying to load a .sql file using the LoadFromFile method. I've checked 
everything (file presence, connection string, and any kind of data that 
could be overwriting it) Nothing seems out of order.

Is it possible that this method has an error in it?

EX:

TADOQuery *padoQry = new TADOQuery( NULL );
padoQry->SQL->Clear();
padoQry->SQL->LoadFromFile( FileName );


padoQry->SQL->Text is equal to "??????\r\n"
?????????
it is supposed to be " SELECT * FROM Table \r\n"

Re: TADOQuery->SQL->LoadFromFile ???

#342

Author: Stephane Baillargeon
Date: Sat, 12 Aug 2006 00:21

28 lines
1717 bytes

I found this but I still want to know why it doesn't work?

 TStringList *sl = new TStringList();
 sl->LoadFromFile( strFile );
 padoQry->SQL-Text = sl->Text;
 delete sl;


"Stephane Baillargeon" <hidari__sei@hotmail.com> wrote in message 
news:44dd137d@newsgroups.borland.com...
> I'm trying to load a .sql file using the LoadFromFile method. I've checked 
> everything (file presence, connection string, and any kind of data that 
> could be overwriting it) Nothing seems out of order.
>
> Is it possible that this method has an error in it?
>
> EX:
>
> TADOQuery *padoQry = new TADOQuery( NULL );
> padoQry->SQL->Clear();
> padoQry->SQL->LoadFromFile( FileName );
>
>
> padoQry->SQL->Text is equal to "??????\r\n"
> ?????????
> it is supposed to be " SELECT * FROM Table \r\n"
>
>

Re: TADOQuery->SQL->LoadFromFile ???

#343

Author: Damian Murray
Date: Tue, 15 Aug 2006 00:24

42 lines
2234 bytes

Hi Stephane,
  Theres no error with this method, just you having a little 
misunderstanding...  The -->LoadFromFile(...) method is for reading in 
dataset that have been previously saved in XML or Borland Proprietary (ADTG) 
formats .   Read the C++ help section on using the 
TADODataSet->SaveToFile(...) and TADODataSet->LoadFromFile(...).

Damian


"Stephane Baillargeon" <hidari__sei@hotmail.com> wrote in message 
news:44dd1f29$1@newsgroups.borland.com...
>I found this but I still want to know why it doesn't work?
>
> TStringList *sl = new TStringList();
> sl->LoadFromFile( strFile );
> padoQry->SQL-Text = sl->Text;
> delete sl;
>
>
> "Stephane Baillargeon" <hidari__sei@hotmail.com> wrote in message 
> news:44dd137d@newsgroups.borland.com...
>> I'm trying to load a .sql file using the LoadFromFile method. I've 
>> checked everything (file presence, connection string, and any kind of 
>> data that could be overwriting it) Nothing seems out of order.
>>
>> Is it possible that this method has an error in it?
>>
>> EX:
>>
>> TADOQuery *padoQry = new TADOQuery( NULL );
>> padoQry->SQL->Clear();
>> padoQry->SQL->LoadFromFile( FileName );
>>
>>
>> padoQry->SQL->Text is equal to "??????\r\n"
>> ?????????
>> it is supposed to be " SELECT * FROM Table \r\n"
>>
>>
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads