Hi,
I'm working a lot with tempory tables.
I'm a little bit borred for retreiving Fields (right click / Fields editor / Select All fields) since it doesn't really works.
But I found a workarround for this :
First Step
in the SQL property I first put my create temporary table statement and then set the TMyQuery Active property to True. I'll get an error as I didn't write a SELECT statement, nevertheless, the query was executed and the temporary table created.
Second Step
in the SQL property I replace the create temp table statement with a Select statement (select * from temptable). I'm now able to retreive fields from the temporary table.
This is a little bit annoying. Is it possible to add an "Execute Script" to the TmyQuery ? , so that I will be able to handle the temporary tables with more ease ?
Feature Request : Add an "Execute Script" entry when right clicking on a TMyQuery
-
- Posts: 451
- Joined: Wed 19 Jan 2005 09:59
-
- Posts: 451
- Joined: Wed 19 Jan 2005 09:59