>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)