Group: StrataFrame Users
Posts: 430,
Visits: 507
|
Hi Greg. Finally got to the bottom of this
Aside from the confusion with the Ref and Value parameters, I moved the method back to running without the ref. This was not working , so I though it had something to do with the way the parameters were being passed, but turns out that that was a red herring.
There were two reasons why the fields were not being updated onto the BO field:
1. I had copied the default table over from a VFP table (Into Sql Server). Say I had a 10 character field, IN VFP it was stored as 10 characters with trailing spaces. So for instance NY would be stored as NY and 8 trailing spaces. Now any lookups in VFP did not seem to have any issue with this (even with Set Exact ON) but in C#, this is causing some problems. When I did a trim, it works fine
2. Some of my default values ended up in a Combo Box , whose source is a select out from another table as a Lookup. Again, if the default value I insert into the Lookup field does not exist in the Lookup Source table, it just is not populated. When i ensured that the default field matched exactly at least one of the fields on the lookup, it works fine.
Many thanks again for your very detailed and thorough assistance
|