FiveTech Software tech support forums

... único registro existente o un nuevo registro y guardar en una tabla sin tener que abrir el objeto RowSet, lo que ahorra tiempo. Uso: oCustRec := oCn:Record( "customer" ) // crea un registo en blanco oCustRec:Edit() // edita y guarda (añade) un nuevo registro oCustRec:Blank() // carga ...

... editing a single existing record or a new record and saving to a table without having to open RowSet object, thus saving time. Usage: oCustRec := oCn:Record( "customer" ) // creates a blank record oCustRec:Edit() // edit and save (append) a new record oCustRec:Blank() // load another ...

Good Morning Mr Rao, I made a test with oCN:InsertSQ() and it's also returning a wrong sentence. It's returning this: INSERT INTO `folha` ( `cemp`,`nfolha`,`cmat`,`cvandes`,`cvdorig`,`val_inf`, `val_calc` ,`total_inc`,`filial`,`clotacao`,`prazo`,`situacao` ...

When you face such problems, I suggest you compare the
oCn:InsertSQL( ... )
with
oCn:CreateTableSQL( <table> )

or
Please create a small sample that we can execute at our end on the above cloud server.

In the next release we will have: oRec := oCn:Record( cTable )oRec:Edit() for editing and saving a blank record. oRec := oCn:Record( cTable, cWhere )oRec:Edit() for editing a single existing record and saving the ...

I am try this: Code: aRow := oCn:QueryResult( "select field1,field2 from states where code='WA'" ) if aRow == NIL // not found, then inserts aRow := { "aa","bb" } oCn:Upsert( "states", nil, { aRow ...

Hola gente, me pueden decir que estoy haciendo mal: xdrive := curdrive() + ":\" + curdir()+"\esp" oCn := FW_OpenAdoConnection( { "FOXPRO", xdrive}, .T.) cSQL := "select top 10 Cliente, Fecha, licita, descrip, cantidad, devol from detlici where codigo ...

oCn:RowSet( cSql, 100 ) means read first 100 records only Sameway oCn:RecSet( cSql, 100 ) also means read first 100 records only. But oCn:RecSet( cSql, -100 ) means read entire table with page size 100. RecSet does not read ...

Thanks Rao ,
just what I was looking for .
What does -100 mean in oCn:RecSet( cSql, -100 )
I knowo Cn:RecSet( cSql, 100 ) but not with a negative sign

Regards Maurizio

:ActiveConnections is only for ADO recordsets. In fwmaria lib, it is oRs:oCn. To change the sql, please make a new RecSet object, set it to oBrw:oDbf and then close the old RecSet object You may try this sample and use similar logic #include "fivewin.ch"function ...

I'm trying oCn:RecSet() and it's very, very fast, I noticed that certain methods that work with oCn:Rowset() with :RecSet() don't work.

What size of tables you tested?

Thank Rao

I'm trying oCn:RecSet() and it's very, very fast, I noticed that certain methods that work with oCn:Rowset() with :RecSet() don't work.

Is it possible to have a list of :RecSet() methods?

Thank you
Maurizio

... TOLEAUTO:EXECUTE( 0 ) Called from: abd4.prg => MAIN( 58 ) en el dbf prudbt inserta el registro sin problema, el error lo da en el dbf prueba oCn := FW_OpenAdoConnection( "c:\fwh2212\samples\" ) oCnM := FW_OpenAdoConnection( { "FOXPRO", "c:\fwh2212\samples\"}, ...

... tengo este programa y no entiendo porque me da error el segundo insert: #include "FiveWin.ch" REQUEST HB_LANG_ES function Main() local oCn, oCnM, oRs, aStates LOCAL lShowError := .t. /* dbcreate( ".\prudbt", { { "id" , "n", 8, 0 }, ; { "Cliente " ...

... pone muy lento en red es una constulta muy sencilla: cSQL := "SELECT top 20 numero,nombre,domic FROM clientes" oRs1 := FW_OpenRecordSet( oCn, cSQL ) de que manera puedo acelerar esto, porque se pone muy lento. When we use TOP n, it is desirable to use ORDER BY clause.