🚀 go-pugleaf

winprise <winprise@163.net> �������� � ������
<75dgcp$1dd13@forums.borland.com>...
> Hi! how do you do
>    How can I run a InterBase SQL script like
> "CreateTable.sql" in C++Builder Program.
> 
> 
> 
> 
> 
> 
> 

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;