Zeoslib Portal

trupka

I did few tests with current testing version and there is a bug with blob handling and ADO. Can you provide some simple example? I assume you used varbinary for blob data? What Delphi / Zeos version are you using?

trupka

Hi,
I'm not sure I completely understand your problem but, did you try something like this:

Code: Select all

with ZQuery do
  begin
    Insert;
    TBlobField( fieldByName('the_blob')).LoadFromFile('THE_FILE');
    Post;
  end;

trupka

mdaems , this patch is VERY DANGEROUS and can cause data loss. Specifically ... procedure TZAbstractDataset.InternalDelete; var RowNo: Integer; RowBuffer: PZRowBuffer; i: Integer; Detailsets: TList; ds: TZAbstractDataset; begin Detailsets := TList.create; getdetaildatasets(Detailsets); for i := 0 t...

trupka

It is possible to use remote server for sqllite but only through some kind of file sharing. Example for Windows (smb/cifs) networks: ZConnection1.HostName := ''; ZConnection1.Database := '\\server\share\database_file'; ZConnection1.Connect; but this is one of those not-so-good ideas. Better use some...

trupka

It is hard to find a generic solution for your problem. You can fetch select directly into txt file with something like ZReadOnlyQuery.SQL := 'copy (select something with join ...) to E'c:\\tmp\\copy_test.txt' with CSV; ZReadOnlyQuery.ExecSQL; and avoid memory issues - you will have local txt file w...

trupka

Hi, what means slow to you? count(*) shouldn't be very slow. On my development machine count with similar table with cca 500 000 records executes under 200 msec. Is your postgres server configured correctly? Size of shared_buffers param? If you don't need exact number of records you can try with: se...

trupka

Never encountered something like this (Delphi 7-2010, Pg8.3 - 9.0).
Are you using joins in SQL?

trupka

rockyoh,
did you specify codepage in ZConnecton?

trupka

you can find those inside mysql server installation dir, usually in *\lib\opt.
libmysql{number}.dll are same thing as libmysql.dll but renamed to corresponding server version.

trupka

Hi Mark, "forcing" zeoslib to use bytea_output format in escape mode is possible but won't cover all possibilities - format can be changed in many places - server configuration, database and role configuration, session level and even per transaction or inside stored procedure (function). W...

trupka

I did some investigations and it seems that problem lies in pg 9 client changes so it's not zeos specific (actually, it's more feature then bug :wink: ) Here is excerpt from pg 9 change log: --- bytea output now appears in hex format by default (Peter Eisentraut) -- I just want to warn all of you wh...

trupka

bser,
What Zeos/postgres versions are you using?
I'm using pg9 with Zeos 7 and it works fine to me.

trupka

I think that native MSSQL client lib doesn't exist under linux but, sybase dblib have very similar protocol as MSSQL server - both products have same roots. So you might try Sybase dblib driver ( for linux client lib take a look at freetds.org).

trupka

Try this:
clear MasterFields and MasterSource properties
set
DetailQuery.Datasource := MasterQuery.DataSource

Check that DetailQuery param names are the same as corresponding master fields.

trupka

So when i insert on Computer A a record on a ztable i send to the FB but computer B is not notified ( even i do ztable.refresh ). People who start to program C/S often asks that question - in short: Computer B have no idea that table is changed unless you use some NOTIFY (see TZIBAlerter component)...

Zeoslib Portal

Search found 140 matches

Re: Multiple Users - Many other questions