Search found 1344 matches: alltrim

Return to advanced search

Re: Cambiar ALT+INTRO de Excel a Intro en campo memo.SOLUCIONADO

A mi me ha funcionado poniendo así:

vconcepto:=strtran(alltrim(oHoja:Cells( nrow, 5 ):Value),chr(10),CRLF)

Espero que le sirva a quien lo necesite.

Un saludo
by Garbi
Mon Apr 22, 2024 4:33 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Cambiar ALT+INTRO de Excel a Intro en campo memo.SOLUCIONADO
Replies: 2
Views: 57

Cambiar ALT+INTRO de Excel a Intro en campo memo.SOLUCIONADO

... impermeabilización." y al pasarlo de la siguiente mamera a un campo memo en el fichero dbf lo hace obviando el intro (ALT+INTRO) vconcepto:=alltrim(oHoja:Cells( nrow, 5 ):Value) y queda así: "RETIRADA DE PAVIMENTO. Demolición del pavimento, capa de nivelación e impermeabilización existentes. ...
by Garbi
Mon Apr 22, 2024 2:45 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Cambiar ALT+INTRO de Excel a Intro en campo memo.SOLUCIONADO
Replies: 2
Views: 57

Re: Centrar texto VERTICALMENTE

... Carmona ). At the moment this is how it works for me (more or less): ndummyaltura := ( ::oPrn:CmVertPhySize() / 2 ) + ( ::oPrn:CmtrGetTextWidth( AllTrim( ::oTDbfDatAmp:REGMER ), ::oFnt_Arial6V ) / 2 ) UTILPRN ::oUtil ndummyaltura, 0.5 ; SAY AllTrim(::oTDbfDatAmp:REGMER) FONT ::oFnt_Arial6V COLOR ...
by nageswaragunupudi
Tue Apr 09, 2024 4:49 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Centrar texto VERTICALMENTE
Replies: 12
Views: 473

Re: Centrar texto VERTICALMENTE

... Carmona ). At the moment this is how it works for me (more or less): ndummyaltura := ( ::oPrn:CmVertPhySize() / 2 ) + ( ::oPrn:CmtrGetTextWidth( AllTrim( ::oTDbfDatAmp:REGMER ), ::oFnt_Arial6V ) / 2 ) UTILPRN ::oUtil ndummyaltura, 0.5 ; SAY AllTrim(::oTDbfDatAmp:REGMER) FONT ::oFnt_Arial6V COLOR ...
by FiveWiDi
Tue Apr 09, 2024 3:28 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Centrar texto VERTICALMENTE
Replies: 12
Views: 473

Re: Problem with valid email refresh btnbmp

PERHAPS ??

function validaEmail(cEmail)
LOCAL pCompiled := hb_regexComp("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$")

LOCAL cRet := .t.

IF HB_RegExMatch( pCompiled, alltrim(cEmail), .F. )


cRet := .f.
end
return cRet
by Silvio.Falconi
Wed Apr 03, 2024 10:21 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Problem with valid email refresh btnbmp- RESOLVED
Replies: 25
Views: 2411

Re: Parpadeo de un SAY

... := usuari Acciones->Fecha := date() Acciones->Hora := left(time(),5) Acciones->Detalle := if(agrega,'Agregó el Material '+alltrim(cdetalle),'Modifico el Material '+alltrim(cDetalle)) dbcommitall() endif Materia->(dbsetorder(queor)) Materia->(DbGoTop()) return NIL ...
by José Camilo
Sat Mar 02, 2024 10:30 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Parpadeo de un SAY
Replies: 18
Views: 586

Re: Problem with alignment in SAY command

... setup: yes - no, and here it is working. Sometimes I use text from a DBF file, which is, for example, 160 characters long, and forget to apply ALLTRIM(). Then, you might have some spaces on the right. Best regards, Otto If I save my res as rc: right no: CONTROL "heute", 4001, "Static", ...
by Otto
Fri Mar 01, 2024 10:19 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Problem with alignment in SAY command
Replies: 18
Views: 838

Re: Create a Panel width a text

... PANEL Layout :?: --- in my modify CODE all Lines are displayed and Position of Panel3 will change    aDim = GetLabelDim( oPanel2:hWnd, alltrim(cMessage), oFonttext:hFont ) GetLabelDim() will give you "right" Size and    oFonttext:nHeight() +2 is hight of ...
by Silvio.Falconi
Mon Feb 26, 2024 8:14 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Create a Panel width a text
Replies: 29
Views: 3187

Re: Problemas con ordenamiento de datos.

hi,

Code: Select all  Expand view
(domicilio  )+Alltrim  (piso  )+Alltrim  (depto  )

a Index Expression must be "same Length" so ALLTRIM() are NOT working "in" a Index :!:

---

it seem me that your YEAR use only 2 Digit ?
than try
Code: Select all  Expand view
SET EPOCHE TO YEAR(DATE()) -50
by Jimmy
Fri Feb 23, 2024 3:13 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Problemas con ordenamiento de datos.
Replies: 4
Views: 196

Re: JSON2DBF adapter

... 'start/end/nil')` The `addresponse` should include a `Val2Char()` function. ``` h['response'] += "{" + '"name":' + '"' + ALLTRIM(address->name) + '",' h['response'] += '"street":' + '"' + ALLTRIM(address->street) + '",' h['response'] += '"city":' ...
by Otto
Sun Feb 04, 2024 8:03 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: JSON2DBF adapter
Replies: 3
Views: 504

Re: xbrowser, ordenar una columna del tipo "C"

puedes probar esto, ver si funciona

PADL(::oQry:FieldGet( "c4"), 2, "0")

Substr( PADL(::oQry:FieldGet( "c4"), 2, "0"),1,2)

o

PADL(alltrim(::oQry:FieldGet( "c4")), 2, "0")
by solving
Wed Jan 31, 2024 5:55 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: xbrowser, ordenar una columna del tipo "C"
Replies: 3
Views: 183

Re: MariaDb SetFilter Error no definida: SOLUCIONADO

... Nombres :",@cPer ) WaitOn("Espere un momento por favor....",@oWait ) If cPer = Space(30) x := "" Else x := Upper(Alltrim( cPer )) EndIf cWhere := "detalle LIKE '"+x+"%'" oQry:SetFilter( cWhere ) aServer:ShowError() SysRefresh() oBrw:Refresh() ...
by CARLOS ATUNCAR
Sat Jan 27, 2024 1:14 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: MariaDb SetFilter Error no definida: SOLUCIONADO
Replies: 2
Views: 165

Re: MariaDb SetFilter no realiza Filtrado

... Nombres :",@cPer ) WaitOn("Espere un momento por favor....",@oWait ) If cPer = Space(30) cWhere := "" Else x := Upper(Alltrim( cPer )) cWhere := "c.detalle LIKE '% ? %' " EndIf oQry:SetFilter( cWhere ,{x}) aServer:ShowError() SysRefresh() oBrw:Refresh() WaitOff( ...
by CARLOS ATUNCAR
Sat Jan 27, 2024 12:04 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: MariaDb SetFilter Error no definida: SOLUCIONADO
Replies: 2
Views: 165

MariaDb SetFilter Error no definida: SOLUCIONADO

... :",@cPer ) WaitOn("Espere un momento por favor....",@oWait ) If cPer = Space(30) cWhere := "" Else mWhere := {Upper(Alltrim( cPer ))} cWhere := "c.detalle LIKE '%?%'" EndIf TRY oQry:SetFilter( cWhere , mWhere) CATCH o SysRefresh() END oBrw:Refresh() WaitOff( ...
by CARLOS ATUNCAR
Fri Jan 26, 2024 11:36 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: MariaDb SetFilter Error no definida: SOLUCIONADO
Replies: 2
Views: 165

Re: erase files

... parametro D static Function Cancella_Archivi(cDir) local adir := DIRECTORY(cDir+ "*.*" ) local i,cFile FOR i = 1 to LEN( aDir ) cFILE := ALLTRIM( aDIR[i][1] ) IF FErase(cDir+cFile ) != 0 Msginfo( FERROR() ,cfile) endif NEXT return nil
by Silvio.Falconi
Fri Jan 26, 2024 11:13 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: erase files - Resolved!!
Replies: 20
Views: 1542
Next

Return to advanced search