Zeoslib Portal

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,

yes - that might happen. I seem to rememeber something like this. The problem seems to be that we cannot get metadata for temporary tables - or at least we don't know how to get metadata for temporary tables.

Best regards,

Jan

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.

[Redacted thing I posted when I thought this was for MySQL and not SQLServer! Apologies!]

-Mark

The database I use is MS SQL Server, and the temporary table created is in the database tempdb, from which the metadata of the table can be obtained.

I have zero experience with temporary tables but I have a MSSQL server at home to test on.
If you can provide the queries to execute I can try to take a look at the issue.

P.s.: I'm using DBLib to connect, not ODBC or ADO.

hello
I made a test example, you can test it, the database is ms sql server.

...and where can I find it, exactly? :)

hello
I forgot to upload, I am uploading now.

Hello
Can the problem be solved?

Hello zhuyl,

I introduced some changes in Zeos 8.0 to allow writing top temporary tables. Please note that currently autoinc fields are not supported by the code. I don't plan to backport these changes to Zeos 7.2. So please upgrade to Zoes 8.0.

Best regards,

Jan

Thanks

Merry Christmas to everyone!

@ zhuyl,
I'm sorry; I promised myself that I'll spend every free minute of my vacation time with my daughter, therefore I had zero time to look into the issue deeply enough. I see Jan jumped on the topic too, so no worries.

@ Jan,
Taking the example from here, with your modifications included the fields are still read only.

Hi aehimself, All,

Merry Christmas to everyone!

1. It works for me (in conjunction with TZUpdateSQL).
I am enclosing an example: 2. What do you think about:
viewtopic.php?f=50&p=185826#p185826

Michał

Merry Christmas to everyone!

test has the following problems:
1. There is a problem with the SQL statement without a table, such as ‘select getdate()’. Debugging to unit ZSybaseAnalyser.pas: TZSybaseStatementAnalyser.DefineSelectSchemaFromQuery error.
2. Using temporary tables under SQL 2000 will cause errors. Debugging to the unit ZDbcDbLibMetadata.pas: exec tempdb.sys.sp_columns has an error, can you change it to exec tempdb.dbo.sp_columns to be compatible with SQL2000?
3. When the data has non-English characters (such as Chinese), it will be wrong to save to the temporary table.

In addition, I found a problem that caused garbled characters, ZQuery1.FieldByName('CName').AsString:='程序abcd员', when garbled characters appeared when posting, debug to unit ZEncoding.pas: ZDetectUTF8Encoding function: if (EndPtr-Source > SizeOf(PCardinal)) and (PCardinal(Source)^ and $80808080 = 0) //Check quad block ASCII again
then inc(Source, SizeOf(PCardinal)) //SizeOf(PCardinal) here should be changed to: SizeOf(Cardinal)
else Inc(Source);