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
De
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:
00673262
Vues:
14
>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform