>Hi all:
>
>I have a system which was written in Visual Maxframe (about which I know virtually nothing). One of the methods calls FetchData and populates a cursor. This cursor has Table Buffering (5).
>The backend is MySql.
>
>When we move off a particular record a TABLEUPDATE(.T.,.T.) is issued (straight from VFP and not through a Maxframe call) against this cursor. As best I can tell, nothing has changed. The record count is the same, there are no deleted records.
>
>
>ab = TABLEUPDATE(.T.,.T.)
>IF NOT ab
> =AERROR(abcde)
> ?abcde[2]---> "Connectivity error: CCMD"
>ENDIF
>
>We then run a Maxframe SAVEACTION method and it generates the following
>Connectivity error: [MySQL][ODBC 3.51 Driver][mysqld-5.6.21-log]Duplicate entry '7375102' for key 'PRIMARY'
>
>I checked the cursor when it was created and the key was there.
>I tried the following
>=AFIELDS(aflds)
>FOR ifld = 1 TO ALEN(aflds,1)
>MESSAGEBOX(GETFLDSTATE(ifld))
>endfor
>
>and got a "1" (not been modified) for each field
>
>
>This is from a system which has been running successfully since 2012. The last update for the EXE was back in February. The data issues have suddenly started appearing and I don't think that we have a situation where it was happening before and nobody was reporting it.
>
>I'm pround that my hair is still mostly not grey and want to keep it that way. All help appreciated.
>
>........Rich
Why are you doing a tableupdate and then doing a maxframe saveaction?