Help with design [message #20239] |
Wed, 08 May 2002 09:35 |
Brad
Messages: 12 Registered: April 1999
|
Junior Member |
|
|
If I have a form where a user can enter info about 10 contacts, how can I code the receiving form to accept those inputs without having to declare all the variables? Is there a way to pass a count variable then call another procedure that will handle the contacts or something like that? Sample code is appreciated.
Thanks,
Brad
|
|
|
Re: Help with design [message #20263 is a reply to message #20239] |
Thu, 09 May 2002 10:41 |
Su
Messages: 154 Registered: April 2002
|
Senior Member |
|
|
Not exactly sure how it needs to be done, something strikes in my mind that you can use varray to store 10 or so contacts and use it in your SQL statement. For example, create a data type (as object) to store an individual contact info and repeat the info entree in an array by creating
CREATE ... VARRAY(n) OF your_contact_type.
As it will be created as a nested table, you can also use the array just like another table and use it in your SQL query, just like TABLE(your_varray_alias). Try it out and let me know if you still need any help. I will try if I could be of any help.
Good luck :)
|
|
|