Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot update the cursor
Message
From
08/04/1999 11:13:45
 
 
To
08/04/1999 11:08:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00206429
Message ID:
00206441
Views:
21
>>>>Hello,
>>>>
>>>>Can anyone suggest what settings I should check to try and resolve the error I get ... "Cannot update the cursor"
>>>>
>>>>I get this when I try to Append Blank to a local table in a DBC. Outside of my app I can open the table, set buffering, and append blank to my hearts desire, so I'm convinced a setting the app is affecting this command, but I can't figure out what it is.
>>>>
>>>>Whithin the app ...
>>>>
>>>>The DBC is open,
>>>>I select the table,
>>>>I turn on table buffering
>>>>Exclusive is off
>>>>Multilocks is on
>>>>I've tried including RLOCK() and FLOCK() but I still get the error.
>>>>
>>>>Here's what my code looks like...
>>>>
>>>>IF llPasswordOk
>>>>SELECT Timer
>>>>IF NOT CURSORSETPROP("Buffering", 5, "Timer")
>>>>=MESSAGEBOX("Could not set Buffering on timer.dbf! (or EventID Not Found)",0,"Operation Status")
>>>>ELSE
>>>>APPEND BLANK
>>>>_Screen.ActiveForm.pgf1.Page1.lstEvents.DblClick(Timer.EventID, 'Add')
>>>>ENDIF
>>>>ENDIF
>>>>
>>>>
>>>>Any suggestions would be greatly appreciated.
>>>>
>>>>Thanks,
>>>>-Isaac Roda
>>>
>>>Make sure that DE.Cursor.ReadOnly=.F. for this cursor.
>>
>>The bit of code I showed calls a form class. I don't understand how to check the DE when using a form class. I can place _screen.activeform in the watch window of the debugger, but I don't see any data environment properties there.
>>What should I look for?
>>
>>-Isaac
>
>How do you open the table? If you use DataEnvironment, you may look there.
>Also (probably irrelevant) 'timer' is not the best alias (reserved word) to use for cursor.

I "OPEN DATABASE dbmTimer" then "USE Timer IN 0", then when needed I "SELECT timer"
Thanks for pointing out that timer is not a good choice for a table name. I do plan to change that.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform