Limited Field Set Used In Business Object


Author
Message
Clayton Hoyt
Clayton Hoyt
StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)
Group: Forum Members
Posts: 40, Visits: 85
Hi Folks

I often have a use for a limited set of fields from a table (i.e., for an employee drop list, I don't need their address, phone, etc. only their ID and Name). How do you recommend doing this? In the past, I have created a function which returns a datatable but then its not strongly typed. I have also used strongly typed datasets but I would rather not use both Strataframe objects and Strongly Typed Datasets so I can keep everything consistant.

Thanks

Clay

Reply
Paul Chase
Paul Chase
Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)
Group: Forum Members
Posts: 414, Visits: 2.8K
Clay,

I just create a method on the bo and select the fields I need.

Public Sub FillAllCustomerNames()

Me.FillDataTable("Select CustomerName,Cu_id from customer")

End Sub

This does leave the possibility that you can screw up be refencing a field that is on the bo but not contained in the uderlying datatable. This hasnt been an issue for me though.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search