Subject | Ramil: TXLSQL and parametres in the TIB_Query |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2007-02-01T12:58:44Z |
When I have a TIB_Query like
SELECT FieldA
FROM TableA
WHERE FieldB = :MyParam
and try to use Ramils new TXLSQLScript component with the following RSQL:
SELECT FieldA
FROM TXLSQLRepAlias
INTO :ExcelFieldName
I get "Unknown variable MyParam in the INTO section".
If I don't use parametres in the TIB_Query, the same thing works
brilliantly.
Set
SELECT FieldA
FROM TableA
WHERE FieldB = :MyParam
and try to use Ramils new TXLSQLScript component with the following RSQL:
SELECT FieldA
FROM TXLSQLRepAlias
INTO :ExcelFieldName
I get "Unknown variable MyParam in the INTO section".
If I don't use parametres in the TIB_Query, the same thing works
brilliantly.
Set