>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