Adding BLOB data via sql exec

P

Pavils Jurjans

hallo,

is there a way to add binary BLOB data to field, using a kind of sql syntax?

INSERT INTO MyTable ( dataNum ) SELECT 1234 AS dataNum;

INSERT INTO MyTable ( dataBin ) SELECT whateverSyntaxHere AS dataNum;

I know there is nice syntax for MS SQL, and I am looking for JET driver
syntax here

thanks,

-- Pavils
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top