| calling parameters in another form [message #197263] |
Tue, 10 October 2006 15:51  |
nagsindhu
Messages: 14
Registered: August 2006
Location: Newjersey
|
Junior Member |
|
|
Hey,
could you give me notes to following Q's?
1)How do u check the data in text item?
2)how do u pass values from one form to another?
3)If parameter is passed from one form to another how do u set the called form to perform a query using the parameter?
Thanx in Advance
Sindhu Reddy
|
|
|
|
| Re: calling parameters in another form [message #197330 is a reply to message #197263] |
Wed, 11 October 2006 00:11  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
This are very basic questions but the first one hasn't been asked for a long, long time.
1) Multiple options depending on what characteristic you wish to check. You can define the item as being numeric (if you only want numbers), you can define a length (if you only want so many characters), you can define a mask, you can write code in a When-Validate-Item trigger and use PL/SQL to interigate the data.
2) Parameters, global values, database objects - package variables, table items.
3) You can use either the 'default_where' facility (search this forum or read the documentation) or use the 'Query Data Source Type' of 'FROM clause query' (search this forum, read the documentation, or google them).
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
