Tag: OLEDB

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!

Have you ever lost microseconds when working with the type TIME?
Definitely, if you have ever tried to use them. In the previous versions of IBProvider, time was stored in OLE DB structure of DBTYPE_DBTIME type that does not support fractions of a second.

In the new IBProvider version, time data types have been improved. The new properties dbtime_rules and dbtimestamp_rules allow to set time storage not only in DBTIME/DBTIMESTAMP but also in WSTR and in the new type of MS SQL 2008 – DBTIME2 without losing milliseconds.

Please, read more and download new IBProvider Professional right now: Download Firebird OLE DB driver.

Today we are (IBProvider team) overwhelmingly happy because we have finally released the final build of the 3rd version of IBProvider.

Is it possible to write a similar database driver?

Of course, you can write it! All you need is a strong desire and 7 years of free time. Exactly the same time it took us to write the third version of IBProvider.

Please read about development results here and download new Firebird driver here:
Firebird driver developers results

—
Regards, IBProvider Team.

Would you like to know how to avoid error messages like ‘arithmetic exception, numeric overflow, or string truncation’? in Firebird DBMS?

Please read related article here:
Three Reasons Why You Should Upgrade to the New IBProvider