Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement