cursor with no records doesn't exist?

[BlackDice]

It used to be that if I selected fields into a cursor and there were no records returned, I still had a cursor with a reccount() of 0. I re-did my machine and re-installed foxpro (version 7 in both cases). now when I SELECT INTO CURSOR, and there are no records returned, used("mycursor") returns .f. . also a listbox that is using a cursor throws a 'cannot access the selected table' error and disappears from the form if there are no more records in the cursor when the screen refreshes:

I have a form with 2 listboxes populated by 2 different cursors. A button is used to put everything from one cursor into the other one. If I empty out the first one, then call another form, when I come back I get the above-mentioned error for the first listbox that's now empty and the cursor that populated that listbox no longer exists. I never had this problem before I re-installed so I'm wondering is there something in my settings that's different, and if so, what can I do to fix it?

Thanks in advance for any help!

BlackDice

http://www.stillwaterexpress.com

 

[Stella740pl]

I'm not familiar with this behavior (I use VFP6); empty cursor is always created by SELECT statement (not so for an array).

However, to circumvent this, I would first check _TALLY right after the SELECT, and if it is =0, I would not try to access the cursor in question. Just put whatever you have to do with it in IF _TALLY#0 ... ENDIF.

 

[BlackDice]

that's fine for just the cursor, but it does nothing for the listbox. however, I just tried it again and now it's working - AND I HAVEN'T CHANGED ANYTHING! I hate foxpro

BlackDice

http://www.stillwaterexpress.com

 

[mspratt]

I hate foxpro

Hold on now, the proper term is "I hate computers".

Regards,

Mike

 

[BlackDice]

no. I hate foxpro. I love computers. Out of every language I've written programs in (C++, VB6, VBA,PHP) and the ones I've just tried out (javascript,java,delphi), foxpro has to be the worst I've ever dealt with. The IDE, the syntax, the 'one time it does this, one time it does that' feeling, etc.

BlackDice

http://www.stillwaterexpress.com

 

[Mike Gagnon]

Try this:

CREATE CURSOR mycursor (name c(1))
USE DBF("MYCURSOR") SHARED AGAIN IN 0
browse

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[mspratt]

Well, everyone has their own opinion. Administering a small network, programming, etc. I dont seem to get any more grief from VFP than anything else. So I will stick with "I hate computers", even though they pay the bills.

Regards,

Mike

 

[BlackDice]

okay, mspratt. maybe it's just me. a friend of mine swears by VFP, so as you said, everyone has their own opinion

BlackDice

http://www.stillwaterexpress.com