General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only