??Glob.Variable used in query for datablock??

Help. We are developing a form using Developer V2 (forms V5) and are trying to use a global variable as part of the default where clause. Our form is going to ask the users to select different collumn names, operator and value. We then want to combine these selections to form a string to place in a global variable to use in the default where clause.

[Quoted] [Quoted] When referencing the global variable in the default where clause the actual [Quoted] [Quoted] value of the global variable appears, but it is enclosed with 'single-quotes'. [Quoted] Under GLOBAL Variables in the debugger, the values were correct (ex. NumPieces [Quoted]  was correct as was < and 500) Upon going into Debugger/SYSTEM Variables/LAST [Quoted] Query...the concatenation was as follows:

[Quoted]       'NumPieces < 500' (we want ... NumPieces < 500 without the quotes!)

[Quoted] [Quoted] This is what we want for the global variable to use in the default where [Quoted] clause. However, it would not work because of the single quotes.

Thank you very much in advance.

Dorine

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 10 1998 - 00:00:00 CET