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..