StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » To return from DataBase

To return from DataBase

Malcon M. Mikami — Fri, 06 Feb 2009 13:23:42 GMT

How I can catch the value of a Binary field Date of the SQL Server 2k5? Table SFSAuditEvents I want to return the binary value for an object, stops later making the conversion for the correct type (adf_DataType).
1 1 us_FirstName 0 <Binary data> <Binary data>
2 1 us_MiddleName 0 <Binary data> <Binary data>
3 1 us_LastName 0 <Binary data> <Binary data>
NULL NULL NULL NULL NULL NULL

RE: To return from DataBase

Ivan George Borges — Fri, 06 Feb 2009 13:23:42 GMT

This is what I am doing at the moment, but it only works because I know there is going to be only text in it. I know that this is going to be authomagicaly dealt in the near future.

[codesnippet]

Dim enc As New System.Text.ASCIIEncoding()

txtData.Text = enc.GetString(AuditEventsBO1.ae_Data)

[/codesnippet]