You’re offline. This is a read only version of the page.
20
Hi, i got problems, making a new custom screen, when i tried to save the data, i got the error 10262, and then the screen is closed. Could anybody help me with this.
Thanks in advance
*This post is locked for comments
I have the same question (0)
Roberto
Is your program logic such that an Insert or an Update is the first operation being performed using this cursor?
it is generally necessary for the first operation on a cursor to be a Fetch.
If an Insert/Update/Delete is the first operation, you can get an error like this.
One way to avoid the error is to do a "dummy Select" in Form Load.
Just to give an example of this, lets assume you are dealing with a table called XCustomer, which has a primary key of CustId.
In Form Load, you could do a
serr1 = SQLFetch1(TheCursor, "select * from XCustomer where CustId = 'ABC'", bTheBuffer)
It doesn't matter whether the Fetch actually finds a record.
In other words it doesn't matter if CustId 'ABC" exists.
It is just necessary that the SQLFetch be attempted.
That possible cause is the first one that has popped into mt mind.
Barry
Share
Report
All responses (
Answers (
