I was getting the error with Insert earlier.

At any rate, I deleted the table and rebuilt it, and it seems ok now.




>Use Insert instead, it's usually easier, faster and better

>Insert into SCUsers (RecordID) values (iRecordID)

>
>>I have a table called SCUsers with the folliwng structure:
>>
>>

>>RecordId int
>>Data1    memo
>>Data3    memo
>>Data3    memo
>>

>>
>>When I run the following, I get 'Data Type Mismatch' on both the APPEND BLANK and the REPLACE lines:
>>
>>

>>SELECT SCUsers
>>APPEND BLANK
>>REPLACE IN scUsers RecordId WITH iRecordId NEXT 1
>>

>>
>>
>>The value id iRecordId is Numeric.
>>
>>Anyone wanna take a stab at this?