Zeoslib Portal

Problem solved. It seems to be a regression from 6.1.5, but it's possible to use the TZSQLProcessor to do multi-statements.

More info in this thread http://seegernet.koolhost.de/zeosforum/ ... .php?t=299

I'm afraid it doesn't change anything. That's basically what I did (except for using TZReadOnlyQuery). I tried 6.5.1-alpha, lastest CVS, and 6.1.5-stable. I think it's confused by the ';' at the end of an SQL statement. Did you strip comments, or change your SQL in any way ? I guess I'll have to spl...

Hello, I'm trying to run a generated SQL script as one SQL query, but keep getting errors when parsing request. I tried TZQuery.SQL.Text TZQuery.SQL.LoadFromFile(), ... but to no avail. Am I overlooking something ? Is there a supported way to run a script against an already connected DB ? Thanks in ...

Hello, No, you can't just use localhost (that would assume the server is running which is not the case). Just use the filename as the database name, and an empty host. Connection := TZConnection.Create(myOwner); Connection.Protocol := 'firebird-1.5'; Connection.HostName := ''; Connection.Database :=...

Hello, I'm using zeoslib alpha with Delphi 7 on an embedded Firebird DB doing a batch insert in a table (between 300K and 18M records). Basically, I read from an ASCII file, convert some values, and create the SQL query to insert a new row. On average speed is about 500 records/s. I played a bit wit...

Hello, I was pleased to see the forum is back online, and just upgraded to the lastest Sourceforge released CVS. I'm having a problem with code which worked perfectly with previous release. I'm trying to create an embedded Firebird database. I use something like this Connection := TZConnection.Creat...