General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only