Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wierd DBF name
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00407919
Message ID:
00407957
Views:
23
>I have some code that looks like this
>
>
>dStartDate={08/17/2000}
>dEndDate={08/17/2000}
>
>SELECT ach.settdate, ach.bankname, ach.portfolio, ;
> COUNT(ach.mid) AS tot_ach ;
> FROM ach ;
> WHERE BETWEEN(ach.settdate, m.dStartDate, m.dEndDate) ;
> GROUP BY ach.bankname ;
> INTO cursor achjunk2
>
> sele achjunk2
> brow
>
>When I look in BROWSE the cursor, the name of the cursor is wrong. It says BANK. This happens whenever I run cursors instead of tables. I then get this in both situations after this. I have to exit VFP and restart to get rid of it. I do have a BANK.DBF in a database where ACH.DBF lives. Ever seen this before? How do I get it to stop?
>
>Thanks in advance.

Sorry for irrelevant point, but why do you need to repeat ach, if you're selecting only from one table? I'd get rid off all this 'ach' at all. Also I would specify database name, e.g. from MyDBC!ach. You also don't need to select achjunk2 after your select statement (this cursor should be selected by default), though it's harmless. These are just thoughts, sorry for not able to help with your particular question.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform