I need to add an enhancement to an existing application. The enhancement is to allow attaching a file (pdf, gif, jpg, etc) to the database. All the information for the table will have to be inserted with the actual file (blob). I have created the following table in the database but I don't have a clue of how to add the file to it in VB6.0.
I'm looking for a quick and simple way of doing it in VB6.0. Please help?
The LotID, TestID and SeqNo info will be available when this function/sub is run...
Any help would be greatly appreciated!
the following table: Attachments
Field Name Constraint DataType Description
LotID PK NOT NULL NUMBER(10) Lot identifier LotID in LotRecords table
TestID PK NOT NULL NUMBER(10) Test identifier DBID in Tests table
SeqNo PK NOT NULL NUMBER(10) Sequence identifier
FName NOT NULL VARCHAR2(256) Name of the file (no drive or path information).
FExt NOT NULL VARCHAR2(5) File name extension (pdf, gif, jpg, etc)
FCreate NOT NULL DATE Date/time stamp when file was created
FAttached NOT NULL DATE Date/time stamp when file was attached
EmployeeID NOT NULL NUMBER(10) Who attached the file
FImage NOT NULL BLOB Associated binary data or binary file image