Dynamically populate DropdownListbox

Hi,

Did you try using the function setValue () instead ? ( Just try it, I haven't tested it..)

dw_1.SetValue("chaintype", 1, "Store")

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

I'm using PB 7.0.3.  Thank you..

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.

Within dropdownlist box NULL is represented by enumerated type Null!

Regards-

Or this

dw_employee.SetValue("emp_state", 1, "Texas")
dw_employee.SetValue("emp_state", 1, "Texas~tNull!")

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

have a look

http://www.experts-exchange.com/Programming/Programming_Languages/PowerBuilder/Q_20828229.html

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!!!

namasi,

Your suggestion worked fine except for one problem.

Here is the code that I used:

dw_1.SetValue("chaintype", 1, "Store~tNull!")

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", 1, "NULL~tNull!")

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-