error 1

[djolie]

Hello!
How can I empty a cursor inside a combobox? Next time I select the combobox items inside the same form it generates an error

SELECT cityname FROM cities,countries WHERE cities.countryid=countries.countryid AND countryname=thisform.combo5.value INTO CURSOR MyCursor READWRITE
thisform.combo6.RowSource="MyCursor"

 

[rgbean]

Before you "empty it", may sure you reset the rowsource. i.e.

thisform.combo6.RowSource=""
ZAP in myCursor
thisform.combo6.RowSource="MyCursor"

Rick

 

[djolie]

how do I check if cursor exists or is empty?

 

[Mike Lewis]

Djolie,

how do I check if cursor exists or is empty?

IF USED("MyCursor")
* Cursor exists
IF RECCOUNT("MyCursor") = 0
* Cursor is empty
ENDIF
ENDIF


Mike'

Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com