Hi All,
I have a question how NOCPTRANS works with SQL SELECT.
The code is from FoxBin2Prg
https://github.com/fdbozzo/foxbin2prg/blob/master/foxbin2prg.prg, the problem is issue
https://github.com/fdbozzo/foxbin2prg/issues/95 .
There is a proposed code:
With This As c_conversor_scx_a_prg Of 'FOXBIN2PRG.PRG'
Use (.c_InputFile) Shared Again Noupdate Alias _TABLAORIG
SET NOCPTRANS TO ole
Select _TABLAORIG.*,Recno() regnum From _TABLAORIG Into Cursor TABLABIN Readwrite
Use In (Select("_TABLAORIG"))
The table is used, the ole field set NOCPTRANS, the whole thing is put into a cursor and the table is closed. (subsequently only the cursor is used - and the field of the cursor is set again to NOCPTRANS)
My question: Does NOCPTRANS changes something on the result cursor? Would it be enough to set only the field of the curssor NOCPTRANS?
Thanks
Lutz
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]