on 12-05-2007 8:49 AM
Hi experts
I am trying to select specifed column in smartform statement but geeting error
"Comma without preceding colon (after SELECT ?)." but same statent is working in report . please let me know what is the reasion of the same .
SELECT SINGLE persnumber
addrnumber
FROM usr21
into ( g_persnumber,g_addrnumber )
where bname eq 'DDIC' .
DDIC is a value of usr21 table .
Thanks for your Quick reply
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ajay,
The problem is with ur sapcing of fields within brackets.
write ur query like
SELECT SINGLE persnumber addrnumber
FROM usr21
into (g_persnumber, g_addrnumber)
where bname eq 'DDIC' .
Notice thr is no space just after and before the braces.After comma give one space.
It will work for u.
Regards
Rudra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you have problem write it like this...
SELECT SINGLE *
FROM usr21
where bname eq 'DDIC' .
g_persnumber = persnumber
g_addrnumber = addrnumber
Regards,
SaiRam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.