questions regarding userdatasources-

[Former Member]

All,

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?

thanks

John

[former_member185703 · Accepted solution]

Hi John,

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.

HTH,

Frank