StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Instead of a view - Is this possible or nonsense

Instead of a view - Is this possible or nonsense

Thomas Holste — Fri, 06 Feb 2015 10:26:46 GMT

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

[code]

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

[/code]

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

RE: Instead of a view - Is this possible or nonsense

Thomas Holste — Fri, 06 Feb 2015 10:26:46 GMT

Hi Ben,

thanks again for your help,

Best regards

Thomas

RE: Instead of a view - Is this possible or nonsense

StrataFrame Team — Fri, 06 Feb 2015 06:14:11 GMT

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.

Also, you can add columns to the DataTables and still save BOs. A business object has a list of the mapped columns from the table in the database, so when it saves, it will only try to save back the columns that are mapped and it will ignore the others.

RE: Instead of a view - Is this possible or nonsense

Thomas Holste — Fri, 06 Feb 2015 04:05:01 GMT

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

RE: Instead of a view - Is this possible or nonsense

StrataFrame Team — Thu, 05 Feb 2015 13:37:47 GMT

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

Public Property FieldFromTable2 As String

Get

Return DirectCast(Me.CurrentRow("FieldFromTable2"), String)

End Get

Set (value As String)

Me.CurrentRow("FieldFromTable2") = value

End Set

End Property

Whatever you put as the "FieldFromTable2" when accessing the CurrentRow indexer just needs to match the alias of the column in the results of the query.

RE: Instead of a view - Is this possible or nonsense

Thomas Holste — Thu, 05 Feb 2015 13:30:18 GMT

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?

[code]

<Browsable(False), _

BusinessFieldDisplayInEditor(), _

Description("Warengruppen-Bezeichnung"), _

DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _

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

Get

Return ?????

End Get

End Property

[/code]

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

Thanks a lot

Thomas

RE: Instead of a view - Is this possible or nonsense

Trent L. Taylor — Thu, 05 Feb 2015 11:49:01 GMT

Thomas:

You can most definitely access it and you can even create a custom property so that it is strong-typed in code, etc. But you will not be able to write back to the table without code changes. If you need the table to be updatable, then you will have to use a view. If you are just bringing it in for client-side access, then you are good to go.