Know how to add execution of SQL-scripts in your programs!

online poker news

Do you want to enable execution of SQL scripts in your programs and spend less time for exhausting coding?

Do you want to create a table, a generator and a trigger, to add data to the table, to make data selection and then to delete all this in one command? For example:


set autoddl on;
set transaction;
create generator GEN_ID_TEST_TABLE;
create table TEST_TABLE (ID INTEGER NOT NULL PRIMARY KEY,TEXT BLOB SUB_TYPE TEXT);
create trigger BI_TEST_TABLE for TEST_TABLE
 before insert
 as
 begin
  if(NEW.ID IS NULL) then NEW.ID=GEN_ID(GEN_ID_TEST_TABLE,1);
 end;
insert into TEST_TABLE (text) values('record 1');
insert into TEST_TABLE (text) values('record 2');
set term !!;
select * from TEST_TABLE!!
set terminator ;!!
TEST_TABLE;
set autoddl off;
drop table TEST_TABLE;
drop generator GEN_ID_TEST_TABLE;
commit;

Now it is possible with new IBProvider! IBProvider v.3.3.0.11117 allows to run a command with several SQL queries (SQL scripts).

Read more right now:
Know how to add execution of SQL-scripts for Firebird and Interbase in your programs!

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Leave a Reply