Hi there,

I wonder if something like this would work. I got a BO which maps one table and send a

SQL-command like this

select table1.field1, table1.field2*table1 as somecalcfield, table2.anotherfield from table one left outer join table2 on.......

I know, that I could easily get this by using a view and map it but for reasons of runtime-flexibility I would like to know if this field from table2 can be accessed through the BO which maps only table1. It would make some situations easy where I want to replace foxpro-code utilizing the create cursor-command.

Thanks in Advance

Thomas

Thomas:

Hi Trent,




thank you for your answer but how do I implenet accessing the field from the joined table. The query is already working but I do not see the field from table2.  I implemented a custom property but do not know how to fill ist with data?

<Browsable(False), _

BusinessFieldDisplayInEditor(), _

Description("Warengruppen-Bezeichnung"), _

DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _

Public ReadOnly Property [FIELDFROMTABLE2]() As System.String

Get

Return ?????

End Get

End Property

I do not know what to write in that return command?

Thanks a lot

Thomas

You would just copy one of the fields from the designer file on the business object like so:

Hi Ben,

thanks a lot for your help. Your example has taught me a fine way to to something similar to the Cursors I used a lot for statistics and reporting. I can now build a BO consisting of Data from different tables, enpty fields to fill later and calculated fields in one select-command. There is one assumption/question left: As I understand it, I can add data to the BO temporarily (not wanting to save anything) for the above mentioned reasons as Long as I do not issue a save-command and undo this in my form-closing-Event? I tried it and it seems to work but I am still a bit insecure.

Best regards

Thomas

Nothing to be insecure about, Thomas  The BOs are used to save records as well as act as a client-side storage for data.  Since they have a DataTable that stores the data internally, they can have any structure you want.  

Hi Ben,

thanks again for your help,

Best regards

Thomas