Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Save a .bmp in a image type filed of a sql table
Message
 
À
28/06/2002 10:15:04
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00672998
Message ID:
00673269
Vues:
16
>>Hi again
>>I have resolve my problem this way.
>>I creat a tempory table with a generale field contaning my image
>>Next i insert in my sql table my general field like this
>>Ex.:
>>Use c:\Plan alias Plan In 0 Shared
>>Go top
>>Do while !eof()
>>lstrsql = "Insert into TblPlan (ImmPlan) values (?Plan.Imm)"
>> SqlExec(Z_Conn,lstrsql,"ctest")
>> skip
>>Enddo
>>
>>Thanks again
>
>In general, when processing records from a table, you can save a few commands with the SCAN loop.
>
>Also, if you USE IN 0, there is no guarantee that this table is actually selected.
>
>I will rewrite your example, to consider these points:
>
>
>select 0
>Use c:\Plan alias Plan Shared
>scan
>lstrsql = "Insert into TblPlan (ImmPlan) values (?Plan.Imm)"
>   SqlExec(Z_Conn,lstrsql,"ctest")
>endscan
>
>
>Hilmar.

Hi Hilmar
you are write thanks for the tips

Ben
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform