General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Fatal Exception Error with Requery()
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
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