Subject Re: [firebird-support] field name as parameter in stored procedure
Author Martijn Tonies
Hello Maurizio,

>i tried something like
>Update myTable set :myfield = .......
>... where myfield is a parameter of the procedure ,
>but it doesn't work ,
>is it possible to use a parameter as a a field name ?

Parameters only work for -values- not for anything else.

If you want to make a dynamic SQL statement, take a look
at the EXECUTE STATEMENT statement in the Docs

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum: