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
* [Kestutis Laurinavicius] prevent change ole codepage
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