Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
REQUERY() causes errors when everything appears ok.
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00161965
Message ID:
00161978
Views:
26
>The following are 3 main errors and the code, which cause each error. I received when MMF loading & refreshing views.
>
>* This has caused many errors: Fatal error
>IF IIF(goApp.lCDBK30, this.oBizObj.Requery() = REQUERY_SUCCESS, ;
> this.oBizObj.Requery(tlDoNotRequeryChildren) = REQUERY_SUCCESS)
> lnRetVal = IIF(RECCOUNT() > 1, FILE_BOF, ;
> IIF(RECCOUNT() = 0, FILE_NORECORDS, FILE_ONERECORD))
>

Should it be: REQUERY_SUCCESS = This.oBizObj.Requery() ?

Maybe not, I guess REQUERY_SUCCESS is a defined constant.

I think you should simplify what you are trying to do by using more lines of code.

lnSuccess1 = This.oBizObj.Requery()
lnSuccess2 = this.oBizObj.Requery(tlDoNotRequeryChildren)

etc...

On Requery() functions, is the view being requeried the currently selected workarea? Don't quite understand what the 2 lines after the 'Type mismatch' line have to do with the error.

>
>* This has caused many errors: "lnRetVal = REQUERY()", 'Type mismatch'
> this.parentclass = Cdatabehavior
> this.class = Ctablebehavior
> --------------------------------------------------
> LOCAL lnRetVal
> lnRetVal = FILE_CANCEL
> IF CURSORGETPROP("SOURCETYPE") <> DB_SRCTABLE
> * lnRetVal was -3 @ this point...
> lnRetVal = REQUERY()
> ENDIF
> RETURN lnRetVal
>
>
>* This has caused many errors: 'Object not found'
> lnRetVal = this.oBehavior.Requery() && Requery the view.
>
>I would appreciate any suggestions.
>
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform