Page 1 of 1

How to disable statements preparing?

Posted: 27.01.2024, 07:42
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,

Re: How to disable statements preparing?

Posted: 31.01.2024, 12:38
by marsupilami
Hello Stoffman,

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

With best regards,

Jan