Article 1199 Subject Re: Why IBToGo is readonly for Android and iOS? on embarcadero.public.delphi.database.firedac

Article

From:

Sriram Balasubramanian

📋

To:

Nelson Nepomuceno

Subject:

Re: Why IBToGo is readonly for Android and iOS?

Newsgroup:

embarcadero.public.delphi.database.firedac

18-Oct-2013

Re: Why IBToGo is readonly for Android and iOS?

Nelson,

If it was just Android platform having the problem, I would have recommended that you make sure your "Uses Permissions" is set properly to allow "Read/Write external storage", as per http://docwiki.embarcadero.com/RADStudio/XE5/en/Mobile_Tutorial:_Using_InterBase_ToGo_(iOS_and_Android)

Your destination folders for the database files are also good (for iOS and Android).

Your report indicates it is not FireDAC specific and happens with dbExpress as well.

The only other advise I have is to check your database file mode. Is it set to "read only"? InterBase allows deploying "read only" (gfix -mode read_only foo.ib) databases. Such a database will not allow "write" operations (proved by your read queries executing fine but not write operations). You can check the attributes of your database file on Windows using "gstat -h foo.ib"

I don't know if you are using any FireDAC and/or dbExpress data aware components that don't implicitly allow "write" operations.

For FireDAC:

- check if CheckReadOnly is true. http://docwiki.embarcadero.com/Libraries/XE5/en/FireDAC.Stan.Option.TFDUpdateOptions.CheckReadOnly - check if your transaction is set to ReadOnly: http://docwiki.embarcadero.com/Libraries/XE5/en/FireDAC.Stan.Option.TFDTxOptions.ReadOnly

For dbExpress:

- check if you are setting poReadOnly property to true if you using a data set provider. http://docwiki.embarcadero.com/RADStudio/XE5/en/Setting_Options_That_Influence_the_Data_Packets

Best wishes,
Sriram

> {quote:title=Nelson Nepomuceno wrote:}{quote}
> Hello,
> 
> I created a simple mobile application that access IBToGo.
> When I deploy to mobile I can query data, but I can't do any change (insert, update or delete). Application always gives a exception EIBNativeException: [FireDAC][Phys][IB] Feature is not supported.
> The problem is the same changing data via dbExpress or FireDAC; deploying default IBToGo or IBLite license file; deploying to iOS or Android; and compiling and deploying with Delphi XE4 Enterprise (full license) (only for iOS) or Delphi XE5 Enterprise (Trial) (iOS or Android).
> 
> Interbase version is XE3 installed together Delphi.
> 
> My database is deployed in iOS to path StartUp\Documents\; and in Android to path assets\internal\
> 
> What could be wrong?
> 
> Thanks in advance

FYI: Phrase searches are enclosed in either single or double quotes