|
# Lines |
Nelson Nepomuceno
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 |