Re: Invalid Column Name
From: Reid Lai <reidlai_at_hk.super.net>
Date: 1997/02/26
Message-ID: <01bc23ef$425d54e0$281740ca_at_hk.super.net.hk.super.net>#1/1
Date: 1997/02/26
Message-ID: <01bc23ef$425d54e0$281740ca_at_hk.super.net.hk.super.net>#1/1
Hi Anup,
I guess that you are trying to issue dynamic SQL statement in PowerScript. A point you should pay more attention on joining string. If your string need special character, such as ", please add ~ before the one. For example,
ls_sql = "SELECT ~"ACMAST~".~"ACNAME~""
EXECUTE IMMEDIATE :ls_sql ;
-- Best Regards, Reid Lai mailto://reidlai_at_hk.super.net http://www.hk.super.net/~reidlaiReceived on Wed Feb 26 1997 - 00:00:00 CET