Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread DBISAM, BLOB C#
Tue, Mar 15 2011 12:03 PMPermanent Link

jjluna

Good Morning.

How do I know the structure of a blob field? I don't know the inner structure of the database since it was developed some time ago. Knowing the structure of the blob field, how do I read /write it from c# or visual basic?

Thanks in advance!
Tue, Mar 15 2011 12:17 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Hello

A BLOB field doesn't have a structure, its a binary field, it can contain raw binary data, whatever it is.
To see and edit the structure of the database, you may use DbSys - the "Database System Utility" application.
Its a free utility that you can download from Elevate's website .

Fernando Dias
[Team Elevate]
Fri, Mar 18 2011 2:04 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< How do I know the structure of a blob field? I don't know the inner
structure of the database since it was developed some time ago. Knowing the
structure of the blob field, how do I read /write it from c# or visual
basic? >>

You deal with BLOB fields in C#/VB.NET in the same way that you deal with
any BLOB field in any other database, via the ODBC.NET data provider along
with the DBISAM ODBC Driver:

http://www.elevatesoft.com/download?action=info&category=dbisam&type=dbisamodbctrial&majorversion=4&version=4.30

and by using a byte array:

http://support.microsoft.com/kb/309158

Just replace all of the Sql* objects in the Microsoft example with Odbc*
objects.  Also, the connection string will be slightly different for the
DBISAM ODBC Driver, and you can find the connection string attributes here:

http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4odbc&topic=Connection_Strings

--
Tim Young
Elevate Software
www.elevatesoft.com
Image