How to disable statements preparing?

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
Post Reply
stoffman
Senior Boarder
Senior Boarder
Posts: 50
Joined: 03.12.2020, 06:55

How to disable statements preparing?

Post by stoffman »

Hi,

How do I disable the preparing of statements? I tried to remove [doPreferPrepared] from the dataset options but it doesn't help

For quickly reproducer example, if I set the SQL to be:
select * from files limit 20; select * from files limit 10

I get the error:
"SQL Error: ERROR: cannot insert multiple commands into a prepared statement
ERROR 42601"

Thanks,
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: How to disable statements preparing?

Post by marsupilami »

Hello Stoffman,

which database driver do you use? Some drivers support multiple statements and some don't.

With best regards,

Jan
Post Reply