Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Having problems with locate.. weird!
Message
From
30/09/2004 04:35:32
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
30/09/2004 04:23:52
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00947409
Message ID:
00947432
Views:
18
Do you have a filter on fcab?

Try this...

SELECT * FROM fcab INTO CURSOR tbgrid NOFILTER

and in the click()

SELECT fcab
GO 858
IF NOT DELETED()
[some code]
ENDIF

Don't LOCATE for recno(), because it cannot optimize. Don't add an index on recno() cause it will cause you problems when/if you buffer the table.

>hi thomas,
>
>no, record is not deleted. but i have set deleted on on my form.
>
>here, i have a grid in my form. recordsource is select * from fcab into cursor tbgrid.
>
>i have this code in my command click(),
>
>
>sele fcab
>go top
>locate for recno()=858
>if found()
>[some code]
>endif
>
>
>when i run this form, found returs to .f..
>
>i also find this out, go top does not point the record pointer to 1.
>
>when i sele tbgrid, found returns to .t.
>
>what could be wrong? pls help.
Previous
Reply
Map
View

Click here to load this message in the networking platform