Board index » delphi » How to insert a big exe file into a Blob Field in SQL Server 6.5

Tech

Delphi Developer
Mon, 18 Feb 2002 03:00:00 GMT

How to insert a big exe file into a Blob Field in SQL Server 6.5

How to insert a big exe file into a Blob Field in SQL Server 6.5
Thx!

JSG

 
Steve Koters

Delphi Developer
Mon, 18 Feb 2002 03:00:00 GMT

Re:How to insert a big exe file into a Blob Field in SQL Server 6.5


Quote
On Thu, 2 Sep 1999 11:36:19 -0400, "Tech" <tech3...@videotron.ca> wrote:
>How to insert a big exe file into a Blob Field in SQL Server 6.5
>Thx!

One way would be with the TBlobField.LoadFromFile method.

  (Query1.Fields[44] as TBlobField).LoadFromFile('e:\thefile.exe');

Or, you could create a TfileStream object to represent the binary file.
Then use the TBlobField.LoadFromStream method to copy from file stream to
BLOB field.

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Steve Koterski              "Health nuts are going to feel stupid someday,
Felton, CA                  lying in hospitals dying of nothing."
                                                              -- Redd Foxx

Other Threads

1. Problem inserting BLOB Fields (SQL 6.5 D3 C/S)

2. Extract BIG EXE File from SQLServer 6.5

3. Blobs greater than 32K in SQL-Server 6.5/Delphi 3.0

4. "Invalid Blob Length" -SQL server 6.5

5. SQL Server 6.5 and BLOBs

6. Invalid blob length in SQL Server 6.5

7. BDE Error 12292 with SQL Server 6.5 and Blobs

8. Truncating blob to 32K in SQL server 6.5

9. BLOB's and SQL Server 6.5

10. SQL 6.5 update field value on insert trigger