Save Picture File in SQL Server Table
From: NR (NR_at_discussions.microsoft.com)
Date: 08/04/04
- Next message: NR: "Save Picture File in SQL Server Table"
- Previous message: Hitendra: "C0000005 Error with Oracle Backend"
- Next in thread: Remus: "Re: Save Picture File in SQL Server Table"
- Reply: Remus: "Re: Save Picture File in SQL Server Table"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 4 Aug 2004 03:07:02 -0700
Hi there,
I need to know how can i save picutre in SQL Server table.
I am using VFP 6.0 as front end and SQL Server at back end. I have already tried FILETOSTR() AND STRTOFILE() Function which performs well with Foxpro table but it does not work with SQL Statement as follow;
tmpString=FILETOSTR("Picture.Bmp")
=SQLExec(connHandler,"Insert Into temp (EmpPhoto) Values ('"+tmpString+"')")
It looks String already contains some single quotes which creats ambiguity.
Would be very thankful for any help in this regard.
- Next message: NR: "Save Picture File in SQL Server Table"
- Previous message: Hitendra: "C0000005 Error with Oracle Backend"
- Next in thread: Remus: "Re: Save Picture File in SQL Server Table"
- Reply: Remus: "Re: Save Picture File in SQL Server Table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
