questions regarding userdatasources-
I have questions regarding userdatasources.
I have been trying to use them to populate fields linked to CFL's on a UDO.
The UDO is a document type object and I'm trying to mimic the behaviour of the existing document type forms. (ie sales order, delivery, invoice)
This is what I can do:
1. I can create a UDF at the document header level and link it a CFL.
2. I can bind the UDF in step 1 to a userdatasource and I can successfully populate the UDF with the value selected from the CFL.
This is what I can't do:
1. The value that is returned to the UDF does NOT get populated to the database when I click the Add/Update button on the form linked to my UDO, even though the other fields I am populating do get updated to the database.
2. The value that is returned to the UDF does NOT get cleared when I browse from one document to another.
Can I use a userdatasource in the above fashion?
Should I be using something different- like a datatable?
Frank Moebius replied
Re 1. There's no connection between UserDataSource and database; if you want to get the data into the DB you have to set it into the corresponding DBDataSource.
Re 2. I will double-check that detail, but I think it is connected to 1.