Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Char vs Oracle Varchar2 data question
Message
From
06/11/2006 16:12:16
 
 
To
25/10/2006 18:18:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01164448
Message ID:
01167470
Views:
10
>try, into the datasession:
>
>CURSORSETPROP("MapVarchar",.T.,0)
>
Thanks Fabio. This works.

I would like to add these two things that are worth noting.
1. If the data had been 'updated' previously in VFP8; it would have the padded spaces already in Oracle.
2. There is still a limit of 254 characters on this field. Otherwise, Oracle data is translated to Memo.

Also, it is an environment setting only - uses the third param of 0. It's one way or the other which, IHMO, is a good idea.
ramil
~~ learning to stand still
Previous
Reply
Map
View

Click here to load this message in the networking platform