🚀 go-pugleaf

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