Search found 116 matches: locktype

Return to advanced search

connecting SQL SERVER VIA ODBC PROLEM

... oApp:cAplicacion) ShowError(oError) orsPed := NIL lret:=.f. CLOSE_DBF(ODTEMP) RETURN(lret) END orsPed:CursorLocation := adUseClient orsPed:LockType := adLockOptimistic orsPed:CursorType := adOpenDynamic orsped:source:="SELECT * FROM ERP6_base" // ENVIAMOS QUERY DE PRUEBA PARA ...
by MANOLO
Mon Jan 29, 2024 5:18 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: connecting SQL SERVER VIA ODBC PROLEM
Replies: 0
Views: 307

Re: CONEXION ADODB SQL SERVER

... oApp:cAplicacion) ShowError(oError) orsPed := NIL lret:=.f. CLOSE_DBF(ODTEMP) RETURN(lret) END orsPed:CursorLocation := adUseClient orsPed:LockType := adLockOptimistic orsPed:CursorType := adOpenDynamic orsPed:Source :="select * from BasedeDatos" orsPed:ActiveConnection( oApp:oCon ...
by MANOLO
Mon Jan 29, 2024 5:09 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: CONEXION ADODB SQL SERVER
Replies: 4
Views: 249

CONEXION ADODB SQL SERVER

... oApp:cAplicacion) ShowError(oError) orsPed := NIL lret:=.f. CLOSE_DBF(ODTEMP) RETURN(lret) END orsPed:CursorLocation := adUseClient orsPed:LockType := adLockOptimistic orsPed:CursorType := adOpenDynamic orsped:source:="SELECT * FROM ERP6_base" // ENVIAMOS QUERY DE PRUEBA PARA ...
by MANOLO
Mon Jan 29, 2024 9:12 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: CONEXION ADODB SQL SERVER
Replies: 4
Views: 249

CONEXION ADODB SQL SERVER

... oApp:cAplicacion) ShowError(oError) orsPed := NIL lret:=.f. CLOSE_DBF(ODTEMP) RETURN(lret) END orsPed:CursorLocation := adUseClient orsPed:LockType := adLockOptimistic orsPed:CursorType := adOpenDynamic orsped:source:="SELECT * FROM ERP6_base" // ENVIAMOS QUERY DE PRUEBA PARA ...
by MANOLO
Mon Jan 29, 2024 9:12 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: CONEXION ADODB SQL SERVER
Replies: 0
Views: 135

Error ADODB.Recordset/6 DISP_E_UNKNOWNNAME: ISKINDOF

... 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( "Error in Opening EMPLOYEES table" ) RETURN(.F.) END ...
by Rick Lipkin
Wed Mar 01, 2023 10:10 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Error ADODB.Recordset/6 DISP_E_UNKNOWNNAME: ISKINDOF
Replies: 1
Views: 161

MSSQL and XBROWSE

... refresh) How is it possible with RecordSet ? I think i have to change the CursorType . oRsa:= CREATEOBJECT( "ADODB.Recordset" ) oRsa:LockType := 3 // lockoportunistic oRsa:CursorType := 1 // opendkeyset oRsa:CursorLocation := 3 // local cache * Thanks, Philippe
by Jack
Wed Nov 03, 2021 3:38 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: MSSQL and XBROWSE
Replies: 1
Views: 334

ADO: ACTUALIZAR CAMPO DE SELECT DE 02 TABLAS MSSQL

... := TOleAuto():New( "ADODB.RecordSet" ) WITH OBJECT oRsDir :ActiveConnection := oApp:oCon :Source := cSql :CursorLocation := adUseClient :LockType := adLockOptimistic :CursorType := adOpenDynamic TRY :Open() CATCH FW_ShowAdoError( oApp:oCon ) END END oRsDir:Properties("Unique Table"):Value ...
by Angel Miguel
Sun Apr 19, 2020 5:59 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: ADO: ACTUALIZAR CAMPO DE SELECT DE 02 TABLAS MSSQL
Replies: 5
Views: 855

Re: xBrowse jpg in SQL-database

... 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 Catalog='+xDATABASE+';User Id='+xUSERID+';Password='+xPASSWORD ...
by cdmmaui
Fri Nov 08, 2019 1:14 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse jpg in SQL-database
Replies: 19
Views: 2939

SQL Update Response

... 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='] + ALLTRIM( cScheduleId ) + [',] cSqlIns += [carrier='] ...
by cdmmaui
Sat Aug 03, 2019 8:06 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: SQL Update Response
Replies: 10
Views: 1770

Re: Insertar registros en un Dbf desde tabla MSAccess

... ) CATCH oError MsgStop( "No se ha podido crear el OBJETO"+ oError:Description ) RETURN .F. END oRSet:CursorLocation:=adUseClient;oRSet:LockType:=adLockReadOnly;oRSet:CursorType:=adOpenForwardOnly;oRSet:ActiveConnection( oConnection ) sSQLQuery := "SELECT * FROM CONSULMARKET" ...
by RBLANCO
Tue Apr 16, 2019 11:53 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Insertar registros en un Dbf desde tabla MSAccess
Replies: 3
Views: 752

Re: Import Chinese Characters from XLS

... 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 XLS Row " + LTRIM(TRANSF( nX1, "999,999" ...
by cdmmaui
Thu Feb 21, 2019 4:58 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Import Chinese Characters from XLS
Replies: 4
Views: 943

Re: Error from ADO

... adUseNone (Obsolete and does not work) 2. adUseServer (Can not navigate and is not useful for us) 3. adUseClient : This is the only choice we have LockType: 1. adLockUnspecified (not to be used for new recordsets) 2. adLockReadOnly : This is not what you want when you want to make changes. (Note: ...
by Horizon
Sat Aug 18, 2018 3:25 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Error from ADO
Replies: 14
Views: 3467

Re: Busqueda SQL

... "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 = " + "'" + xRfc + "'" ...
by servicomver
Fri Jul 13, 2018 8:37 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Busqueda SQL
Replies: 15
Views: 3035

Re: Multiple Dimension Array in Combobox

... 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 * FROM vessels WHERE Active=1 ORDER BY [DateCreated] DESC" TRY ...
by joseluisysturiz
Sun May 27, 2018 2:59 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Multiple Dimension Array in Combobox
Replies: 24
Views: 4009

Re: Multiple Dimension Array in Combobox

... 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 * FROM vessels WHERE Active=1 ORDER BY [DateCreated] DESC" TRY ...
by cdmmaui
Sat May 26, 2018 4:53 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Multiple Dimension Array in Combobox
Replies: 24
Views: 4009
Next

Return to advanced search