Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Blob with MySQL
Message
From
02/05/2009 12:03:10
 
 
To
01/05/2009 23:12:36
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
MySQL
Miscellaneous
Thread ID:
01397385
Message ID:
01397607
Views:
45
Hi Hanafi,

try changing this line:

Repl Pict with FiletoStr("C:\AVFP\SWIFT.JPG")

to this

Repl Pict with cast(FiletoStr("C:\AVFP\SWIFT.JPG") as W)

and see what happens.

When you get it back, you'll have to Cast in the opposite direction, as M.

Hank

>Hii, Martina.
>
>I'm afraid its not doing well with me. My code is like this
>
>
>Local MCommand, MGambar
>
>MId = 'OL'
>
>Create Cursor F_Temp (Pict W)
>Appe Blank
>Repl Pict with FiletoStr("C:\AVFP\SWIFT.JPG")
>
>MCommand = "Update Cars Set Pict1 = ?F_Temp.Pict Where Id_Car = ?MId"
>
>XX = SQLEXEC(M_IdKoneksi, MCommand)
>
>Use in F_Temp
>
>**************
>
>Still XX Return -1
Previous
Reply
Map
View

Click here to load this message in the networking platform