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,

Hi Aswin

This may be a SQL permissions error on the table for the user defined on the adapter connection.

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

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.


SEGNAME=TBL_EXPECTED_SAVINGS_SUMMARY,
TABLENAME=dbo.TBL_Expected_Savings_Summary,
CONNECTION=EANDI,
KEY=ID, $
FIELD=ID,
AUTOINCREMENT=YES,
START=1,
INCREMENT=1, $
INDEX_NAME=PK__TBL_Expe__3213E83F14E539D0,
INDEX_UNIQUE=Y,
INDEX_COLUMN=id,
INDEX_ORDER=ASC, $
DV_TEMPLATE=START_DATE_YQMD,
BASE=START_DATE,
DV_CAPTION='Start Date,Simple',
COMPONENTS=START_DATE_YEAR/START_DATE_QUARTER/START_DATE_MONTH/START_DATE_DAY, $
DV_TEMPLATE=START_DATE_Y_YQMD,
BASE=START_DATE,
DV_CAPTION='Start Date,Compound',
COMPONENTS=START_DATE_YEAR_Y/START_DATE_YEAR_Q/START_DATE_YEAR_M/START_DATE_YEAR_D, $
DV_TEMPLATE=END_DATE_YQMD,
BASE=END_DATE,
DV_CAPTION='End Date,Simple',
COMPONENTS=END_DATE_YEAR/END_DATE_QUARTER/END_DATE_MONTH/END_DATE_DAY, $
DV_TEMPLATE=END_DATE_Y_YQMD,
BASE=END_DATE,
DV_CAPTION='End Date,Compound',
COMPONENTS=END_DATE_YEAR_Y/END_DATE_YEAR_Q/END_DATE_YEAR_M/END_DATE_YEAR_D, $
DV_TEMPLATE=DATE_YQMD,
BASE=DATE,
DV_CAPTION='DATE,Simple',
COMPONENTS=DATE_YEAR/DATE_QUARTER/DATE_MONTH/DATE_DAY, $
DV_TEMPLATE=DATE_Y_YQMD,
BASE=DATE,
DV_CAPTION='DATE,Compound',
COMPONENTS=DATE_YEAR_Y/DATE_YEAR_Q/DATE_YEAR_M/DATE_YEAR_D, $
DV_TEMPLATE=LASTUPDATEDATE_YQMD,
BASE=LASTUPDATEDATE,
DV_CAPTION='LASTUPDATEDATE,Simple',
COMPONENTS=LASTUPDATEDATE_YEAR/LASTUPDATEDATE_QUARTER/LASTUPDATEDATE_MONTH/LASTUPDATEDATE_DAY, $
DV_TEMPLATE=LASTUPDATEDATE_Y_YQMD,
BASE=LASTUPDATEDATE,
DV_CAPTION='LASTUPDATEDATE,Compound',
COMPONENTS=LASTUPDATEDATE_YEAR_Y/LASTUPDATEDATE_YEAR_Q/LASTUPDATEDATE_YEAR_M/LASTUPDATEDATE_YEAR_D, $

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.

Mark