select * from stock_file where cstockid == padr(stock_id,len(cstockid)) into cursor cstock>Just a side note. Why do you use alltrim? It gives zero benefit, and your query won't be optimized. Instead use
>select * from stock_file where cstockid == stock_id into cursor cstock>>I want the user to pick the stock id:
>>stock_id = inputbox('Stock ID','Input Stock ID', space(20)) >>select * from stock_file where alltrim(cstockid)=alltrim(stock_id) into cursor cstock >> >>select cstock >>browse normal >> >>?cstock.cstockid >>>>