OraFAQ Forum: Forms » how to query records through forms6i

Home » Developer & Programmer » Forms » how to query records through forms6i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to query records through forms6i [message #159480]

Mon, 20 February 2006 00:29

rnemkul
Messages: 35
Registered: February 2006

Member

Dear all
Do you have any idea about query through Forms .
I saw on Demo of Forms6 But I loss that file so If you have that file ,Please attach that file on reply
Thanks
Rajendra

Report message to a moderator

Re: how to query records through forms6i [message #159484 is a reply to message #159480]

Mon, 20 February 2006 00:37

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Open form builder, connect to your database, go to the empty form, create a new block, use the wizard to point to your table. Accept the defaults, press 'ok' until there aren't any more, run the form (it should compile automatically). Use the menu bar at the top of the screen to execute a query.

Read the help facility and the documentation (see sticky at the top of the forum).

David

Report message to a moderator

Re: how to query records through forms6i [message #159490 is a reply to message #159484]

Mon, 20 February 2006 00:54

rnemkul
Messages: 35
Registered: February 2006

Member

Dear david
I need to query through any table of database
So I need help.

Rajendra

Report message to a moderator

Re: how to query records through forms6i [message #159493 is a reply to message #159490]

Mon, 20 February 2006 00:58

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please post your assignment so we have better idea of what you want to do.

David

Report message to a moderator

Re: how to query records through forms6i [message #159498 is a reply to message #159493]

Mon, 20 February 2006 01:05

rnemkul
Messages: 35
Registered: February 2006

Member

I got a assignment for Any kind of query through forms6i using grid. the query retrive on grid which can be transfer to Excel.

Thanks
Rajendra

Report message to a moderator

Re: how to query records through forms6i [message #159655 is a reply to message #159498]

Mon, 20 February 2006 17:01

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Then you need to be able to show a list of tables in the database. Search this forum for 'list tables' for other assistance. You can use 'user_tables' to get the list of tables. Then with the block's 'Query Data Source Type' set to 'FROM clause query', set the 'Query Data Source Name' to the cloumns from the table that has been selected. You will either have to convert the fields to character fields (if you only have character fields defined in your block) or selectively display various character, number, and date fields which you have populated from the 'Query Data Source Name'.

David

Report message to a moderator

Previous Topic:	Pre-delete trigger
Next Topic:	Returning Lov value to More than 1 field.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:19:58 CDT 2024