Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change between VFP 6 and 9 -- DateTime and Date
Message
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
Database:
MS SQL Server
Miscellaneous
Thread ID:
01048077
Message ID:
01048347
Views:
52
>Well, here is the end of this day long saga, at least insofar as it concerns the general community. There is not a bug in VFP, at least I don't think so. We have a goofy little routine that massages the SQL command string and is somehow messing things up. I don't know why because all it uses is basic, ancient string functions like SUBSTR() and ATC(). The guy who wrote this stuff avoided comments like the plague so it isn't even clear to me yet what the routine is trying to do. And I don't know why this suddenly cropped up under VFP 9, using the exact same code and data. Somehow the combination of one line ending with no spaces, just a linefeed, and the next line starting with no spaces, sets it off. It winds up pulling the first word in the second line out of the string.
>
>If this turns out to be due to a change in VFP behavior I will follow up with another message. Thanks again for your help.

Hi Mike,

AFAIK, a few bugs has been fixed in the string handling functions since VFP6 but it's hard to say which one could account for your situation w/o more info.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform