>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