Zeoslib Portal

hello
Is there a way to solve this problem? Temporary tables are often used to read and write data.
Metadata can be obtained from tempdb. Before exec sp_columns, use tempdb to get no metadata.

hello.
I use ZQuery to create a temporary table, and then open it, the fields are all read-only.
The database is mssql, zeos is 8.0

hello
Failed to save a file in the image field of MS SQLerver.
zeoslib version:7.2.14, MS SQLerver 2000, Protocol: ado
The test file is attached, please unzip the file and test it .

How to prepare SQL statements to improve execution speed？

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

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

Hello, thank you for your patient answers. The problem has been solved, which is the reason why the FreeTDS version you mentioned is too old. The new version is ok.

I create a test project

Zeos version 7.2.14, FPC version 3.2.0, on windows, use FreeTDS, set ClientCodepage to UTF-8

Connecting to the SQL server in lazarus, when the field is of type varchar and the value is Chinese, garbled characters appear in the query.

When the field is of varchar type and the value is Chinese, the query is garbled.