Re: Invalid Column Name

From: Reid Lai <reidlai_at_hk.super.net>
Date: 1997/02/26
Message-ID: <01bc23ef$425d54e0$281740ca@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@hk.super.net
http://www.hk.super.net/~reidlai

Received on Wed Feb 26 1997 - 00:00:00 CST

This message: [ Message body ]
Next message: Nick Li: "RPC calls from ORACLE server"
Previous message: anupcomp_at_giasbm01.vsnl.net.in: "Invalid Column Name"
In reply to: anupcomp_at_giasbm01.vsnl.net.in: "Invalid Column Name"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US