Post by Stoyan Malchev Is it possible to specify the codepage for mytable in the statment select * from mytable Thanks in advance
Hello Stoyan, Maybe you should set your table's codepage once and perform "normal" ;-) selects? cMyTablePath = "C:\mytable.dbf" nTableCodepage = 852 DO (HOME(1)+"Tools\CpZero\CpZero.prg") with cMyTablePath, nTableCodepage If you can't do that , then look at the CPCONVERT( ) function. -- Pozdrawiam, Marek Hryceniak
As of VFP9 you can add CODEPAGE=nCodepage to the CREATE TABLE and CREATE CURSOR commands CREATE CURSOR xx CODEPAGE=936 (id Integer, name Character, registered Datetime. Mem Memo NoCPTrans ) INSERT INTO xx SELECT * FROM my_other_code_page_table
I haven't checked but the may be like performing a CPCONVERT() on all character convertible fields.
-Anders
Post by Stoyan Malchev Thanks, Marek But I am looking for a way to set the codepage without modifying the source table
Post by Stoyan Malchev Is it possible to specify the codepage for mytable in the statment select * from mytable Thanks in advance
Hello Stoyan, Maybe you should set your table's codepage once and perform "normal" ;-) selects? cMyTablePath = "C:\mytable.dbf" nTableCodepage = 852 DO (HOME(1)+"Tools\CpZero\CpZero.prg") with cMyTablePath,