🚀 go-pugleaf

Yes it will

Robert

winprise wrote:

> Hi nikoly:
>   Thank you for your answer.
> But I want to run a full SQL Script in BCB.
> The Script include create table and Store_procedure.
> I just want to know Can TQUERY suport to run Store_procedure
> even whole Script language.
>
> >Hi winprise.
> >
> >First you must create a TQuery.
> >Next, assign a SQL property of this query a string list withs your SQL text
> >Next execute a method ExecSQL of this Query.
> >Note, what you must disable a table schema cache in your BDE ALIAS.
> >like SCHEMA CACHE SIZE=0
> >
> >for example:
> >
> >TQuery *Query = new TQuery(0);
> >Query->SQL->Add("CREATE TABLE TEST (FIELD1 INTEGER,FIELD2 INTEGER)");
> >Query->ExecSQL();
> >delete Query;
> >
> >