mORMot Open Source

emk

Member

Registered: 2013-10-24

Posts: 96

TSQLDBConnectionProperties and SQL Script

Taking the response of @ab from http://stackoverflow.com/questions/3651 … onnections I would like to re-evaluate using TSQLDBConnectionProperties as database connection, but I think I reached a wall: It supports executing a SQL script?

My Delphi clients assembly a Firebird script like "execute block as ... insert.., update..., delete..." which I need to upload to server and execute it.

EMartin

Member

From: Buenos Aires - Argentina

Registered: 2013-01-09

Posts: 336

Re: TSQLDBConnectionProperties and SQL Script

No, to execute blocks in Firebird I had to create the TZConnection from TSQLDBConnectionProperties and then execute the block with TZQuery. I suppose that in other RDBMS the problem is similar.

Esteban.

---

Esteban

emk

Member

Registered: 2013-10-24

Posts: 96

Re: TSQLDBConnectionProperties and SQL Script

You exposed a TZConnection from main connection of TSQLDBZEOSConnectionProperties? because I think it's not possible because like I saw in source code, TSQLDBConnection passes work to "Properties" thru a OnProcess callback.

I think you created a new TZConnection, so for my case, at the moment I can't use TSQLDBZEOSConnectionProperties.

Last edited by emk (2016-04-12 13:22:17)

EMartin

Member

From: Buenos Aires - Argentina

Registered: 2013-01-09

Posts: 336

Re: TSQLDBConnectionProperties and SQL Script

I create and destroy the component TZConnection and TZQuery because they don't have heavy use in my application. The TSQLDBZEOSConnectionProperties it has not implemented the callable statements.

---

Esteban