Search found 137 matches: cursorlocation

Return to advanced search

connecting SQL SERVER VIA ODBC PROLEM

... podido crear el RECORDSET de Pedidos!", 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" ...
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

... podido crear el RECORDSET de Pedidos!", 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" ...
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

... podido crear el RECORDSET de Pedidos!", 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" ...
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

... podido crear el RECORDSET de Pedidos!", 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" ...
by MANOLO
Mon Jan 29, 2024 9:12 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: CONEXION ADODB SQL SERVER
Replies: 0
Views: 135

Re: FW_OpenRecordSet lento en red

... properties manually ... oRs1 := TOleAuto():New( "ADODB.Recordset" )oRs1:CursorType     := 1        // opendkeysetoRs1:CursorLocation := 3       // local cacheoRs1:LockType       := 3         // lockoportunisticTRY   oRs1:Open(cSQL,oCn )CATCH oErr   MsgInfo( ...
by nageswaragunupudi
Mon Dec 18, 2023 6:06 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: FW_OpenRecordSet lento en red
Replies: 8
Views: 560

Re: Request : new PostgreSQL OLEDb-Provider

hi,

thx for Answer.

i do have already CursorLocation and FASTEDIT in Sample ...

what do you mean with "inline edit" , how :?:
by Jimmy
Wed Sep 20, 2023 11:01 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Request : new PostgreSQL OLEDb-Provider
Replies: 11
Views: 660

Re: Request : new PostgreSQL OLEDb-Provider

but "save" seems not work

Try inline edit.

Any valid ADO recordset is recognized as RecordSet.

To start with just use
Code: Select all  Expand view
XBROWSER oRs FASTEDIT


Try to add CursorLocation of connection object also as adUseClient.'
by nageswaragunupudi
Tue Sep 19, 2023 2:42 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Request : new PostgreSQL OLEDb-Provider
Replies: 11
Views: 660

Error ADODB.Recordset/6 DISP_E_UNKNOWNNAME: ISKINDOF

... * 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( "Error in Opening ...
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

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

... BY ACTIVO" oRsDir := 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 ...
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

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

... 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='] + ALLTRIM( cScheduleId ...
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

... "ADODB.RecordSet" ) 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 ...
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

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

CursorLocation 1 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) ...
by Horizon
Sat Aug 18, 2018 3:25 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Error from ADO
Replies: 14
Views: 3467
Next

Return to advanced search