TZTable and temporary tables

[aleroot]

I'm trying to use a TZTAble component to link a Temporary table on mssql(e.g. #tablename ), but I get an error each time I try to open the TZTable component ...

The error message say table #tablename not found even if the table is present because I have previously created it with a TZQuery ...


Is there a way to link a TZTable object with a temporary table ?

Is there a TZTempTable component ?


Thanks.

[marsupilami]

Hello aleroot,

what happens if you use a query and do something like
select * from #tablename
or like
select * from [#tablename]
? And do you use Zeos 6.6 or 7.0? If you use 6.6, did you try 7.0?
Best regards,

Jan

[reiquarge]

A TEMPORARY table is visible only to the current connection, and is dropped automatically when the connection is closed.

[marsupilami]

Hello mysterious new user. Welcome to the Zeos forums. Does it really make sense to pst to a thread that has seen no activity for three years now? Even then I think your post doesn't help. Or are you sure, that the original poster didn't make sure that the table exists for his connection when he does what he tries to do?

Best regards,

Jan