Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Offline database XE6 - FireDac / Interbase


This question is not answered. Helpful answers available: 1. Correct answers available: 1.


Permlink Replies: 2 - Last Post: Mar 30, 2017 5:38 PM Last Post By: John MacDonald
John MacDonald

Posts: 179
Registered: 3/22/98
Offline database XE6 - FireDac / Interbase  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Mar 29, 2017 6:19 PM
Hello Everyone:

Please let me know your thoughts?

I have a case where a user will checkout some records from an interbase database.
Do some work on the tables.
Eventually, the user will check the records back into the database.

It seems that cached updates might work. Except the changes need to persist in the mobile computer between sessions in a local database. I can think that cached updates are going to be used somehow to let me know what changes have been made to the database.

Lets start with some definitions:

Server1: is running the server version of interbase

Mobile 1: Uses the client to connect to Server 1, and copies the appropriate records to the database on Mobile 1.
The database on mobile 1 is set to use dblite but will eventually use dbtogo to keep local changed records
When Mobile 1 is reconnected to Server 1 I would like to send only the modified records to Server 1.

As much as I think this might be called the briefcase model, cached updates seem to be useful in this case.

Do we tag the changed records?
Are they already tagged using something like cached updates?

I would like to get this completed over the next day or so. Please feel free to make any comment.

John

--
JMAC out
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Offline database XE6 - FireDac / Interbase
Helpful
Click to report abuse...   Click to reply to this thread Reply
  Posted: Mar 29, 2017 8:42 PM   in response to: John MacDonald in response to: John MacDonald
John MacDonald wrote:
Hello Everyone:

Please let me know your thoughts?

I have a case where a user will checkout some records from an interbase database.
Do some work on the tables.
Eventually, the user will check the records back into the database.

It seems that cached updates might work. Except the changes need to persist in the mobile computer between sessions in a local database. I can think that cached updates are going to be used somehow to let me know what changes have been made to the database.

Lets start with some definitions:

Server1: is running the server version of interbase

Mobile 1: Uses the client to connect to Server 1, and copies the appropriate records to the database on Mobile 1.
The database on mobile 1 is set to use dblite but will eventually use dbtogo to keep local changed records
When Mobile 1 is reconnected to Server 1 I would like to send only the modified records to Server 1.

As much as I think this might be called the briefcase model, cached updates seem to be useful in this case.

Do we tag the changed records?
Are they already tagged using something like cached updates?

I would like to get this completed over the next day or so. Please feel free to make any comment.

John

--
JMAC out

You can use the free lcoal embedded IB for your briefcase and look at InterBase
subscriptions for how to maintain the differences etc to update.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
John MacDonald

Posts: 179
Registered: 3/22/98
Re: Offline database XE6 - FireDac / Interbase  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Mar 30, 2017 5:38 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Thanks Jeff:

I am still using Rad Studio XE6 and Interbase XE3

Someday, but not yet, I will be able to move to the more recent platforms.

Talk to you soon.

John

Jeff Overcash (TeamB) wrote:
John MacDonald wrote:
Hello Everyone:

Please let me know your thoughts?

I have a case where a user will checkout some records from an interbase database.
Do some work on the tables.
Eventually, the user will check the records back into the database.

It seems that cached updates might work. Except the changes need to persist in the mobile computer between sessions in a local database. I can think that cached updates are going to be used somehow to let me know what changes have been made to the database.

Lets start with some definitions:

Server1: is running the server version of interbase

Mobile 1: Uses the client to connect to Server 1, and copies the appropriate records to the database on Mobile 1.
The database on mobile 1 is set to use dblite but will eventually use dbtogo to keep local changed records
When Mobile 1 is reconnected to Server 1 I would like to send only the modified records to Server 1.

As much as I think this might be called the briefcase model, cached updates seem to be useful in this case.

Do we tag the changed records?
Are they already tagged using something like cached updates?

I would like to get this completed over the next day or so. Please feel free to make any comment.

John

--
JMAC out

You can use the free lcoal embedded IB for your briefcase and look at InterBase
subscriptions for how to maintain the differences etc to update.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

--
JMAC out
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02