Llenar campo con MariaDB

[acuellar]

Estimados

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

De ésta forma tarda:

Code: Select all | Expand

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

Gracias por la ayuda

[cmsoft]

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

Code: Select all | Expand

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

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

[acuellar]

Muchas gracias estimado Cesar

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

Cómo es con MariaDB?

[nageswaragunupudi]

With FWH Mariadb
(same with browsing dolphin query also)

Code: Select all | Expand

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

[acuellar]

Thanks Mr Rao

it worked perfect

This code does not work, I can not add records

Code: Select all | Expand

     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

[nageswaragunupudi]

Code: Select all | Expand

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

[acuellar]

Thanks Mr. Rao


How to do this

Code: Select all | Expand

  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

[carlos vargas]

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

[acuellar]

Gracias Estimado Carlos

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

[nageswaragunupudi]

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

Code: Select all | Expand

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

[MGA]

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

[acuellar]

Thanks Mr. Rao

Perfect

Code: Select all | Expand

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

Obrigado senhor MGA
Perfeito

Code: Select all | Expand

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