HI All,

I have a parameterized view which I've been using for 2 years without incident. It's called LIVIEW. I just created a new form, and now, when it hits a requery(), I get a fatal exception error. Here's the code snippet:

lnInvNum=lnInvKey &&lnInvNum is the view parameter, lnInvKey is an INT.
sele invoices
set order to ikey
if seek(lnInvNum)
if used("liview")
sele liview
requery()
else
sele 0
use liview
endif
endif

According to the error message, it's the requery() that's killing it. I'm baffled.

A couple other pieces of info - I'm first using the LIVIEW in the load method, where lnInvNum=0, purposely yielding no records.

I also have a grid which is bound to LIVIEW, and also uses fields from a table I have related to LIVIEW (could that be it - requerying with an active relation? I'll have to test it).

I'm using SP3.

Any thoughts would be appreciated. I'm sure I can find a way around it, but I'd like to understand why it's happening.

Thanks,

David