[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Dynamic SQL problem

What's the layout of the work table?

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org]On Behalf Of
Deva Anbu Daniel
Sent: Friday, April 02, 2004 2:17 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Dynamic SQL problem 


Begin-SQL
INSERT INTO PS_WORK_TABLE
SELECT NAME,SEX,BIRTHDATE,[$Cur_Date]
FROM PS_PERSONAL_DATE
WHERE ........
 
End-SQL
 
instead of [$Cur_Date] I tried 
 
$temp = ''''||$Cur_Date||'''' and used $temp instead of $Cur_Date.
 
It always give me Invalid Column error.
 
Is this possible in SQR?
 
thanks,
daniel
 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users