This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
1
Web Server - Ask For Help / Dictionary modification erases all records if GUID present
« on: April 28, 2017, 07:45:18 AM »
If I modify a table in the Disconnected Desktop demo app by altering a key to "unique" or adding a field and then attempt to upgrade the file structure using the "browse file" in the dictionary editor all records are erased.
I have replicated this on other Disconnected Desktop dictionaries on two installations of Clarion 10 12463 (NT9.25 and 9.26)
If I do this on non-Disconnected Desktop dictionaries it works as expected.
What am I forgetting to do?
Dermot
I have replicated this on other Disconnected Desktop dictionaries on two installations of Clarion 10 12463 (NT9.25 and 9.26)
If I do this on non-Disconnected Desktop dictionaries it works as expected.
What am I forgetting to do?
Dermot
2
Web Server - Ask For Help / NetTalk upgrade 9.17 not updating the server files on sync
« on: January 23, 2017, 06:58:48 AM »
Hi
Just installed 9.17 on C10 build 12349 on a 64-bit machine.
In the basic Disconnected Desktop and Server Example app if I run both ends:
If I make a change on the Desktop and do 'sync' all the stuff shows in the server window but the server files do not show the changes
If I go back to 9.16 the same app works reliably.
Dermot
Just installed 9.17 on C10 build 12349 on a 64-bit machine.
In the basic Disconnected Desktop and Server Example app if I run both ends:
If I make a change on the Desktop and do 'sync' all the stuff shows in the server window but the server files do not show the changes
If I go back to 9.16 the same app works reliably.
Dermot
3
Web Server - Ask For Help / Re: Disconnected Apps - Purge Records.
« on: January 16, 2017, 02:20:05 PM »
Thanks Bruce.
Yes - it is TPS and yes PACK does get rid of empty space in a TPS file. (Being compressed records in a TPS, the length of a record is not fixed so deletion has to leave a hole and the file gets 'defragmented' and needs sorting out.)
I get from your comments that the deletions aren't that important, provided you filter them out from any browse or form. In the end of course you have to clean up, but that can be left for a while (min 1 week?) so you can be certain that the sync process has happened.
And BOTH ends have to delete or the deleted records get replaced by the sync!
Dermot
Yes - it is TPS and yes PACK does get rid of empty space in a TPS file. (Being compressed records in a TPS, the length of a record is not fixed so deletion has to leave a hole and the file gets 'defragmented' and needs sorting out.)
I get from your comments that the deletions aren't that important, provided you filter them out from any browse or form. In the end of course you have to clean up, but that can be left for a while (min 1 week?) so you can be certain that the sync process has happened.
And BOTH ends have to delete or the deleted records get replaced by the sync!
Dermot
4
Web Server - Ask For Help / Disconnected Apps - Purge Records.
« on: December 29, 2016, 01:51:42 PM »
In Bruces video (339) and in a post to the Clarion10 NG(dd 5/1/16) re SQL Bruce speaks of purging records marked as deleted. In the latter he says, "...both sides can purge deleted records. (I'm assuming edits can happen on both sides here.)"
The principle that purging can only occur "…..once the (deleted) mark has propagated" is clear. It is the method that escapes me.
In the Disconnected app the 'server' does not necessarily have an edit function, so the SQL example would (logically) not apply.
Presuming that the server controls the 'master records' it would seem that the purging would be effected from there. Try as I might I have not succeeded. Please can you advise how this might be achieved?
(As I read the manual, a record's DeletedTimeStamp is the only thing that marks that record as deleted. This implies that both the server and each desktop app periodically have to run through the entire database looking for anywhere the DeletedTimeStamp is set and using Access:<file>.DeleteRecord to really delete the record, finishing off with a PACK. Is there a more elegant way to do this? )
Thanks
The principle that purging can only occur "…..once the (deleted) mark has propagated" is clear. It is the method that escapes me.
In the Disconnected app the 'server' does not necessarily have an edit function, so the SQL example would (logically) not apply.
Presuming that the server controls the 'master records' it would seem that the purging would be effected from there. Try as I might I have not succeeded. Please can you advise how this might be achieved?
(As I read the manual, a record's DeletedTimeStamp is the only thing that marks that record as deleted. This implies that both the server and each desktop app periodically have to run through the entire database looking for anywhere the DeletedTimeStamp is set and using Access:<file>.DeleteRecord to really delete the record, finishing off with a PACK. Is there a more elegant way to do this? )
Thanks
5
Web Server - Ask For Help / Disconnected NetTalk apps - change of a file structure
« on: December 14, 2016, 07:06:54 AM »
I've searched the newsgroups and NetTalk central and the documentation but I must be using the wrong keywords.
If I make a change to a file structure on the server data, how does NetTalk9 upgrade the local file structure?
Or do I have to do this "by hand" using FM3 on the desktop data?
And, is there an easy way to copy the new desktop program to all my remote users in the same way as AutoNet used to do?
Dermot
If I make a change to a file structure on the server data, how does NetTalk9 upgrade the local file structure?
Or do I have to do this "by hand" using FM3 on the desktop data?
And, is there an easy way to copy the new desktop program to all my remote users in the same way as AutoNet used to do?
Dermot
Pages: [1]