Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to do without going over 128?
Message
From
21/03/2002 15:30:23
 
 
To
21/03/2002 15:23:24
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00635664
Message ID:
00635712
Views:
16
Have you tried the SET NOCPTRANS command to prevent translation on that field?

>Exactly, but I think we have it working by using cpconvert(1252,437,fieldname). We are testing it now. It seems that when retrieving data from a table with a codepage of 437, windows converts it to 1252 before displaying it, but when saving to a 437 table, it saves it in the 437 codepage. Correct me if I am wrong...
>Tracy
>
>>So your problem is years 1994-1999?
>>
>>>The year (4 digit) is uploaded to an AS400 system for auto policies. The original app is written in FPD26 and converts the year (i.e. 1985) to a two-digit code using the code below. Since the tables are accessed from both the original app and the new VFP app, the codepage is set to 437 on the tables. The problem is in the code below. It converts correctly until you read or write the conversion to the table and then Foxpro converts it again. I need a way to convert it where it can be read from fpd26 and vfp from tables with a codepage set to 437.
>>>TIA
>>>Tracy
>>>
Steve Gibson
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform