Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Storing An Image In A SQL Table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01234808
Message ID:
01234849
Vues:
27
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform