June 19, 2008 at 1:49 pm
I have this code:
:IF UserInput(100,100,450,350,"Gimme your information!",{"nCLIENTPO,50,200,150,50,SE,Client PO # (needs to be exact)"});
aORDNO:=SQLExecute("Select distinct folderno from FOLDERS where CLIENTPONO=?nCLIENTPO?");
cORG:=BuildString(ExtractCol(aORDNO,1));
I would like to pull up a list by inputting only part of the PO number versus the exact PO number. Anybody know of some suggestions. I understand that the code may be a little different than normal T-SQL but rules run the same just different words in our SQL.
I have tried using % with '' or " but just don't seem to be getting it correctly! Thanks to anybody than can assist me.
June 19, 2008 at 1:54 pm
If it were T-SQL, this part:
Select distinct folderno from FOLDERS where CLIENTPONO=?nCLIENTPO?
Would be more like:
Select distinct folderno from FOLDERS where CLIENTPONO like '%' + nCLIENTPO + '%'
No clue if that will work for you, but it might be worth a shot.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 19, 2008 at 2:16 pm
Thanks so much you got me on the correct path, what I needed to have was this:
"Select distinct folderno from FOLDERS where CLIENTPONO like '%"+nCLIENTPO+"%'"
June 19, 2008 at 2:51 pm
Glad I could help.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply