Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Storing An Image In A SQL Table
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01234808
Message ID:
01234849
Views:
28
Sergey, I'm using this to try place an image into the SQL table. I'm getting a Data Type Mismatch on the APPEND line.

Any idea what's wrong here?
OPEN DATABASE ImageLoad

IF USED("v_ImageTest")
	USE IN v_ImageTest
ENDIF

SELECT 0
USE v_ImageTest

cImageName = SYS(2015)
cImageFile = "d:\projects\pmis\version8\vfp9\source\graphics\test_image.bmp"

INSERT INTO v_ImageTest;
	(ImageName);
	VALUES;
	(cImageName)

APPEND MEMO ImageFile FROM &cImageFile OVERWRITE

RETURN
>>How to I store an image in a SQL table?
>
>You can use Image data type in SQL 2000 and varbinary(MAX) in SQL 2005.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform