Search found 87 matches: descrip

Return to advanced search

Re: Mysql recover values usaing field names

I found oRs:DESCRIP Works
by PAUL SIMM
Thu Nov 21, 2024 9:42 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Mysql recover values usaing field names
Replies: 3
Views: 227

Mysql recover values usaing field names

... return nil ENDIF cQwery:="SELECT * FROM proforma" oRs := oCn:RowSet( cQwery) MSGINFO(oRs:FieldGet(5)) //WORKS SHOWS CONTENT OF 1ST FIELD DESCRIP MSGINFO(oRs:FieldName("DESCRIP")) //DOSE NOT WORK oCn:Close() RETURN NIL **************************************************************************************** ...
by PAUL SIMM
Mon Nov 18, 2024 6:08 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Mysql recover values usaing field names
Replies: 3
Views: 227

Error con FW_OpenRecordSet

... + curdir()+"\esp" oCn := FW_OpenAdoConnection( { "FOXPRO", xdrive}, .T.) cSQL := "select top 10 Cliente, Fecha, licita, descrip, cantidad, devol from detlici where codigo = '00024' order by descrip" // and licita = 221345 oRs := FW_OpenRecordSet( oCn, cSQL ) El error ...
by jpcavagnaro
Sat Mar 09, 2024 11:27 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Error con FW_OpenRecordSet
Replies: 1
Views: 270

Re: Xbrowse

aCol := {"StrZero(Productos->Codigo,8,0)","Productos->Descrip","StrZero(Productos->Rubro,4,0) + "-" +Traetabla("Rubros","Indi1","Rubros",Productos->Rubro)[2]","Productos->Precio1","Productos->Precio2"} ...
by CarlosFossati
Sat Feb 19, 2022 1:07 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Xbrowse
Replies: 4
Views: 590

Re: consultar 2 tablas

Pude hacerlo:

select descrip, cantidad, codigo from remito union select descrip, cantidad, codigo from compras

Saludos.
Gracias
by jpcavagnaro
Fri Dec 04, 2020 11:52 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: consultar 2 tablas
Replies: 3
Views: 542

Re: An easy way to make a tree-browse

... //ldbl click tree // dynamic expand sub trees oCol := obrow2:AddCol() oCol:bStrData := {||odb2:descrip} oCol:cHeader := "科目名称" oCol:bEditValue:= {||odb2:descrip} oCol:nEditType:={||if(::ledit.and.!odb2:EOF(),1,0)} oCol:bOnPostEdit := ...
by ShumingWang
Wed Jul 31, 2019 1:41 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: An easy way to make a tree-browse
Replies: 17
Views: 4147

Re: Exportacion especial Excel a Dbf SOLUCIONADO

... Por ejemplo, tenemos: en fichero XLS las Cols : Codigo, nombre, fechaemision, documento, monto,... en fichero DBF campos: fecha, factura, valor, descrip, codiCte, nombreCte Y la importacion hacia la dbf seria La columna codigo del xls hacia el campo codicte de la dbf La columna nombre del xls ...
by FranciscoA
Fri Dec 21, 2018 5:43 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Exportacion especial Excel a Dbf SOLUCIONADO
Replies: 14
Views: 4082

Re: xbrowse bLDblClick y edición de columnas

Manuel, intenta con cualquiera de las siguientes lineas: WITH OBJECT oBrw :bLDblClick := {|| if(oBrw:SelectedCol:cHeader $ "DESCRIP;TOTAL;VDESC", MsgInfo("Tu Function-Dialog"),) } :bLDblClick := {|| if(oBrw:SelectedCol:nEditType = 0, MsgInfo("Tu Function-Dialog"),) ...
by FranciscoA
Sat May 26, 2018 3:51 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: xbrowse bLDblClick y edición de columnas [solucionado]
Replies: 7
Views: 2245

FWH 18.03 XBROWSE CON EDIT_GET ERROR INESPERADO !!!

... 7.0 (32-bit) Windows version: 6.1, Build 7601 Service Pack 1 Time from start: 0 hours 0 mins 13 secs Error occurred at: 28/04/18, 11:26:58 Error description: Error BASE/1070 Argument error: == Args: [ 1] = B {|| ... } [ 2] = B {|| ... } Stack Calls =========== Called from: .\xbrowse.prg => ...
by rterraz
Sat Apr 28, 2018 2:50 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: FWH 18.03 XBROWSE CON EDIT_GET ERROR INESPERADO !!!
Replies: 7
Views: 2427

Re: BOM production

... } oTree:SetImageList( oImageList ) oItem = oTree:Add(itemid1) odb1:=oServer:Query("select bom2.itemidc itemidc,cversion,goods2.descrip descrip,goods2.size size,unit.unit unit,substring(bom2.mem,1,25) mem,bom2.qty/bom2.qtydevisor*(1+ifnull(bom2.scraprate,0)/100)+bom2.fixscrap ...
by ShumingWang
Fri Apr 27, 2018 2:03 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: BOM production
Replies: 3
Views: 1180

Re: A question about function FW_Cdxcreate()

... ! deleted()" // And you MUST USE the TAG clause! use customer index on chgno tag "custid" to customer for ! deleted() index on descrip tag "company" to customer for ! deleted() index on phone tag "phone" to customer for ! deleted() ... You use a other approach ...
by Marc Venken
Tue Feb 27, 2018 8:02 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: A question about function FW_Cdxcreate()
Replies: 8
Views: 1916

Re: Error TDolphin

... "999.99" REDEFINE DBCOMBO oEstado VAR oQryCob:C_Estado ID 122 OF CobraDlg ; ALIAS oQryEsta ITEMFIELD "codigo" LISTFIELD "descrip" REDEFINE DBCOMBO oVende VAR oQryCob:codi_vende ID 4004 OF CobraDlg ; ALIAS oQryVende ITEMFIELD "codigo_V" LISTFIELD "nombre_V" ...
by caducca
Thu Oct 26, 2017 12:08 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Error TDolphin
Replies: 7
Views: 2187

Re: Xbrowse - EDIT_LISTBOX

... del browse no aparece lo que indico al crear el mismo mi codigo: este es el array que genero OpenDbf('wfprodu') aProd:= FW_DBFToArray("descrip,codint,control", {|| wfprodu->control $ 'ABCDEFGV' }) Aeval(aProd,{|x| AADD( aList, x[1] ) } ) Dbclosearea OpenDbf('wfsico') /* wfsico.dbf ...
by rterraz
Tue Feb 14, 2017 3:00 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Xbrowse - EDIT_LISTBOX
Replies: 4
Views: 1963

Re: buscar la coincidencia en toda la cadena

Hola Si la variable donde se encuentra lo que buscas se llama, por ejemplo, cSearch, y el campo donde buscas es Descrip, entonces usa el siguiente filtro SET FILTER TO cSearch$Field->Descrip El operador $ : a$b retorna .T. si a está dentro de b, en cualquier lugar. Tambien se ...
by Carlos Mora
Tue Jan 24, 2017 3:00 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: buscar la coincidencia en toda la cadena
Replies: 7
Views: 2125

Re: fiveweb: combobox seleccion

... VEZ ASIGNA EL ULTIMO, UNA VEZ ELEGIDA LA OS ASIGNO LA QUE DEVUELVO AL VOLVER DE LA CONSULTA (OSO)->(dbseek(aParams[3])) cValor:=(OSO)->descrip+' ['+(OSO)->cod_osoc+']' // PARA HACER N CONSULTAS CONSERVANDO LA OBRA SOCIAL ELEGIDA else // NO VEO NUNCA QUE ME PONGA UN "SELECTED" ...
by silvinamazzaro
Wed Aug 10, 2016 12:33 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: fiveweb: combobox seleccion
Replies: 13
Views: 2991
Next

Return to advanced search

cron