Dynamically populate DropdownListbox
I have a column in a datawindow that has the DropdownListbox edit style. I'm populating the display and data values dynamically in code by using the Values property. However, I want to use NULL as the data value for one of the choices. I have the 'Empty String is NULL' checked. How would I go about doing this?
If I use a Display Value (example 2 below), it does not work. When I don't use a Display Value (example #1), it works fine. For example,
1) ls_values = "chaintype.Values='~t~~'~~
2) ls_values = "chaintype.Values='Store~t
Please advise.
Thanks!
If I use a Display Value (example 2 below), it does not work. When I don't use a Display Value (example #1), it works fine. For example,
1) ls_values = "chaintype.Values='~t~~'~~
2) ls_values = "chaintype.Values='Store~t
Please advise.
Thanks!
Hi,
Did you try using the function setValue () instead ? ( Just try it, I haven't tested it..)
dw_1.SetValue("chaintype",
regards,
Vikas
Did you try using the function setValue () instead ? ( Just try it, I haven't tested it..)
dw_1.SetValue("chaintype",
regards,
Vikas
I do not have a solution to this but I wanted to say that having a Null value in a column mean anything other than null /not enetered is usually not a good idea. BTW - What version of PB are you using?
As per the PB help, The function is goung to return null if any of the parameters are null.I guess you are using modify function if Modify() returns '' then it means success.. then why do you say example 2 is failing ??
--Vikas
--Vikas
I say it's failing because in the ItemChanged event, I want the 'data' argument to be null, not ''. In example 2, I'm getting ''.
Do you Want both the values null and blank in your ItemChanged Event ? I mean do they have seperate processing ?
IF no, you can write your logic to handle both in the same manner. And if you are saving it to database, then it should not be an issue, the blank should go as null. can you try the same once ?
Regards,
VIkas D.
IF no, you can write your logic to handle both in the same manner. And if you are saving it to database, then it should not be an issue, the blank should go as null. can you try the same once ?
Regards,
VIkas D.
Or this
dw_employee.SetValue("emp_
dw_employee.SetValue("emp_
regards-
dw_employee.SetValue("emp_
dw_employee.SetValue("emp_
regards-
hi colettim,
what u require is a null value.... wouldn't it help in the case of example 2 that u simply write the code..
If Trim(ls_values) = "''" Then SetNull(ls_values) // coz u know that the value u want as null returns ''
.... or is it hard and fast that data should return a null
Cheers,
Rosh
what u require is a null value.... wouldn't it help in the case of example 2 that u simply write the code..
If Trim(ls_values) = "''" Then SetNull(ls_values) // coz u know that the value u want as null returns ''
.... or is it hard and fast that data should return a null
Cheers,
Rosh
Wow, thanks for all the suggestions! I'm going to try yours, namasi. I will let you all know which one works and reward the points.
To answer some of the questions, yes I do want to save the value of NULL in the database. I know that is bad database design but it's the way the database table is.
Thanks again for all the prompt responses!!!
To answer some of the questions, yes I do want to save the value of NULL in the database. I know that is bad database design but it's the way the database table is.
Thanks again for all the prompt responses!!!
namasi,
Your suggestion worked fine except for one problem.
Here is the code that I used:
dw_1.SetValue("chaintype",
When I choose 'Store' from the chaintype dropdownlistbox and select another column, 'Store' disappears.
Your suggestion worked fine except for one problem.
Here is the code that I used:
dw_1.SetValue("chaintype",
When I choose 'Store' from the chaintype dropdownlistbox and select another column, 'Store' disappears.
colettim,
Yes. The display value will disappear when you click on other columns. Why would you need to store Null when 'Store' is selected. Could you not store 'S' or something like that. ?
In my app it is coded as shown below, so it was not a concern.
dw_1.SetValue("chaintype",
regards-
Yes. The display value will disappear when you click on other columns. Why would you need to store Null when 'Store' is selected. Could you not store 'S' or something like that. ?
In my app it is coded as shown below, so it was not a concern.
dw_1.SetValue("chaintype",
regards-
If using pfc you can do this preupdate event. If using non-pfc do this before update statement is sent to the database.
long ll_count, ll_i
string ls_null
SetNull(ls_Null)
ll_count = dw_1.Rowcount()
For ll_i = 1 to ll_count
If dw_1.GetItemString(ll_i, 'chaintype') = 'store' then
dw_1.SetItem(ll_i, 'chaintype', ls_null)
End if
Next
Let me give you a risky approch but you will need to test this well.
long ll_pos
if sqltype = PreviewUpdate! then
ll_pos = Pos(sqlsyntax, "='Store'")
If ll_pos > 0 then
replace( sqlsyntax, ll_pos, 8, 'NULL')
//TO debug
MessageBox("debug", sqlsyntax)
end if
end if
regards-
long ll_count, ll_i
string ls_null
SetNull(ls_Null)
ll_count = dw_1.Rowcount()
For ll_i = 1 to ll_count
If dw_1.GetItemString(ll_i, 'chaintype') = 'store' then
dw_1.SetItem(ll_i, 'chaintype', ls_null)
End if
Next
Let me give you a risky approch but you will need to test this well.
long ll_pos
if sqltype = PreviewUpdate! then
ll_pos = Pos(sqlsyntax, "='Store'")
If ll_pos > 0 then
replace( sqlsyntax, ll_pos, 8, 'NULL')
//TO debug
MessageBox("debug", sqlsyntax)
end if
end if
regards-
Thanks for using Experts Exchange.
Please provide your email to receive a sample view!
*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.