I left joined credit cards to customers ( handling nulls and returning "NO CARD ON FILE") so there is a cardnumber field being returned in the cursor that I get with the stored proc

At debug time in me.customersbo1.currentview I can see the cardnumber column with data.

I looked in BO mapper and there doesn't look to be anyplace there to fake the BO into created a property (probably just as well as I assume it could not be updateable)  Thought a custom field prop would be the way to go but

Return Cardnumber gets the error that it must be declared - but I'm not sure what the syntax is to tell it the field will be in the cursor at runtime

( I do realize that if I add a custom prop in this way I will probably need to always be sure it is provided in each data access scenario.  Does that mean I should be creating a view on the back end so the field is present in the definition when the bizobj is mapped?  No problem, if that's the case but wanted to make sure there wasn't another trick I was missing as I might want to display something like this without having to create an updateable view on the back end)

TIA

Charles

Your custom field property should return a value and in your code the cardnumber has not value.  Modify the Return value to return the calculated field as follow:

Sorry, it should be:

I did get my two custom props (the cust_lastname in the tutorial and my new prop) into an array properly.  ( I rewrote my proc to pull the most recent order as creditcard is a varchar(max) and may be encrypted and I just wanted to simplify)

My new prop is Orderpo but my problem is in the GET SET

Obviously I'm missing something. 

RETURN me.currentrow.item("orderpo")

seems to give me exactly what I want (I was trying something like that in the watch window earlier with me.currentview.item("orderpo") but of course now I see why that wouldn't work)

Found the right syntax by just searching around here on all the message re custom properties

This framework, this forum and this community ROCKS !!

It looks like you got it going.  I didn't work this weekend so I wasn't out on the forum much.  But you did get it figured out.  Returning a field or column from a joined table is a must in the disconnected world.  So in order to interact with it, just create the custom property and then...as you discovered...call the Me.CurrentRow.Item("MyField") property on the return an you have it.  If you intend to bind this field to anything, you will need to override the GetCustomBindablePropertyDescriptors method and return a ReflectionPropertyDescriptor.  There are a ton of posts and docs regarding this, but if you get stuck just let me know.

I agree Thanks for your kind words...and thanks for your input, Edhy!  I know that Charles appreciated it!

Trent, thanks for the explanation.

Charles, I am glad you find it.  In fact I was not sure on the right answer since I have not done that yet, but I knew it has something to do with the return value of the custom field property, now I know

If you intend to bind this field to anything, you will need to override the GetCustomBindablePropertyDescriptors method and return a ReflectionPropertyDescriptor.  There are a ton of posts and docs regarding this, but if you get stuck just let me know.

Thanks to a some posts between Greg and Peter Jones I figured out the array and the sample in the tutorial make more sense

Once the project is rebuilt the field appears in the enumeration for binding field and displays just what I need.  Of course the field is read only, as it should be.

Thanks for the heads up.  in this case I'm joining to another table in the stored proc so I think there will always be a column.  Since I'm doing a left join, I'm testing for null in the initial select and returning a "NO PO NUMBER" string in the case of a null value.

This exercise was a reminder, however, to actually look at the test data before making ***-umptions about the results. (hey that's cool, I put in a hyphen to emphasize the old trope about assumptions and the parser censored me ) The ORDERS table in the Strataframe Sample Data is mostly blank in the or_ponumber field and I really suspected I was having a series of senior moments when I finally got the binding to work, did my thing to check nulls and still ended up with a blank textbox on the screen and a blank in the field in the currentview.  Thought I may have forgotten everything I knew about SQL. 

But of course I was getting just what I asked for - I just didn't know I'd asked for a column where most of the values were blank

I am going to test now to see if an exception is thrown if there is no data at all in the cursor as I'm starting to think the gist of your suggestion may be that custom props do not behave like bomapper props when the query pulls an empty recordset. 

Honestly I only do this when there is the potential for this to occur.  If this should never occur based on my logic, then I don't do this so I get an error message preventing any other downstream errors.

I understand Greg's suggestion for a try - catch so you can have fill methods that do not use that joined column, but my question is :

Do custom field properties behave differently from bomapper field properties if the fill method returns no records and is that what we are testing for and would that need to be handled if there were no customer field props?

If you are just pulling from thr CurrentRow, then no.  They behave just like any of the other properties.  Obviously if you add additional logic past just retrieving the value then you have need to take this into account.  But otherwise it will behave like any other field property.