MARIADB esto no me funciona

MARIADB esto no me funciona

Postby goosfancito » Fri Oct 01, 2021 2:10 am

Code: Select all  Expand view  RUN
     ? ::oCnx:update( "tbcontactos", ;
                        "nombre, domiciio, telefono, obs", ;
                        { ::vGets[ 1 ], ::vGets[ 2 ], ::vGets[ 3 ], ::vGets[ 4 ] }, ;
                        {{"id", ::nId}})


si hago un INSERT funciona, pero un UPDATE no funciona y no se como hacer para "ver" cual es el error que tengo al ejecutar el comando.
FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/
User avatar
goosfancito
 
Posts: 1954
Joined: Fri Oct 07, 2005 7:08 pm

Re: MARIADB esto no me funciona

Postby nageswaragunupudi » Fri Oct 01, 2021 6:43 am

If you set ::oCnx:lShowErrors := .t.
The errors will be displayed when they occur.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10656
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: MARIADB esto no me funciona

Postby goosfancito » Fri Oct 01, 2021 9:03 am

muchas gracias! encontre el error. "domiciio' no existe. es 'domicilio'
FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/
User avatar
goosfancito
 
Posts: 1954
Joined: Fri Oct 07, 2005 7:08 pm

Re: MARIADB esto no me funciona

Postby goosfancito » Fri Oct 01, 2021 9:05 am

nageswaragunupudi wrote:If you set ::oCnx:lShowErrors := .t.
The errors will be displayed when they occur.


estimado, y como refresco el xbrowse una vez que agregue un registro a la tabla?

Code: Select all  Expand view  RUN
::ocnx:insert....
::oqry:refresh()
::oBrw:refresh()
...
FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/
User avatar
goosfancito
 
Posts: 1954
Joined: Fri Oct 07, 2005 7:08 pm

Re: MARIADB esto no me funciona

Postby nageswaragunupudi » Fri Oct 01, 2021 9:57 am

Please wait
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10656
Joined: Sun Nov 19, 2006 5:22 am
Location: India


Return to FiveWin para Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 38 guests