How to use prepared property？

[zhuyl]

hello,How to use prepared property？ My test cannot execute the prepared SQL statement 。

[marsupilami]

Prepared usually only prepares internal structures. It should not be necesary to set ist. If it doesn't work for you, please don't use it.

[zhuyl]

How to prepare SQL statements to improve execution speed？

[marsupilami]

With FreeTDS there is no possibility to prepare statements. The dblib api that gets used by FreeTDS doesn't allow to use parameters and prepare statements. This is better done using ODBC and Zeos 8.