When making a change to a certain table i get 'RECORD was not located
to update' when i try to post the change...
this is the output from the monitor..

PREPARE STATEMENT
TR_HANDLE = 18881996
STMT_HANDLE = 18881788

UPDATE PENMAST
SET PCONT = ? /* PCONT */
, CON_DATE = ? /* CON_DATE */
, PSSS = ? /* PSSS */
, TX_DATE = ? /* TX_DATE */
, PCODE = ? /* PCODE */
, PTRAN_SEQ = ? /* PTRAN_SEQ */
, PHOURS = ? /* PHOURS */
, PEN_RATE = ? /* PEN_RATE */
, T_PENSION_PCT = ? /* T_PENSION_PCT */
, GROSS_WAGES = ? /* GROSS_WAGES */
, VTYPE = ? /* VTYPE */
, IDATE1 = ? /* IDATE1 */
, IDATE2 = ? /* IDATE2 */
, PREC_ID = ? /* PREC_ID */
, F1PER = ? /* F1PER */
, F2PER = ? /* F2PER */
, F3PER = ? /* F3PER */
, F4PER = ? /* F4PER */
, F5PER = ? /* F5PER */
, F6PER = ? /* F6PER */
, F7PER = ? /* F7PER */
, F8PER = ? /* F8PER */
, F9PER = ? /* F9PER */
, F10PER = ? /* F10PER */
, F1DOL = ? /* F1DOL */
, F2DOL = ? /* F2DOL */
, F3DOL = ? /* F3DOL */
, F4DOL = ? /* F4DOL */
, F5DOL = ? /* F5DOL */
, F6DOL = ? /* F6DOL */
, F7DOL = ? /* F7DOL */
, F8DOL = ? /* F8DOL */
, F9DOL = ? /* F9DOL */
, F10DOL = ? /* F10DOL */
, UNALLDOL1 = ? /* UNALLDOL1 */
, UNALLPER = ? /* UNALLPER */
, ALLOCSW1 = ? /* ALLOCSW1 */
, ALLOCSW2 = ? /* ALLOCSW2 */
WHERE PENMAST.PSSS = ? /* OLD_PSSS */
AND PENMAST.TX_DATE = ? /* OLD_TX_DATE */
AND PENMAST.PCODE = ? /* OLD_PCODE */
AND PENMAST.PTRAN_SEQ = ? /* OLD_PTRAN_SEQ */

PLAN (PENMAST INDEX (RDB$PRIMARY1))

FIELDS = [ Version 1 SQLd 0 SQLn 0 ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 18881996
STMT_HANDLE = 18881788
PARAMS = [ Version 1 SQLd 42 SQLn 42
PENMAST.PCONT = 'SUMNER'
PENMAST.CON_DATE = '01 Dec 1999'
PENMAST.PSSS = '572864220'
PENMAST.TX_DATE = '03 Feb 2000'
PENMAST.PCODE = 1
PENMAST.PTRAN_SEQ = 198864
PENMAST.PHOURS = 159
PENMAST.PEN_RATE = 1.29
PENMAST.T_PENSION_PCT = 0
PENMAST.GROSS_WAGES = 2576
PENMAST.VTYPE = ' '
PENMAST.IDATE1 = 0
PENMAST.IDATE2 = 0
PENMAST.PREC_ID = <NULL>
PENMAST.F1PER = <NULL>
PENMAST.F2PER = <NULL>
PENMAST.F3PER = <NULL>
PENMAST.F4PER = <NULL>
PENMAST.F5PER = <NULL>
PENMAST.F6PER = <NULL>
PENMAST.F7PER = <NULL>
PENMAST.F8PER = <NULL>
PENMAST.F9PER = <NULL>
PENMAST.F10PER = <NULL>
PENMAST.F1DOL = <NULL>
PENMAST.F2DOL = <NULL>
PENMAST.F3DOL = <NULL>
PENMAST.F4DOL = <NULL>
PENMAST.F5DOL = <NULL>
PENMAST.F6DOL = <NULL>
PENMAST.F7DOL = <NULL>
PENMAST.F8DOL = <NULL>
PENMAST.F9DOL = <NULL>
PENMAST.F10DOL = <NULL>
PENMAST.UNALLDOL1 = <NULL>
PENMAST.UNALLPER = <NULL>
PENMAST.ALLOCSW1 = <NULL>
PENMAST.ALLOCSW2 = <NULL>
PENMAST.PSSS = '572864220'
PENMAST.TX_DATE = '03 Feb 2000'
PENMAST.PCODE = 1
PENMAST.PTRAN_SEQ = 198864 ]
----*/

the record does exist...
note this table is the detail table of a master keyed by ss#

thanks
ed croxford
Auto Europe LLC