The problem with this method is say a values are 1500,200,16 in table and user has entered 1, then list should show only 1500, 16
Whereas when my sql statement is executed, no recs are returned..
Pls advs...
>I think your problem is that lcMatch_with is character data in all cases. To make this work try using val(lcMatch_with) for numeric data and similar adaptations for other data types.
>
>>I'm trying to create a find screen, which is having field names in a combo box, a textbox for the user to type value and a list box which gets updated on each pressed key..
>>
>>For character fields, there is no problem in getting the desired results, but problem comes when user chooses numeric, date, logical or any other data type/field apart from char..
>>
>>Currently I'm using following sql to get the array for the list box..
>>
>>Sele distinct &lcFldname from (lcAlias) into array laTmpval ;
>>where &lcFldname=lcMatch_with
>>
>>Pls note that lcmatch_with gets updated on each keystroke and abv sql is called, which gives me a proper result.
>>
>>can anybody advs. me how to make it generic so that it can support all data types..
>>
>>Thanks in advance..
>>
>>p.s. if I use str function to convert numerics in char.. I've to get the correct length and decimal points for each fields..
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only