Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Max Length on character variable 255?!?!
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Max Length on character variable 255?!?!
Miscellaneous
Thread ID:
00291648
Message ID:
00291648
Views:
66
This is quite weird. I'm trying to store a SELECT statement to variable, and VFP 6 SP3 complains with "Command contains unrecognizable phrase/keyword" as soon as the length of my character string hits 256. I Tried the following on an NT4 SP4 and an NT4 SP5 workstation with the same result:
lcSQL = "SELECT Lv_rates_summary_schedc.audit_id, Lv_rates_summary_schedc.total AS admin_total, 0000000000000000 AS rescare_total, 0000000000000000 AS otherres_total, 0000000000000000 AS retax_total FROM nis!lv_rates_summary_schedc WHERE UPPER(Lv_rates_summary_sche"
This gives us the error message. Yet take the last character off the end("e") and it takes it just fine. Hackers Guide shed no light for me here, what am I doing wrong or is this a real live VFP glitch?
Roxanne M. Seibert
Independent Consultant, VFP MCP

Code Monkey Like Fritos
Next
Reply
Map
View

Click here to load this message in the networking platform