Hi,
I remember that some time ago I reported that by adding an attribute to a DCT column in the External Name, caused problems. The templates used the full external name that includes the attribute, which is wrong.
Attached is a screenshot of such a setup, where the "guid" column in the Organisation table has an External Name value of "guid |READONLY" to instruct the Clarion db driver not to attempt to add a new guid, but let the db do the work. It now seems as if the NetTalk code doesn't return the guid (a PK value) for a newly inserted record in the response:
{
"dbOrganisation_response": {
"ServiceResults": [
{
"RESULTACTION": "insert",
"RESULTTABLE": "Organisation",
"RESULTRECORDID": "ORG_GUID=",
"RESULTDESCRIPTION": "success"
}
]
}
}
Is there another way to get the new guid value? I know Clarion has a way by using PROP:ServerAutoInc. But this also needs additional code which the NetTalk template probably does not have. I really can't remember that it was necessary to do all of this just to get the newly insert guid back, so for now I assume it has to do with the columm attribute in the DCT.
Thanks
Thys