Hi Steven,

Where are you have TABLEUPDATE()?

MartinJ

>Why would this code:
>
>lcConnection3 = 'DRIVER=Client Access ODBC Driver (32-bit);SYSTEM='+(cSystem)+';DefaultLibraries='+(cDeaultLib)+';TRANSLATE=1;UID='+(cUID)+';PWD='+(cPWD)+';SIGNON=0;SSL=2'
>mapictest2 =SQLSTRINGCONNECT(lcConnection3)
>Select mapicstempForCertification
>
>Scan
>queryString4 = "Select * From drawmstrp Where dm_drawing_number = '" + PadR(Left(mapicstempForCertification.drawingno,10),12) + "'"
>
>queryString4b = "Select * From drawmstrp Where dm_drawing_number = '" + PadR(Left(mapicstempForCertification.drawingno,6),12) + "'"
>
>If SQLEXEC(mapictest2, queryString4, "sdequery4") <> -1 And reccount("sdequery4") > 0 Then
>=CURSORSETPROP("Tables" , "webprddt6.drawmstrp")
>=CURSORSETPROP("UpdateNameList" , "dm_drawing_number webprddt6.drawmstrp.dm_drawing_number, dm_next_assembly webprddt6.drawmstrp.dm_next_assembly, dm_files3 webprddt6.drawmstrp.dm_files3")
>=CURSORSETPROP("KeyFieldList", "dm_drawing_number")
>=CURSORSETPROP("UpdatableFieldList", "dm_next_assembly, dm_files3")
>=CURSORSETPROP("SendUpdates", .T.)
>
>Replace dm_next_assembly With mapicstempForCertification.nextassy
>=SQLCOMMIT(mapictest2)
>
>EndScan
>
>=SQLDISCONNECT(mapictest2)
>
>Generate this error?
>
>"Table buffer fot alias sdequery contains uncomitted changes" just after the first record of the scan.