Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Truncated field in cursor
Message
From
18/01/2012 12:20:14
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01533215
Message ID:
01533216
Views:
31
Not an answer to your question, but comparing a value against .F. is "overkill". This is better, and more readable after you get used to it:
IIF(no_reinst,"True", "False") as no_reinst, ;
IIF(no_chks,"True", "False") as no_chks, ;
IIF(no_eft,"True", "False") as no_eft, ;
IIF(web_msr,"True", "False") as web_msr, ;
>I have a select statement gathering fields into a cursor which is then copied to a delimited text file. Has worked fine until last night.
>
>It is selecting several logical fields (among others) like this:
>
>
>IIF(no_reinst=.F., "False", "True") as no_reinst, ;
>IIF(no_chks=.F., "False", "True") as no_chks, ;
>IIF(no_eft=.F., "False", "True") as no_eft, ;
>IIF(web_msr=.F., "False", "True") as web_msr, ;
>
>
>The line selecting the web_msr field is truncating and inserting "Fals" as the value when .F. This is not happening on the selection of the other logical fields. Any idea what might cause this?
>
>Thanks,
>KP
Previous
Reply
Map
View

Click here to load this message in the networking platform