Messages

1

Web Server - Ask For Help / Re: NetTalk 11.10 Disconnected App--External Name Prefix

« on: May 09, 2019, 03:48:00 AM »

Bruce,

Thanks for the explanation. I'll stay on this path then.

...jack

2

Web Server - Ask For Help / NetTalk 11.10 Disconnected App--External Name Prefix

« on: May 06, 2019, 04:56:35 AM »

I've got the latest NetTalk/JFiles as of today (2019-05-06) (C10.12799).

I'm working with an existing dictionary to make a new disconnected app. The dictionary has external names with prefixes in the dictionary (as in CUS:LastName would have an external name of cus_lastname). Server side is PostgreSQL 9.5; Disconnected Clarion App client side is SqlLite.

I've found if I drop the prefix in the external names (so instead of cus_lastname it would just be lastname) then all syncs as it should. But if I leave the cus_ prefix in for the external names then only the fields without the cus_prefix will sync (guid/ts/sts/dts sync fine--since they are new fields I left them as recommended without the cus_ prefix).

I see the json coming over from both sides correctly with the prefixes, but the server side fails to pull out the actual data from those fields, so it sends back to the client empty field data for any of the fields with the cus_ prefix in the external name.

What is the easiest way to fix this? Renaming external names for existing fields is not an option.

Edit: I've found that on the server side, I can work around the template generated code in a table's Sync Procedure by adding

jsonParameter.SetRemovePrefix(false)

right before

jsonParameter.Load(q:MyQueueName)

This overrides the jsonParameter.SetRemovePrefix(true) that precedes it. I tried unchecking the Remove Prefix for JFiles Global Extension, but that had no effect.

Not sure if this is a template bug or I'm missing a setting I should be changing somewhere.

Thanks...jack