Author Topic: Type Text & Blob in VFP+MySql  (Read 1568 times)

0 Members and 1 Guest are viewing this topic.

Offline vic

  • Junior Member
  • *
  • Posts: 145
  • Jangan Cuman Berdoa Pak, USAHA
Type Text & Blob in VFP+MySql
« on: May 12, 2011, 05:49:51 AM »
Salam Sahabat Foxer..... Saya lg binggguuung(Gak tw carax) ni dgn VFP, Tolong bantuanya tentang :
1. Gimana cara menampilkan tipe data TEXT pada grid ??
2. Gimana cara mengolah (Insert/Update/Delete/Show) tipe data BLOB pada image??
nb. Database : MySQL Server, Engine : InnoDB

Thank's B4............  :icon_salut:

Offline fahmiidris

  • Junior Member
  • *
  • Posts: 126
    • http://
Re: Type Text & Blob in VFP+MySql
« Reply #1 on: May 12, 2011, 06:25:47 AM »
gunakan fungsi Filetostr( ) dan  Strtofile( )

img="temp\KATALOG.PDF"

field name <--  Filetostr(img)

untuk membuka  atau menjalankan kan saya biasa pakai

cFileName= "KATALOG.PDF"
img="temp\KATALOG.PDF"

hndWin= 0
cAction= "open"
cParams= ""
cDir= "temp\"
nShowWin= 1

=Strtofile( field name, img, .T.)
=ShellExecute(hndWin,cAction,cFileName,cParams,cDir,nShowWin)

Offline vic

  • Junior Member
  • *
  • Posts: 145
  • Jangan Cuman Berdoa Pak, USAHA
Re: Type Text & Blob in VFP+MySql
« Reply #2 on: May 13, 2011, 04:06:14 AM »
Thanks sobat.....  :icon_thumleft: :icon_thumright:
Yang sy maksud gambarnya disimpan dalam database (bukan patch-nya)....

Offline vic

  • Junior Member
  • *
  • Posts: 145
  • Jangan Cuman Berdoa Pak, USAHA
Re: Type Text & Blob in VFP+MySql
« Reply #3 on: May 13, 2011, 04:59:55 AM »
# fahmiidris :
Thank's infox
Solusinya udh ketemu..
GoodLuck............