Search found 6 matches

by marko
25.05.2024, 03:57
Forum: ZeosLib 7.3/8.0 Forum
Topic: problem with postgresql inserts
Replies: 8
Views: 207

Re: problem with postgresql inserts

Hi Jan, phpbb gives me an 'http error' when attaching files. here is the code: CREATE TABLE public."BCOrderTest" ( "OrderID" integer NOT NULL, "CustomerID" integer, "OrderDate" date, "Subtotal" money, "TaxTotal" money, "OrderStatus&quo...
by marko
24.05.2024, 11:03
Forum: ZeosLib 7.3/8.0 Forum
Topic: problem with postgresql inserts
Replies: 8
Views: 207

Re: problem with postgresql inserts

Here is a test lazarus 3.2 project with a similar structure to my main app

The inserts fail for me on line 3. Sql is provided for a database called bcsq

cheers
marko
by marko
24.05.2024, 10:21
Forum: ZeosLib 7.3/8.0 Forum
Topic: problem with postgresql inserts
Replies: 8
Views: 207

Re: problem with postgresql inserts

'BinaryWireResultMode=false'

does not solve the problem, same error on the same field
by marko
24.05.2024, 09:47
Forum: ZeosLib 7.3/8.0 Forum
Topic: problem with postgresql inserts
Replies: 8
Views: 207

Re: problem with postgresql inserts

thanks,

Query.Properties.Add('emulate_prepares=true');

solves the problem
by marko
22.05.2024, 00:18
Forum: ZeosLib 7.3/8.0 Forum
Topic: problem with postgresql inserts
Replies: 8
Views: 207

Re: problem with postgresql inserts

Thanks, I will try the suggestions and also try to get some confirmed failing test data in a usable form.

with kind regards
marko
by marko
21.05.2024, 12:09
Forum: ZeosLib 7.3/8.0 Forum
Topic: problem with postgresql inserts
Replies: 8
Views: 207

problem with postgresql inserts

Hi, I've just upgraded to zeos 8 on lazarus. I'm using postgresql on kubuntu 23.10. My application does multiple paramatised inserts as it parses a csv file. Everything works ok on 7.2.14, inserts repeatably fail at random using 8.0.0. The error message is: zeosdbo error incorrect binary data format...