HMGforum.com

Estimados,
Les presento mi proyecto BrowseAdo. Es un control browse que permite trabajar directamente con un recordset.
Espero les sea de utiliidad
Dear,
I present my project browser. It is a browse control that allows
work directly with a recordset.
I hope they either used
Best regards
Luis Vasquez

Hola Luis

Thanks to sharing

Saludos

--

Esgici

[quote="luisvasquezcl"]Estimados,
Les presento mi proyecto BrowseAdo. Es un control browse que permite trabajar directamente con un recordset.
Espero les sea de utiliidad
Dear,
I present my project browser. It is a browse control that allows
work directly with a recordset.
I hope they either used
Best regards
Luis Vasquez[/quote

Gracias Luis, como siempre grandes aportaciones.
Un cordial saludo

Hi friends,

Thanks Luis for share this amazing function. Very useful.

My best regards,

...
'Data Source=\\Master\Data\test.mdb;'
...
oTabla:Open( "SELECT * FROM Test", oConexion, adOpenDynamic, adLockOptimistic ) // adLockPessimistic
...

Is it possible to update the same record in two locations
I find next error:

Operación: UPDATE
Descripción: Argument error

Date:06/03/2010 Time: 14:30:50
Error WINOLE/1007 Argument error: MOVEPREVIOUS (DOS Error -2147352567)
Called from TOLEAUTO:MOVEPREVIOUS(0)
Called from _BROWSEADOREFRESH(1698)
Called from _ADOINPLACEEDITSAVE(2327)
Called from _ADOINPLACEEDITOK(2273)
Called from (b)_BROWSEADOINPLACEEDIT(2024)
Called from _DOCONTROLEVENTPROCEDURE(4919)
Called from EVENTS(563)
Called from _DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(4583)
Called from _BROWSEADOINPLACEEDIT(2207)
Called from _BROWSEADOEDIT(1841)
Called from ADOPROCESSINPLACEKBDEDIT(2401)
Called from _BROWSEADOEVENTHANDLER(522)
Called from EVENTS(288)
Called from _DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(4561)
Called from MAIN(74)

Hi,
you can save the same data in two tables simultaneously. You must be careful to create a connection for each table as is done with the dbf.
The resulting error may be because you tried to record a key field or the value delivered is not indicated.
Check your code and better yet, send me an example to determine where the problem occurs.
Best regards,
Luis Vasquez

Hola,
es posible guardar los mismos datos en dos tablas en forma simultánea. Debes tener cuidado de crear una conexion para cada tabla tal como se hace con los dbf.
El error que arroja puede ser porque trataste de grabar un campo clave o el valor entregado no es el indicado.
Verifica tu código y mejor todavía, enviame un ejemplo para poder determinar donde se produce el problema.
Saludos cordiales,
Luis Vasquez

luisvasquezcl wrote:Hi,
...
Check your code and better yet, send me an example to determine where the problem occurs.
Best regards,
Luis Vasquez

Luis Vasquez

Hi Luis,

I tried your DEMO, I have not tried the other code
except I changed the path to the database the first time.

Now I do not I changed the path.
I started demo on one computer and I updated
the first record.
When I tried from another computer that
update the same record I got the following errors:



***************************************
Operación: UPDATE
Descripción: Argument error

Harbour MiniGui Errorlog File

------------------------------------
Date:08/03/2010 Time: 20:27:16
Error WINOLE/1007 Argument error: MOVENEXT (DOS Error -2147352567)
Called from TOLEAUTO:MOVENEXT(0)
Called from _BROWSEADOUPDATE(1369)
Called from _BROWSEADOREFRESH(1703)
Called from _ADOINPLACEEDITSAVE(2327)
Called from _ADOINPLACEEDITOK(2273)
Called from (b)_BROWSEADOINPLACEEDIT(2024)
Called from _DOCONTROLEVENTPROCEDURE(4919)
Called from EVENTS(563)
Called from _DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(4583)
Called from _BROWSEADOINPLACEEDIT(2207)
Called from _BROWSEADOEDIT(1841)
Called from ADOPROCESSINPLACEKBDEDIT(2401)
Called from _BROWSEADOEVENTHANDLER(522)
Called from EVENTS(288)
Called from _DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(4561)
Called from MAIN(74)

------------------------------------

I'll try to edit from another computer to see it.
anyway, I'm doing other tests and that also presents problems when the table is empty.
Best regards,
Luis Vasquez