I created a maintain procedure from synonym created from SQL table. When i am trying to update the values i get the following error (FOC03847) MntEX Compile failed for _adhoc00001 (FOC03601) ERROR AT OR NEAR LINE 1 IN 00001 (FOC03728) Segment :PERSONALINFO: is not writable. I also went and changed the master file permission (WRITE : YES)
Maintain Code :
MAINTAIN FILE personalinfo
$$Declarations
Case Top
Infer personalinfo.PERSONALINFO.NAME into AddInfo;
Winform Show Form1;
EndCase
Case AddInfo
For all include personalinfo.PERSONALINFO.NAME from AddInfo ;
Stack clear AddInfo ;
EndCase
END
This message has been edited. Last edited by: FP Mod Chuck,
Webfocus 8.1 Windows x64 Excel
December 08, 2017, 11:25 AM
FP Mod Chuck
Hi Aswin
This may be a SQL permissions error on the table for the user defined on the adapter connection.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
December 11, 2017, 07:59 AM
Maintain Wizard
Please look at your access file and make sure you have KEYS=1 or KEY=fieldname.
If you do have this, please post your master and access file.
Mark
May 08, 2018, 03:05 PM
Hawk
I am getting the same error. Below is access file. I am getting this when it loads, not when i am trying to actually add the record. Also the ID field is my key field, which I do not send a value because it is autoincremented. Does that make a difference.
Hawk It's fine that your key field is an auto-increment field. What interface are you using? What is the suffix in your Master file? We need to make sure that it is one that Maintain can use.