Parameter issue w/ data-base driven text box

[ppbedz]

I have a database driven auto-complete field with 2 parameters, but it does not work. When I debug the program, the developer tools indicate that there are 3 parameters? I have tried deleting the field and recreating it, but I still have the same problem. I have another data-base driven auto-complete in the same grid with One parameter, and the developer tools confirm that there is ONE parameter. Can you help me determine why the field with TWO parameters is being interpreted as having THREE parameters?

[Glenn]

Patti,

I'm not certain what is happening in the developer tools but your properties aren't making sense to me. Your screenshot shows a textbox's 'value' property bound to a variable named S2TESTCD with the 'choices parameter value 2' bound to the same S2TESTCD variable. I don't see how that will work. Perhaps I'm missing something or the screenshot is of 2 different textboxes?

Glenn

[ppbedz]

Glenn,

There are 2 text boxes... one is s2typecd and one is s2testcd. As you can see, I am passing to parms one and two. For some reason, Profound thinks there are 3 parameters.

Patti

[Scott Klement]

Actually, since your fields are bound to DDS variables, the data for the parameter markers shouldn't be sent from the display, it should just be taken from data on the server. I wonder why there are even parameter markers in your developer tools at all??

[ppbedz]

Scott,

Not sure if this is causing the confusion, but the data I am working with is in a grid. My fields are actually database-driven text boxes that are coded as "read only". I used this technique so Profound could fill in the code description based on the code value passed in as a parameter. In this case there is a "type code" and a "test code". Both are values in the grid. Since I am not inputting any data, I can't really use "on change" to populate a variable with the code and row number. Is there any other way to do it other than populating the codes descriptions in the rpg when I load the sfl? Is there a way to run an sql statement that accepts a parm and retrieves a value from javascript?

Thank you,
Patti