Rank: Advanced Member
Groups: Registered
Joined: 5/23/2016(UTC) Posts: 129 Location: Virginia Thanks: 20 times
|
I have forms that are completed by each client device the results are added to the database. I want to store the database on the client device so that the original database is left clean on the server for the next client to use. I have set the database page sources to "client only" but when testing I get the cannot execute on client error. I try setting them to persist on client and then the solution runs but stores the data on the database on the server. I am not saving the data until I return to the main menu after completing the solutions. and I have the control actions set as in the attached image for each database. What a I doing wrong? Thanks, jwatt222 attached the following image(s):
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Joined: 7/21/2014(UTC) Posts: 498
Was thanked: 88 time(s) in 88 post(s)
|
You cannot store a database on a client device, because client devices do not run databases.
But you can save data in XML trees instead and either save and load them explicitly on client device or use the persistent flag for implicit saving.
By the way, if the amount of data is not too big (and form data is usually very small), XML trees are much quicker and more efficient in handling such data.
|
1 user thanked bbv for this useful post.
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 5/23/2016(UTC) Posts: 129 Location: Virginia Thanks: 20 times
|
I removed the saves to the databases since they were what was obviously saving it to the database on the server. I set the databases to persist on client. I ran another test and this time the information did not save to my server but after waiting a while I went back in and found that all of of the data is still on the forms. This is good for one of my forms because once it is filled out, I want it to hold the information for the next run. I assume that this is what persist on client does.
Question, is there a certain period of time before i can go back in to find the other forms clear or do I need to remove persist on client from the forms that I want to be clear for the next run? and if I do this, would there be a way to recall that information if I wanted to view an old run?
Thanks,
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Joined: 7/21/2014(UTC) Posts: 498
Was thanked: 88 time(s) in 88 post(s)
|
Everything is completely up to you - you have all commands available to load, save, reset, etc.
|
1 user thanked bbv for this useful post.
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.