Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel and vfp variable bug?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00931459
Message ID:
00931460
Views:
21
Steve,

The string comparison in VFP is controlled by SET EXACT settings (SET ANSI in SQL commands). The both commnads are scoped to the current data session. See help for details.

>I have an instance when two variables in VFP return the the right answer when the program is
>run from FoxPro but the wrong answer when I build the exe and run it that way.
>
>Here's how this works.
>mSym = sym && from a table
>mCell = .Value && from a cell in Excel
>
>&& these values happen to be as follow -- mCell = "!indu88888"
>&& and this one is ---------------------- mSym = "!indu"
>
>however, in the program ? mCell = mSym is .f.
>in the exe the answer is true
>
>However, if I create a table with two fields
>create table mcomp (mfirstc(20), msecond c(20))
>then put mSym in mfirst and mCell in mSecond
>
>Now ask the exe and the prg to compare, and both get the correct answer
>STeve
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform