FiveTech Software tech support forums

... ) oRecordSet := TOleAuto():New("adodb.recordset") oComando := TOLEAUTO():New("adodb.command") oRecordSet:CursorType := 1 // opendkeyset oRecordSet:CursorLocation := 3 // local cache oRecordSet:LockType := 3 // lockoportunistic oRecordSet:ActiveConnection(oCone) oRecordSet:Source ...

... 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" ...