How to access binary type field in MSSQL 2000 with Delphi 6

Huang Bo

Delphi Developer

Wed, 21 Apr 2004 14:45:25 GMT

How to access binary type field in MSSQL 2000 with Delphi 6

Hello, all,
I use ADOQuery or ADOCommand to update or insert data into a binary
field in MS SQL 2000. But when I assign value to the parameter like this:
ADOCommand1.Parameters.ParamByName('BinField').Value := SomeData;
it always report error.
I tried many times and still can't know which proper data type should the
var 'SomeData' be. In other words, how can I assign value to a parameter of
a binary type field?

Can anyone help me? Thanks in advance.

Huang Bo

Kevin Frever

Delphi Developer

Thu, 22 Apr 2004 22:51:12 GMT

Re:How to access binary type field in MSSQL 2000 with Delphi 6

Huang Bo,

Try setting the parameter datatype to ftBoolean

Good luck,
krf

Quote

Huang Bo <huangbo_n...@yahoo.com> wrote in message news:3be392a3_2@dnews...
> Hello, all,
> I use ADOQuery or ADOCommand to update or insert data into a binary
> field in MS SQL 2000. But when I assign value to the parameter like this:
> ADOCommand1.Parameters.ParamByName('BinField').Value := SomeData;
> it always report error.
> I tried many times and still can't know which proper data type should the
> var 'SomeData' be. In other words, how can I assign value to a parameter
of
> a binary type field?

> Can anyone help me? Thanks in advance.

> Huang Bo

Other Threads

1. How to access binary type field in MSSQL 2000 with Delphi 6 Ent

2. paradox binary type to sql server 2000 ...

3. how get all USER DEFINED DATA TYPE from MSSQL 2000 DB

4. Store binary information in ACCESS 97/2000 database

5. retreiveing bitmap and assign at blob field (MSSQL 2000)

6. MSSQL 2000 Identity Field

7. MSSQL 2000 / fun : Upper(), Size Mismatch for field!

8. Access 2000 vs MSSQL 7 for single user, high transaction volumes

9. New Native BDE-Drivers for ACCESS 2000 AND MSSQL 7

10. MSSQL 2000 vs MSSQL 7.0 productivity