[sqr-users] Re: Temp Table Error

[David Donnelly <Dave@isisbio.com>]

Sam,

If you are creating the temp table during the run of the SQR program, and 
it does not exist at compile time, then the SQR compiler has no idea what 
it looks like when it generates code.

If the temp table is always the same, you could just leave it around 
between runs and empty it each time.

Otherwise you'll have to use dynamic SQR one way or another.  One way is to 
have a "model" table, if you can construct one that looks similar enough, 
and use

         from [model:$realtablename]

and the other is to use dynamic columns, as has been suggested by others, 
and tell SQR the type.

Regards,
Dave


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users