FiveTech Software tech support forums

... cSQL := "SELECT * from Employees order by [Employee]" oRsEmp := TOleAuto():New( "ADODB.Recordset" ) oRsEmp:CursorType := 1 // opendkeyset oRsEmp:CursorLocation := 3 // local cache oRsEmp:LockType := 3 // lockoportunistic TRY oRsEmp:Open( cSQL,xCONNECT ) CATCH oErr MsgInfo( ...

... have to change the CursorType . oRsa:= CREATEOBJECT( "ADODB.Recordset" ) oRsa:LockType := 3 // lockoportunistic oRsa:CursorType := 1 // opendkeyset oRsa:CursorLocation := 3 // local cache * Thanks, Philippe

... CATCH MsgWait( "Unable to Load SQL Driver" ) RETURN (.F.) END // Set... oSql:CursorType := 1 // opendkeyset oSql:CursorLocation := 3 // local cache oSql:LockType := 3 // lock opportunistic // Init xCONNECT := 'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial ...

... CATCH MsgAlert("It seems that your PC does not have MDAC installed OR MDAC is corrupted.") RETURN (.F.) END oSql:CursorType := 1 // opendkeyset oSql:CursorLocation := 3 // local cache oSql:LockType := 3 // lock opportunistic cSqlIns := [UPDATE sailing SET ] cSqlIns += [scheduleid='] ...

... MsgWait("It seems that your PC does not have MDAC installed OR MDAC is corrupted.") RETURN (.F.) END // Set... oSql:CursorType := 1 // opendkeyset oSql:CursorLocation := 3 // local cache oSql:LockType := 3 // lock opportunistic FOR nX1=2 TO nMax // Message... oSay:SetText( "Processing ...

... oRecordSet:ActiveConnection(oCone) oRecordSet:Source := "Select * from clientes Order by RFC" oRecordSet:CursorType := 1 // opendkeyset oRecordSet:CursorLocation := 3 // local cache oRecordSet:LockType := 3 // lockoportunistic oRecordSet:Open() oRecordSet:MoveFirst() oRecordSet:Find("RFC ...

... CATCH MsgWait( "Unable to Load SQL Driver", Ptitle ) RETURN (.F.) END // Set... oSqlLoad:CursorType := 1 // opendkeyset oSqlLoad:CursorLocation := 3 // local cache oSqlLoad:LockType := 3 // lock opportunistic // Set SQL string... cSqlLoad := "SELECT * ...

... CATCH MsgWait( "Unable to Load SQL Driver", Ptitle ) RETURN (.F.) END // Set... oSqlLoad:CursorType := 1 // opendkeyset oSqlLoad:CursorLocation := 3 // local cache oSqlLoad:LockType := 3 // lock opportunistic // Set SQL string... cSqlLoad := "SELECT * ...

Bryon How are you creating your oRs Object .. Here are the parameters I use especially a local cache and opendkeyset oRsAcc := TOleAuto():New( "ADODB.Recordset" )oRsAcc:CursorType     := 1        // opendkeysetoRsAcc:CursorLocation := 3        // local ...

... CATCH MsgWait( "Unable to load ACE AES SQL Record Set", Ptitle) RETURN (.F.) END oSqlIns:CursorType := 1 // opendkeyset oSqlIns:CursorLocation := 3 // local cache oSqlIns:LockType := 3 // lock opportunistic TRY oSqlSeek:=TOleAuto():New("ADODB.Recordset") ...

... a recordset on demand with sql statement and connection string oRsUser := TOleAuto():New( "ADODB.Recordset" ) oRsUser:CursorType := 1 // opendkeyset oRsUser:CursorLocation := 3 // local cache oRsUser:LockType := 3 // lockoportunistic TRY oRsUser:Open( cSQL, cStr ) oCn := oRsUser:ActiveConnection ...

... not have MDAC installed OR MDAC is corrupted.") RETURN (.F.) END MsgInfo( "ADODB.Recordset OK!") // Set... oSql:CursorType := 1 // opendkeyset oSql:CursorLocation := 3 // local cache oSql:LockType := 3 // lock opportunistic // Set SQL string... cSql := "SELECT * FROM SalesOrderHeader" ...

... 'Provider=MSDAORA.1;Data Source=dblocal;User ID=mulyadi;Password=1234' oRs := TOleAuto():New( "ADODB.Recordset" ) oRs:CursorType := 1 // opendkeyset oRs:CursorLocation := 3 // local cache oRs:LockType := 3 // lockoportunistic TRY oRs:Open( cSQL, cConnStr ) CATCH oErr MsgInfo( "Error ...

... MsgWait("It seems that your PC does not have MDAC installed OR MDAC is corrupted.") RETURN (.F.) END // Set... oSql:CursorType := 1 // opendkeyset oSql:CursorLocation := 3 // local cache oSql:LockType := 3 // lock opportunistic // Set SQL string... cSql := "SELECT * FROM mr" ...

Darrell I have been using ADO for many years and found when you set up your recordset object to use the opendkeyset, local cache and lockoportunistic options. Most importantly is the Local Cache option which takes your recordset and places it in local memory of the workstation. ...