Marcello Capelati
|
| Posted: 05/10/2002, 8:19 AM |
|
Is there any complete manual witch explain in details variables and parameters ?
I'm going crazy to understand what happens inside the codecharge...!
This is my problem:
a) I have a search form. It has a textbox field ("txt_locale"), witch could be filled with some value (or don't...).
b) This value, if present (if filled), has to be searched in a table, and if it is found, the correspondend ID (number) has to be returned
c) This ID must be passed to the next called form (a grid form), in order to use in their search criteria (SQL statement).
What I've done:
-Item a: are done and ok. I could pass the value of variable "tx_locale" to the called grid form with no problem;
-Item b and c is almost ok:
- All the rest of processing, like working with variable value and some query, is made on the Grid form, at the Open Event.
- I'm using, for example, $txt_locale=Get_Param("$txt_locale") to get the value of passed variable;
- After that, if field was filled, I made a dlookup() to get ID value from another table (foreign key at the main table, the next to be queried). Thats ok.
- After taking ID value, I change $sWhere variable, to add a condition with ID taked from first SQL, to the next SQL (main table). Ok too, so the SQL Query runs nice !
- The problem is: if the grid results runs on multiple pages, after "next-page submit", variable value "$txt_locale" is lost, and the subsequent SQL Queries return undesirable results.
- Seems that I have to maintain the value of "$txt_locale" (or "ID") variables between this subsequent calls, but I don't know how to do it. I have tried many things, and nothing has worked...!
Thanks in advance.
|
|
|
 |
Brent
|
| Posted: 05/10/2002, 1:05 PM |
|
Marcello,
The problem is the grid is losing the search parameters. On your grid form,
you need to create a set of input parameters that match your search fields. So if
your search field had "txt_locale" then create one for the grid using the Input tab
and make sure "Transfer" is checked. This will transfer this parameter to the next page,
which is itself. :)
Brent
|
|
|
|
|
