Zeoslib Portal

In which File? There is no Function named "SQLStrToFloatDef"

Please, look in Zeos\src\core\ZSysUtils.pas

Your test program works ok on my computer: StrToFloatDef('12.5')= Using locale (thousands=. decimals=,): 125,00 Using thousands=, decimals=.: 12.50 Using thousands=. decimals=.: 125.00 Using thousands=. decimals=,: 125,00 OldSQLStrToFloatDef('12.5')= Using locale (thousands=. decimals=,): 125,00 Usi...

Hello, mdaems.

having decimal separator = thousand separator is not too good, so I vote for *not* using ifdef. Let's make things simple and clear.

mdaems wrote:Anyhow... I'd like to be sure to know what postgres returns in your cases. Is it effectively a ',' instead of '.'?

No. Postgresql returns 12345.67 (no thousand separator, "." as decimal separator) to me.

I guess I've found the problem - its thousand separator. On locale settings I have it set to ".". FPC eliminates all thousand separator characters before trying to get float from string. As my thousand is set to "." FPC eliminates all "." characters in Str and so Decima...

It seems to be FPC bug. http://forum.lazarus.freepascal.org/index.php?topic=8150.0 I've wrote a test procedure: procedure TForm1.Button2Click(Sender: TObject); var _real: Double; _dc: char; begin _dc := DecimalSeparator; DecimalSeparator:='.'; _real := StrToFloatDef('1.2', 0); DecimalSeparator:= _dc...

I've tested on postgresql 8.3.4 so I guess the problem is not related to server version (not 8.4 at least).

I can confirm this behavior is also observed using Zeos 7 and Lazarus 0.9.28 beta, fpc 2.2.4 rev 21921 win32/win64.

Hello, martinrame. I guess you are mixing SQL and delphi code into one :). What I wanted to say is you should set AutoCommit to false and TransactIsolationLevel to tiNone on your TZConnection component. That way Zeos doesn't manage transactions. You should execute 'START TRANSACTION ISOLATION LEVEL ...

Hello, matinrame If you want all DDL commands in single transaction, then you should use them. I would suggest using tiNode and calling BEGIN, SET TRANSACTION ISOLATION LEVEL and COMMIT manualy. This way you'll be able to handle your transactions as you want. The other thing is the lock issue. I thi...

Hello, baba

What version of zeos lib are you using? What is your Operating system. Do you use zeos with lazarus?

please provide the create script of your test.preise table (you can copy it from pgAdmin).

Hello, danielf. As you describe it, the thing you should double check is TransactIsolationLevel. Maybe your program changes it dynamically?.. If TransactIsolationLevel = tiNone the Begin and Commit commands are not used. If thats not the case - than this may be connected to CBuilder. I have almost n...

Hello, To test I used simple code: ZConnection1.Database := 'sport3_test'; ZConnection1.Connect; ZConnection1.StartTransaction; qZ.Open; ZConnection1.Commit; In Monitor file I got: 2009-12-18 15:21:15 cat: Connect, proto: postgresql-8, msg: CONNECT TO "sport3_test" AS USER "postgres&q...

The formation of postgresql connection string is not as good as it could be. For example if you leave the database name field empty in TZConnection component on connect you'll get error saying dbname is "user=". While this is not a big problem as connection usually has database, user and p...

Hello, danielf

would you provide more information on TZConnection component you are using:
- what is the value for AutoCommit
- what is TransactIsolationLevel
- what DB system are you connected to?