Re: refering to a column by a variable
From: Gary Myers <101355.3556_at_CompuServe.COM>
Date: 1995/12/19
Message-ID: <4b70sv$jp4$1_at_mhafn.production.compuserve.com>#1/1
Date: 1995/12/19
Message-ID: <4b70sv$jp4$1_at_mhafn.production.compuserve.com>#1/1
You need to use Dynamic SQL for this. The Precompiler manuals and Pro*C etc
supplements cover it quite well, and there should have been some DEMO programs
installed that you can use a basis. If you need further details I may be able to
help out.
Needless to say, all this will make the program much more complicated and
a real *%$!* to maintain. Have you considered having the Pro*C program work
on a view, and then you can recreate the view definition at runtime ?
Gary
-- Gary Myers, Analyst/Programmer, Kaisha Technology, West of EnglandReceived on Tue Dec 19 1995 - 00:00:00 CET