Zeoslib Portal

btrewern

Using Zeos 6.5.1 Delphi 7.1 and PostgreSQL 8.1.4 I've been looking at saving files into Bytea fields on PostgreSQL and have found a few problems. It seems that currently there is no way of extracting files from the database without first loading them into a dataset and thereby into memory. Does anyo...

btrewern

Look at the help entries for the BDE TUpdateSQL component. The TZUpdateSQL works in a similar manner.

If you tell us what error you are getting, maybe someone could help you.

Regards,

Ben

btrewern

I use PostgreSQL and haven't looked at connection pooling yet. The server seems to be coping quite well. If you need to look at pooling then there are some delphi components at http://www.arcanatech.com which I'm going to look at in the near future.

Regards,

Ben

btrewern

I've used zeos in an intraweb application using multiple threads. Currently I create one connection per thread and everything works ok. I don't think you can use one connection for multiple threads without using critical sections. BTW Previously I've had problems using the TSQLMonitor. Have given up...

btrewern

Well, PostgreSQL has notifications which sound similar, but ZeosLib doesn't support them. It may be possible to use low level calls against libpq to get this working but don't know how. Sorry to not be of more help.

Ben

btrewern

I don't think the Personal Edition of Delphi 6 comes with dataset support so I think you'll have to try using Lazarus.

Regards,

Ben

btrewern

Give us an example of what you are trying to do and we should be able to help.

Regards,

Ben

btrewern

Sorry, didn't read all the question!

If you look http://seegernet.koolhost.de/zeosforum/ ... 6&start=15 you should see a proposal on how to add the suffixes as above.

Regards,

Ben

btrewern

There was mention of doing this some time ago. It may be in the svn version.

Regards,

Ben.

btrewern

I always use the Datasource property to do Master-Detail queries. Like the following: Query1.SQL.Text := 'SELECT * FROM Orders;'; DataSource1.Dataset := Query1; Query2.SQL.Text := 'SELECT * FROM OrderDetails WHERE OrderID = :OrderID'; Query2.DataSource := DataSource1; or something like that. Hope th...

btrewern

Run something like:

Code: Select all

SET search_path = test;

via a ZQuery and then for that connection you will be able to use

Code: Select all

SELECT * from tablename;

instead of

Code: Select all

SELECT * from test.tablename;

Regards,

Ben

btrewern

It looks like Delphi 5 has doesn't support Int64 in variants. I think a work round would be to use something like:

Code: Select all

FieldByName(FSequenceField).AsString := IntToStr(FSequence.GetNextValue);

Regards,

Ben

btrewern

Use * instead of %.

Regards,

Ben

btrewern

You could use transactions to do something similar. What database are you using and what exactly are you trying to do?

Regards,

Ben

btrewern

Find where ftInteger is declared and include that unit.

Regards,

Ben

Zeoslib Portal

Search found 193 matches

Memory usage with Blobs