Hi
I am using character based progress at my company.
ok i have a table for stock where the location is set to e.g c20, c110 etc
but when i run a query on the table if i check location >= "c30" and <= "c40"
it shows the records but it also includes "c4" which i dont want
any ideas? it just finds all number patterns such as c3 and c30 etc....
for each stock where klocsn >= "c30" and
klocsn <= "c40" and
kco = 1 and
stock.act-qty[1] > 0 no-lock:
display stock.klocsn.
end.
I am using character based progress at my company.
ok i have a table for stock where the location is set to e.g c20, c110 etc
but when i run a query on the table if i check location >= "c30" and <= "c40"
it shows the records but it also includes "c4" which i dont want
any ideas? it just finds all number patterns such as c3 and c30 etc....
for each stock where klocsn >= "c30" and
klocsn <= "c40" and
kco = 1 and
stock.act-qty[1] > 0 no-lock:
display stock.klocsn.
end.