Re: Forms4.5:Problem in Querying,please help

You can't do this.

the best way to do somthing like this is.

you can create both blocks based in the same table.

after

the first block don't attach to any table.

   the property table base = null on all fields and in the propretey of first block.

the user must to insert the query in the first block.

before you execute the query you read all fields of the first block and concat on a string call for example my_query.

with the built-in function 'set_block_property' you change the property 'default where' with the query my_query.

    set_block_property('block_2',default_where,my_query);

to finish, go to the second block and execute the query.

i hope to help you, sorry for my english, i speak better the spanish

[Quoted] fatima_haider_at_hotmail.com escribió en mensaje <6r4om9$t69$1_at_nnrp1.dejanews.com>...
>I'm creating an application in Forms4.5 in which i've created two blocks on
>the same canvas and both the blocks are from the same base table.In the
first
>block, the user can enter query and in the second block i want to execute
the
>query or i want to show the results of the query in the second block. The
>layout of the first block is form and the layout of the second block is
>tabular so that i can show more than one record. In the first block it's
>like, Search on City ----- and in the next block i want to display the
result
>of this query. Can anyone tell me how to do this? Thanks.
>
>Sonia
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Aug 17 1998 - 16:18:25 CEST