Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread dynamic parameter references
Wed, May 29 2013 1:33 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

I have a workround for

'ElevateDB Error #700 An error was found in the statement at line 1 and column 8 (Invalid expression ? found, dynamic parameter references not allowed)'.

but I'd really like to be able to do this

SELECT :Prefix + Name + :Suffix + '6' AS Item
FROM Information.TableColumns
WHERE
TableName = :tbl
AND
Type <> 'BLOB'
AND
Type <> 'Byte'
AND
Type <> 'VarByte'
ORDER BY Name

Roy Lambert
Thu, May 30 2013 12:19 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< I have a workround for

'ElevateDB Error #700 An error was found in the statement at line 1 and
column 8 (Invalid expression ? found, dynamic parameter references not
allowed)'.

but I'd really like to be able to do this >>

Noted.

Tim Young
Elevate Software
www.elevatesoft.com
Image