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:
00407959
Views:
14
>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.

Also, check _tally after your select statement. It could be, that your SQL produces 0 records.
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