Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select statement doesn't work after i compile and create
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00355442
Message ID:
00355673
Views:
23
>SELECT Cash.ccount, Cash.cadded, Cash.expenses, Cash.deposits;
> FROM cash;
> WHERE Cash.cdate = date();
> into array cashvar

When it comes back false, is the cash table open? IOW - is it finding the table ok? One other thought, there is an old fox quirk that I havent been bit with in VFP but perhaps worth mentioning here, and that's the occaisional need for a space before the line continuation semicolon. HTH.
Roxanne M. Seibert
Independent Consultant, VFP MCP

Code Monkey Like Fritos
Previous
Reply
Map
View

Click here to load this message in the networking platform