Upgrade Database schema of ultralite in iOS

[Former Member]

Hi,

I am trying upgrade schema of ultralite using sql script file in iOS. I am using the below statement to upgrade schema

"ALTER DATABASE SCHEMA FROM FILE".

I was able to upgrade ultralite successfully till iOS 8.1.1. But execution of the above statement is getting failed in iOS 8.2.

ExecuteStatement return bool value whether success/failure. So,I was unable to get the root cause or error.

Please help me to solve this issue.

Thanks,

Suman

[chris_keating · Accepted solution]

You can use the ULConnection::GetLastError() to access the error details.

if( ps->ExecuteStatement() ) {

   const ULError * error = ulconn->GetLastError()

   // get info from the error object to help determine the problem

}

The error object will show the SQLCODE and error parms in the debugger or you can implement a more detail error handler using the information accessible from this object.

If you have question about the error , please post the error details.

[Former Member · Accepted solution]

Thanks Chris,

I got the error. While upgrading schema, there is an other query that was being executed in background. We stopped fetching while upgrading the schema. The issue got fixed.

I don't know the reason why it is crashing in iOS 8.2 but not in earlier versions. Please share your thoughts.

Thanks,

Suman Kumar

[former_member207653]

Hi Suman,

iOS 8.2 was released a few days ago.

Which are your SQL Anywhere version and build numbers?

You can download updates from SAP Support Portal.

Thank you,

Mirco