Zeoslib Portal

Hello ExplorerTM,

I tried something like this some years ago for a small demo application. I used Lazarus and Zeos 6 at that time. Basically everything worked the same ways as with normal applications for PCs so any Zeos tutorial should do just fine.
Best regards,

Jan

Hello eelias, hmmm - I have to admit I have no good Idea what might be the problem. What happens if you use some external tool like isql to connect to the same database? Did you try to see what happens on the network using WireShark? Although I did not try that yet. Is it possible to migreate the da...

Hello Lukan,

the developer(s) of SQLite Administrator have not been seen here for quite some time now...
Best regards,

Jan

Hello jjeffman, your example is correct for the Setting AutoCommit = false. For AutoCommit = false you don't need to start a transaction explicitly by calling StartTransaction. But for AutoCommit = true your example is wrong. Remember - with AutoCommit = true every Database operation is followed by ...

Hello jjeffman, AutoCommit is there to mimic the way the BDE components work. Every Action to the database is one transaction and that transaction is committed immediately. Assume the following Code: ZConnection.AutoCommit := true; ZConnection.Connect; // Connect and start transaction => InTransacti...

Hello jjeffman,

thank you for the reply.
Best regards,

Jan

Hello jjeffman I had a look at my Delphi 6 documentation. The InTransaction property is registered for four Objects in my help system: TADOConnection, TDatabase, TIBTransaction, TSQLConnection. None of them specifies the behaviour you describe. As Zeos aimed (or aims) to be a replacement for the BDE...

Hello jjeffman, it seems to be a Zeos decision - at least for SQLite - but when you open a connection, transaction support is started immediately. Have a look at the file ZDbcSqLite.pas. One of the last things, the procedure TZSQLiteConnection.Open does, is a call to the procedure StartTransactionSu...

Hello jjeffman, trying to set the pragma from a query will not work because it cannot be set when there is a pending transaction in SQLite: This pragma is a no-op within a transaction; foreign key constraint enforcement may only be enabled or disabled when there is no pending BEGIN or SAVEPOINT. TZQ...

Hello jjeffman, as far as I know as soon as you are in a Database you always are in a transaction. So - the only question that GetInTransaction can answer wether there is an Transaction open that you need to commit explicitly. So - you either need to commit explicitly if you are in manual transactio...

Hello H3NRY, as far as I know the developer(s) of SQLite Administrator has not been seen in this forum for quite some time now. So most probably they will not see your feature request. Also I think that the development of this tool has been stopped because the only website, that I could find for thi...

Hello :) I am trying to get the metadata of tables by using a TZSQLMetadata. The environment is Firebird 2.1, Delphi XE2, Zeos 7.0.3. MetadataType is set to mdColumns. I have two issues with this setup: When I want to query the columns for a table UV_VERGLEICHE by setting TableName to UV_VERGLEICHE,...

Hello aleroot,

what happens if you use a query and do something like
select * from #tablename
or like
select * from [#tablename]
? And do you use Zeos 6.6 or 7.0? If you use 6.6, did you try 7.0?
Best regards,

Jan

Hello :) the PosgreSQL driver currently only allows to enable SSL, but it does not allow to set optins like to file where the CA certificate is stored or to provide settings for a client certificate and a client key. This patch enables these parameters for Zeos 6 and could also work for Zeos 7 as th...

Hello Michael, I did some digging around and it seems like the PostgreSQL driver is doing something odd, when it comes to setting the properties of the TZColumnInfos. It silently sets the source table of all fields in a result set to empty. But there seems to be a possibility call to get the table n...