Conversation

Why IBToGo is readonly for Android and iOS?

(overview of excerpts from articles in conversation)

Newsgroup: embarcadero.public.delphi.database.firedac

# Lines
wrote on 17-Oct-2013:

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.
30
  
Sriram Balasubramanian replied on 18-Oct-2013:

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"
93
    
Nelson Nepomuceno replied on 19-Oct-2013:

Hi Sriram, thank you for answering promptly.
    I think my database is not read only. Because I can change it from my windows application and from my admin tool.
    Command gstat -h mydatabase.ib returns:
    Database header page information:
    Flags 0
207
      
Nelson Nepomuceno replied on 23-Oct-2013:

Hello,
      I uninstalled Rad Studio XE5, it was trial, and reinstalled Rad Studio XE4, which is registered. And installed InterBase XE3 registered.
      Now I can deploy IBToGo and do all sorts of changes in the database.
      Apparently, I was with InterBase XE3 Trial, installed with Rad Studio XE5, and perhaps Interbase Trial does not allow changes to the database. I don't know if that's it. Unfortunately, I didn't find any notice in the documentation about this and it spend a lot of time.
      Thanks
238
        
quinn wildman replied on 23-Oct-2013:

Nelson Nepomuceno wrote:
        (snip)
Nope, that's not it.
        
        
        
9
  
Dmitry Arefiev replied on 20-Oct-2013:

(snip)

Does the exception happen on any INSERT / UPDATE /
  DELETE SQL command ?
  If yes, then please do the following:
  - create simple test application
  - execute trivial INSERT / UPDATE / DELETE SQL command
25
    
Nelson Nepomuceno replied on 24-Oct-2013:

Hi, Mr. Dmitry.
    I made a trivial sql example with insert, update and delete commands and works fine. But now everything works and I can't reproduce errors again. So, I don't know what happened.
    The only change that I remember doing was the uninstallation Rad Studio XE5 (trial), repairing instalation Rad Studio Enterprise XE4 (registered) and installed InterBase XE3 (registered).
    I did not change connection settings, components, commands, methods, structure database, recording location, drivers, permissions, nothing.
    Now it is ok. It's working fine.
51
      
Dmitry Arefiev replied on 24-Oct-2013:

Thank you for feedback and your testing effort.
      I contacted InterBase R&D. Probably they will
      be able to explain this issue.
      --
      With best regards,
13
        
Sriram Balasubramanian replied on 24-Oct-2013:

Dmitry,
        I did reply earlier with what I thought could help the situation. There is nothing else in Nelson's report that provide any clues of what the problem might have been (whether in InterBase, RAD or otherwise).
        Best wishes,
        Sriram
        Engineering Team Lead, InterBase
27
          
Dmitry Arefiev replied on 25-Oct-2013:

Thank you, Sriram.
          --
          With best regards,
          Dmitry Arefiev / FireDAC Architect
          FireDAC - Firebird, SQLite, MySQL, SQL Server, Oracle, PostgreSQL,
8
FYI: Phrase searches are enclosed in either single or double quotes
 
 
Originally created by
Tamarack Associates
Fri, 22 Nov 2024 10:05:13 UTC
Copyright © 2009-2024
HREF Tools Corp.