Re: [lazarus] problems with SQLdb components and Postgres

2006-08-01 Thread johnf
On Tuesday 01 August 2006 10:05, Alexsander Rosa wrote: > So the best thing for PostgreSQL users is to bury sqldb for good and > use Zeos instead? Is this correct? Not to be rude - but that's bull. SQLdb works. It may have a few issues but so does Zeos. John

Re: [lazarus] problems with SQLdb components and Postgres

2006-08-01 Thread Alexsander Rosa
the problem is not in SQLdb, but in FPC itself? Regards, Zlatko - Original Message - From: "Alexsander Rosa" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 01, 2006 7:05 PM Subject: Re: [lazarus] problems with SQLdb components and Postgres So the best thing for PostgreSQL

Re: [lazarus] problems with SQLdb components and Postgres

2006-08-01 Thread Zlatko Matić
ander Rosa" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 01, 2006 7:05 PM Subject: Re: [lazarus] problems with SQLdb components and Postgres So the best thing for PostgreSQL users is to bury sqldb for good and use Zeos instead? Is this correct? 2006/7/28, Alexandre Leclerc <[EMAIL

Re: [lazarus] problems with SQLdb components and Postgres

2006-08-01 Thread Alexsander Rosa
So the best thing for PostgreSQL users is to bury sqldb for good and use Zeos instead? Is this correct? 2006/7/28, Alexandre Leclerc <[EMAIL PROTECTED]>: 2006/7/28, Zlatko Matić <[EMAIL PROTECTED]>: > Unfortnately, Lazarus+PostgreSQL doesn't work properly with recent snapshots > such as Lazarus-

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-28 Thread Alexandre Leclerc
2006/7/28, Zlatko Matić <[EMAIL PROTECTED]>: Unfortnately, Lazarus+PostgreSQL doesn't work properly with recent snapshots such as Lazarus-0.9.17-20060728-win32.exe. It was O.K. with Lazarus-0.9.17-20060703-win32.exe and now it doesn't work with recent snapshots. I thought that the bug was fixed.

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-28 Thread Zlatko Matić
? Regards, Zlatko - Original Message - From: "Zlatko Matić" <[EMAIL PROTECTED]> To: Sent: Monday, July 03, 2006 5:11 PM Subject: Re: [lazarus] problems with SQLdb components and Postgres Hi! I downloaded the most recent snapshot (Lazarus-0.9.17-20060703-win32.exe

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-04 Thread joost
On Tue, 4 Jul 2006, Alexandre Leclerc wrote: > 2006/7/4, Marc Weustink <[EMAIL PROTECTED]>: > > Joost van der Sluis wrote: > > > > [snip] > > > > /me just jumping in, so might probably completely clueless > > > > > If you open the table, the postgresql-client will allocate some memory > > > to sto

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-04 Thread joost
On Tue, 4 Jul 2006, Marc Weustink wrote: > Joost van der Sluis wrote: > /me just jumping in, so might probably completely clueless > > > If you open the table, the postgresql-client will allocate some memory > > to store the data. That'll be 10+8=18 bytes plus something dependent on > > it's ow

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-04 Thread Alexandre Leclerc
2006/7/4, Marc Weustink <[EMAIL PROTECTED]>: Joost van der Sluis wrote: [snip] /me just jumping in, so might probably completely clueless > If you open the table, the postgresql-client will allocate some memory > to store the data. That'll be 10+8=18 bytes plus something dependent on > it's ow

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-04 Thread Marc Weustink
Joost van der Sluis wrote: [snip] /me just jumping in, so might probably completely clueless If you open the table, the postgresql-client will allocate some memory to store the data. That'll be 10+8=18 bytes plus something dependent on it's own string-data-format. At the same time TBufDataset

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-04 Thread Joost van der Sluis
On Mon, 2006-07-03 at 12:16 -0400, Alexandre Leclerc wrote: > 2006/7/3, Zlatko Matić <[EMAIL PROTECTED]>: > > Hi! > > I downloaded the most recent snapshot (Lazarus-0.9.17-20060703-win32.exe) > > this morning and now it finally works! I'm so excited about it, it's great! > > Finally I can experimen

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-03 Thread Alexandre Leclerc
2006/7/3, Zlatko Matić <[EMAIL PROTECTED]>: Hi! I downloaded the most recent snapshot (Lazarus-0.9.17-20060703-win32.exe) this morning and now it finally works! I'm so excited about it, it's great! Finally I can experiment with Lazarus as front-end for my PostgreSQL databases. I'm so happy about

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-03 Thread Zlatko Matić
y much. Zlatko - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Monday, July 03, 2006 10:23 AM Subject: Re: [lazarus] problems with SQLdb components and Postgres Hi Zlatko, it has nothing to do with the amount of records, but with the amount of fields. The size for one record.

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-03 Thread joost
lem remains! How do you explain that? > > Regards, > > Zlatko > > - Original Message - > From: "Joost van der Sluis" <[EMAIL PROTECTED]> > To: > Sent: Monday, July 03, 2006 1:10 AM > Subject: Re: [lazarus] problems with SQLdb component

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-02 Thread Vincent Snijders
ng_type='OTISCI POVRŠINA';" and now it has only 9 rows. But, the problem remains! How do you explain that? Regards, Zlatko - Original Message - From: "Joost van der Sluis" <[EMAIL PROTECTED]> To: Sent: Monday, July 03, 2006 1:10 AM Subject: Re: [lazaru

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-02 Thread Zlatko Matić
VRŠINA';" and now it has only 9 rows. But, the problem remains! How do you explain that? Regards, Zlatko - Original Message - From: "Joost van der Sluis" <[EMAIL PROTECTED]> To: Sent: Monday, July 03, 2006 1:10 AM Subject: Re: [lazarus] problems with SQLdb c

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-02 Thread Joost van der Sluis
; To: > Sent: Sunday, July 02, 2006 3:16 PM > Subject: Re: [lazarus] problems with SQLdb components and Postgres > > > On Saturday 01 July 2006 23:32, Zlatko Matić wrote: > > Hi! > > > > Well, I agree it is a complex query:) But the same happens with very > > s

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-02 Thread Zlatko Matić
Yes, the same happens when using simple sql query such as "select * from sometable;". - Original Message - From: "johnf" <[EMAIL PROTECTED]> To: Sent: Sunday, July 02, 2006 3:16 PM Subject: Re: [lazarus] problems with SQLdb components and Postgres On S

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-02 Thread johnf
t; > To: > Sent: Saturday, July 01, 2006 11:59 PM > Subject: Re: [lazarus] problems with SQLdb components and Postgres > > On Saturday 01 July 2006 11:05, Zlatko Matić wrote: > > ((results_microbs join batches_microbs on' > > ' (((results_microbs.bat

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-01 Thread Zlatko Matić
n. Thanks, Zlatko P.S. Have you seen screenshots that I sent you directly on your e-mail? - Original Message - From: "johnf" <[EMAIL PROTECTED]> To: Sent: Saturday, July 01, 2006 11:59 PM Subject: Re: [lazarus] problems with SQLdb components and Postgres On S

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-01 Thread johnf
On Saturday 01 July 2006 11:05, Zlatko Matić wrote: > ((results_microbs join batches_microbs on' >       '    (((results_microbs.batch) =' >       '    (batches_microbs.batch join' >       '    (departments join plants on' >       '    ((departments.department =' >       '    plants.department)

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-01 Thread Zlatko Matić
OP TRIGGER audit_public_plants_delete_trigger ON plants; CREATE TRIGGER audit_public_plants_delete_trigger AFTER DELETE ON plants FOR EACH ROW EXECUTE PROCEDURE auditor.audit_public_plants_func_delete(); -- Trigger: audit_public_plants_insert_trigger on plants -- DROP TRIGGER audit_public_pla

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-01 Thread Vincent Snijders
Joost van der Sluis wrote: On Sat, 2006-07-01 at 08:41 +0200, Zlatko Matić wrote: I downloaded binaries Lazarus-0.9.16-20060528-win32.exe, Lazarus-0.9.17-20060628-win32.exe, Lazarus-0.9.17-20060630-win32.exe. I don't know which version of the compiler is included. How can I check it? All t

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-01 Thread Joost van der Sluis
t, some test-data and code to show the problem? Joost > - Original Message - > From: "Joost van der Sluis" <[EMAIL PROTECTED]> > To: > Sent: Friday, June 30, 2006 11:20 PM > Subject: Re: [lazarus] problems with SQLdb components and Postgres > > &

Re: [lazarus] problems with SQLdb components and Postgres

2006-07-01 Thread Zlatko Matić
Why? There were some known bugs in FPC 2.0.2 affecting SqlDb? Regards, Zlatko - Original Message - From: "Joost van der Sluis" <[EMAIL PROTECTED]> To: Sent: Friday, June 30, 2006 11:20 PM Subject: Re: [lazarus] problems with SQLdb components and Postgres On Fri,

Re: [lazarus] problems with SQLdb components and Postgres

2006-06-30 Thread Zlatko Matić
t;[EMAIL PROTECTED]> To: Sent: Friday, June 30, 2006 11:20 PM Subject: Re: [lazarus] problems with SQLdb components and Postgres On Fri, 2006-06-30 at 18:25 +0200, Zlatko Matić wrote: I have big problem with displaying results from a query, by using Postgres 8.1.X, TPQConnection, TSQLQuery a

Re: [lazarus] problems with SQLdb components and Postgres

2006-06-30 Thread Joost van der Sluis
On Fri, 2006-06-30 at 18:25 +0200, Zlatko Matić wrote: > I have big problem with displaying results from a query, by using > Postgres 8.1.X, TPQConnection, TSQLQuery and TSQLTransaction. I think > that something is very wrong with SqlDB components...Values in some > columns are not displayed at all

Re: [lazarus] problems with SQLdb components and Postgres

2006-06-30 Thread johnf
On Friday 30 June 2006 09:25, Zlatko Matić wrote: > I have big problem with displaying results from a query, by using Postgres > 8.1.X, TPQConnection, TSQLQuery and TSQLTransaction. I think that something > is very wrong with SqlDB components...Values in some columns are not > displayed at all, or

[lazarus] problems with SQLdb components and Postgres

2006-06-30 Thread Zlatko Matić
I have big problem with displaying results from a query, by using Postgres 8.1.X, TPQConnection, TSQLQuery and TSQLTransaction. I think that something is very wrong with SqlDB components...Values in some columns are not displayed at all, or are displayed incorrectly (zero insted of actual nu