topic-36817

Posts: 1710

Joined: Tue Oct 28, 2008 06:26 PM

Llenar campo con MariaDB
Posted: Mon Feb 25, 2019 09:35 PM

Estimados

Como llenar un campo sin recorrer toda la tabla MariaDB igual a un REPLACE ALL de DBF

De ésta forma tarda:

 oSQL:Gotop()
  Do While !oSQL:Eof()
    oSQL:EXT:='123';oSQL:Save() //oSQL:Update() 
    oSQL:Skip()
  Enddo

Gracias por la ayuda

Saludos,

Adhemar C.

cmsoft

Posts: 1344

Joined: Wed Nov 16, 2005 09:14 PM

Re: Llenar campo con MariaDB
Posted: Mon Feb 25, 2019 11:49 PM

Hola Adhemar:
Con un execute en lugar de llenar registro por registro

Code (fw): Select all Collapse

oServer:Execute("UPDATE mitabla SET ext = '123'")

Puedes agregarle un WHERE con su condicion si no quieres que sea a toda la tabla

Salu2
Cesar Gomez
https://www.bcnsoft.com.ar
https://www.pedidosbcn.com

acuellar

Posts: 1710

Joined: Tue Oct 28, 2008 06:26 PM

Re: Llenar campo con MariaDB
Posted: Tue Feb 26, 2019 02:31 PM

Muchas gracias estimado Cesar

Funciona, pero no actualiza el Browse
Con con TDolphin se usa: oBrw:SetDolphin(oSQL)

Cómo es con MariaDB?

Saludos,

Adhemar C.

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Llenar campo con MariaDB
Posted: Tue Feb 26, 2019 04:04 PM

With FWH Mariadb
(same with browsing dolphin query also)

Code (fw): Select all Collapse

oCn:Execute("UPDATE mitabla SET ext = '123'") 
oRs:Requery()
oBrw:Refresh()

Regards

G. N. Rao.

Hyderabad, India

acuellar

Posts: 1710

Joined: Tue Oct 28, 2008 06:26 PM

Re: Llenar campo con MariaDB
Posted: Tue Feb 26, 2019 04:49 PM

Thanks Mr Rao

it worked perfect

This code does not work, I can not add records

Code (fw): Select all Collapse

     oSQL:Seek(cNom)
     If oSQL:Eof()
               ?"Append"  <-Do not enter
               oSQL:Append();oSQL:NOMBRE:=cNom;oSQL:EXT:=cExt;oSQL:TAMANO:=nTam;oSQL:TIPO:=cTipo;oSQL:POSTER:="";oSQL:UBICACION:=ZpDir
       Else
                oSQL:NOMBRE:=cNom;oSQL:EXT:=cExt;oSQL:TAMANO:=nTam;oSQL:TIPO:=cTipo;oSQL:UBICACION:=ZpDir
        Endif

How is it?

Regards

Saludos,

Adhemar C.

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Llenar campo con MariaDB
Posted: Tue Feb 26, 2019 05:23 PM

Code (fw): Select all Collapse

if oSql:Seek( cNom )
   oSql:Update( "EXT,TAMANO,TIPO,UBIACTION", { cExt, nTam, cTipo, ZpDir } )
else
   oSql:Append( "NOMBRE,EXT,TAMANO,TIPO,POSTER,UBIACTION", ;
                       { cNom, cExt, nTam, cTipo, "", ZpDir } )
endif

Regards

G. N. Rao.

Hyderabad, India

acuellar

Posts: 1710

Joined: Tue Oct 28, 2008 06:26 PM

Re: Llenar campo con MariaDB
Posted: Wed Feb 27, 2019 01:37 PM

Thanks Mr. Rao

How to do this

Code (fw): Select all Collapse

  oSQL:Gotop()
  Do While !oSQL:Eof()
   If Empty(oSQL:DURACION) .And. Empty(oSQL:POSTER) )
      oSQL:Delete()
   Endif
   oSQL:Skip()
  Enddo


//I tried like this
   oCn:Execute("DELETE "+cTABLA+" WHERE Empty(DURACION) And Empty(POSTER)")   //but it does not work

Thank you very much for your time

Saludos,

Adhemar C.

carlos vargas

Posts: 1789

Joined: Tue Oct 11, 2005 05:01 PM

Re: Llenar campo con MariaDB
Posted: Wed Feb 27, 2019 05:12 PM

please try

oCn:Execute("DELETE FROM "+cTABLA+" WHERE LENGTH(DURACION)=0 And LENGTH(POSTER)=0")
or
oCn:Execute("DELETE FROM "+cTABLA+" WHERE DURACION='' And POSTER='' ")

please try first in heidisql or other frontend

Salu2

Carlos Vargas

Desde Managua, Nicaragua (CA)

acuellar

Posts: 1710

Joined: Tue Oct 28, 2008 06:26 PM

Re: Llenar campo con MariaDB
Posted: Wed Feb 27, 2019 08:52 PM

Gracias Estimado Carlos

No funciona
Realice varias pruebas con HeidiSQL, ni comparando con NULL borra

Saludos,

Adhemar C.

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Llenar campo con MariaDB
Posted: Thu Feb 28, 2019 07:52 AM

Assuming DURATION and POSTER are VarChar fields, try using this where clause

Code (fw): Select all Collapse

DELETE FROM <table> WHERE ( DURATION IS NULL OR DURATION = '' ) AND ( POSTER IS NULL OR POSTER = '' )

Regards

G. N. Rao.

Hyderabad, India

MGA

Posts: 1286

Joined: Mon Feb 25, 2008 02:54 PM

Re: Llenar campo con MariaDB
Posted: Thu Feb 28, 2019 01:02 PM

DELETE FROM <table> WHERE COALESCE(DURATION,'') = '' AND COALESCE(POSTER,'') = ''

:wink:

ubiratanmga@gmail.com

FWH24.04
BCC7.3
HARBOUR3.2
xMate
Pelles´C
TDolphin

acuellar

Posts: 1710

Joined: Tue Oct 28, 2008 06:26 PM

Re: Llenar campo con FWH MariaDB
Posted: Thu Feb 28, 2019 03:13 PM

Thanks Mr. Rao

Perfect

Code (fw): Select all Collapse

DELETE FROM <table> WHERE ( DURATION IS NULL OR DURATION = '' ) AND ( POSTER IS NULL OR POSTER = '' )

Obrigado senhor MGA
Perfeito

Code (fw): Select all Collapse

DELETE FROM <table> WHERE COALESCE(DURATION,'') = '' AND COALESCE(POSTER,'') = ''

Saludos,

Adhemar C.

FiveTech Support Forums

Continue the discussion