Fox-id.org :: Komunitas FoxPro Indonesia

General Category => General/Umum/OOT => Topic started by: vic on May 12, 2011, 05:49:51 AM

Title: Type Text & Blob in VFP+MySql
Post by: vic 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:
Title: Re: Type Text & Blob in VFP+MySql
Post by: fahmiidris 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)
Title: Re: Type Text & Blob in VFP+MySql
Post by: vic on May 13, 2011, 04:06:14 AM
Thanks sobat.....  :icon_thumleft: :icon_thumright:
Yang sy maksud gambarnya disimpan dalam database (bukan patch-nya)....
Title: Re: Type Text & Blob in VFP+MySql
Post by: vic on May 13, 2011, 04:59:55 AM
# fahmiidris :
Thank's infox
Solusinya udh ketemu..
GoodLuck............