Zeoslib Portal

@ Wild_Pointer

thanks a million - it works!!!!!!!!!!!!!!!

Also I changed the function SQLStrToFloatDef to the one you provided and it works OK

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

Hello,

for the first time, i have switched to the LazComp. There works and i needed a Solution for Tuesday. (Tomorrow)

The SQLStrToFloatDef Funktion i will test later, with my Testprogramm.

Thx, and a Happy new Year to all.

Wild_Pointer wrote:It seems to be FPC bug.

but the Lazarus-SQL-Comp works fine.

Hello,

sure, but i find its a good idea, an i can use Skype all the Time and my iPhone ist 24/7 on my Side.

Hello,

at this Moment, i install skype on my iPhone

Hello

this is my Code:

procedure TForm1.Button2Click(Sender: TObject);
begin
ZConnection1.Connect;

DataSource1.DataSet := ZQuery1;
ZQuery1.SQL.Clear;
ZQuery1.SQL.Add('SELECT fr_prs FROM test.preise');
ZQuery1.Open;

//OK, RESULT: 950

ShowMessage(DecimalSeparator); // IS .
end;

Hello,

i need a litle help.

There is no "TZPostgreSQLResultSet."


??? TZPostgreSQLResultSet.GetString.

Hello,

pgAdmin shows 9.50.

I will check it with TZPostgreSQLResultSet.GetString.

Hello,

now i have tested with 8.3 and 8.4 it´s the same. 9.5 -> 950

Hello, this is the full create. It´s the same for all Numeric Fields. ----------------------------------------------------------------------- EXAMPLE: preis_01_t character varying(40), // Tip/Hint preis_01_1 numeric(7,2), // Price 1 - 9.50 - in the Grid: 950 preis_01_2 numeric(7,2), // Price 2 preis...

Hello,

I read in a DBGrid:
ZEOS: ZQuery1.SQL.Add('SELECT * FROM test.preise');
Decimal(9.50) comes 950 with Format('0,00') comes 950,00

when i use
LAZARUS OWN: SQLQuery1.SQL.Add('SELECT * FROM test.preise');
Decimal(9.50) comes 9,5 Thats OK!

PGAdmin shows 9.5 Thats OK!

What is wrong with ZEOS?

Hello, i have a postgres database with field size VARCHAR(32768) in it... if i read from this field with zeosdbo my progy crash... if i change size of this field to size VARCHAR(2048), it's all ok... i'm compiling with Lazarus 0.9.28.2 r22279 FPC 2.2.4 i386-win32-win32/win64 zeosdbo is 6.6.5-stable ...