FiveTech Software tech support forums

How can I recover values from a SELECT using the field name and not its position in th array? oCn :=maria_Connect( cHost,cUser,cDb,cPwd ) IF oCn=NIL msgwait("Error conectando con eventos en la nube","") return nil ENDIF ...

Here the error occurs, it seems that internally xbrowse does SELECT *... see the error log There is NO problem with XBrowse. XBroswe does not make any SELECT queries. XBrowse simply calls oYourDolpinQry:SetOrder( cFieldName ) Your error is occurring ...

Param 1: C "SELECT * FROM nfsaida AS nf LEFT JOIN pedidos AS p ON (nf.chave=p.chave) LEFT JOIN clientes AS c ON (nf.cliente = c.codigo) WHERE IF(nf.filialfiscal!=0,nf.filialfiscal,nf.filial) = 1 AND nf.emissao BETWEEN '2024-11-01' ...

Here the error occurs, it seems that internally xbrowse does SELECT *... see the error log Time from start: 0 hours 1 mins 17 secs Error occurred at: 14/11/2024, 15:28:38 Error description: Error MYSQL/1052 Column 'chave' in order clause is ambiguous Stack ...

... TArrayData,,, se pueda construir y retornar con una estructura de campos, pasada como parámetro.. ver ejemplo.. Nota : buscando optimizar el select interno que actualmente es "select * from" ejp : local cLisCam := "campo1,campo2,..."oRs := TArrayData():NEW(oConSql, ...

... oQry, oBrw CONNECT oServer HOST 'localhost' ; USER 'root' ; PASSWORD 'miclave' ; PORT 3306 ; FLAGS 0; DATABASE 'test' oQry := oServer:Query('SELECT p.chave as chave, p.data as data, c.nome as nome FROM ped AS p LEFT JOIN cli AS c ON(c.codigo=p.codigo) ORDER BY p.chave') DEFINE DIALOG oForm ...

... between tables, which coincidentally has a field in the table with the same name: "key". But this field is not part of the query. SELECT p.key, p.data, c.name FROM orders AS p LEFT JOIN customers AS c ON(c.code=p.code) the browse works fine, however when clicking on the header ...

wfecha:=Dtos(Ctod('07/11/2024')) Text Into cSql SELECT m1.tropanumero AS tropa, m1.correlativo, ani.descripcion, m1.inac AS INACUR,ROUND( t.kilosen1 / t.cabezas , 2) AS KEnPie, m1.kilos + isnull(m2.kilos,0) AS KClasif, m1.precioen2 FROM C10304 m1 ...

Enrico Maria Giordano

Just add this line to your ilink32.cfg:

Code: Select all Expand view
-GF:LARGEADDRESSAWARE


thank you very much!

... := { || { CLR_WHITE, ORANGE } } no good for me https://i.postimg.cc/zvvvX1Qc/hh.png I wish have the text white on orange when I select one record and when I click over ( true) the second column ( that is checked) must colorize of orange

I have this color on cell



But I set
:bClrSelFocus := { || {0,RGB(204,242,255)}}
:bClrRowFocus := { || {0,RGB(204,242,255) }}

then when I select a cell it change with my color

... name of the field, but also an expression for example " trim(first) + ' ' + trim(last) " "alltrim(str(id))" this way we can select numeric fields I leave the source and example, the example is in the dbcombo.prg source https://app.box.com/s/tdp8d0odtcydwcld755e0e5etcv18v75

... Noté en el mensaje de error que se está utilizando odbc 3.51 ODBC 3.51 es malo. Ha passado mucho tiempo, no recuerdo cuál era el comando. Mismo SELECT simple, odbc 3.51 causó desconexión, pero odbc 5.3 ningún problema. Nunca volvi a usar odbc 3.51 después de eso. Y en ConnectionString de 5.3 ...

... (free) 2. create a new notebook and add sources to it. You can directly provide GitHub URLs to the Harbour/xHarbour modules. 3. Select the language to use: In example for spanish use "El podcast está orientado al público hispanoparlante. !IMPORTANTE hablad en español!" ...

https://i.postimg.cc/Bn5rY7b8/VB-Xbrowse.gif in VB net there is a grid with which one can select all the cells and then by doing ctrl+C one can copy the content and transfer it to a notepad file, in Xbrowse this is not yet possible I hope that in the future ...