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

[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