FiveTech Software tech support forums

... What I do not understand is the inconsistency, since I think that the greater the number of days, the price should be less, up to a certain limit. For example, if the price for a week is 40 (5.71 per day), for 15 days it should be less (per day), and so on. However, it is my particular concept, ...

Sí, efectivamente, ese ha sido siempre una limitación del acceso al Translate de Google, cuando no se accede a través de su API. De todas formas, voy a modificar la function para que no dé error de ejecución, aunque devuelva la cadena en blanco. ...

... JOIN teste AS tes ON st.ctest=tes.ctest WHERE tes.data >= '2019-06-16' AND tes.calmox='01' AND tes.situacao <> 'I' ORDER BY tes.data DESC LIMIT 5" but I'm still having trouble with my code that requires more lib's from fwh and harbour... :( maybe the parameter that Antonio mentioned ...

... JOIN teste AS tes ON st.ctest=tes.ctest WHERE tes.data >= '2019-06-16' AND tes.calmox='01' AND tes.situacao <> 'I' ORDER BY tes.data DESC LIMIT 5"   HB_AtX( " ORDER BY | HAVING | LIMIT | GROUP ", cSql, .f., @nAt )   ? nAt, cSql, SubStr( cSql, nAt ) return ...

Efectivamente es un error del programa Editsource()
está mandando el WHERE después del ORDER y LIMIT ,
lo cual es un error de sintaxis para MYSQL

Right

Efectivamente es un error del programa Editsource() está mandando el WHERE después del ORDER y LIMIT , lo cual es un error de sintaxis para MYSQL WINRUN( 0 )<-TMDIFRAME:ACTIVATE( 1078 )<-START( 96 )" cSql = "SELECT * FROM tipos as TIP ORDER BY CTIPO LIMIT ...

Thanks Marcos,
But, as I say before. the problem is happening because I'm using clausules ORDER and LIMIT. IF I remove then everything is fine.

LE QUITARIA LA OPCION "AS TIP"


oRs := oBD:QUERY("SELECT * FROM tipos ORDER BY ctipo LIMIT 1000")

Hi Guys, IF I create a rowset where I use ORDER or LIMIT EditSource() Is not working. I think it's doing wrong changes in my sql statement. Please look at this little code: oRs := oBD:QUERY("SELECT * FROM tipos AS tip  ORDER BY ctipo LIMIT ...

... bitmaps and all types of images can be used with comboboxes. * TDatePick class: Enhancements - SetRange( dFrom, dLast ): Sets lower and upper limits for selection of dates. In case of DateTime variable, the parameters may be DateTime values. Value of NIL clears that range. - GetRange() --> ...

Saludos
Recomiendo tambien utilizar paginado,
SELECT * FROM TABLAS LIMIT X,Y
obteniendo un arrelgo y luego liberas la conexión.

... As you can see here I use get and you XbrGetDate func because on dtpicker I cannot set a calendar limit then I have procedures and many function need the format 8/04/2020 and so I need to recovert the cdate from "Merc, 8 Apr 2020" string ...

Thanks I'll try It
I saw on web on a form you write and there Is a text where Is show ed the number characters you can use of you write with a Number of characters up the the limit the form disabled the button

Giovany Vecchi wrote:

cnavarro wrote:Giovany, Your design is very good, congratulations

Thank you Navarro. We have to show that Fivewin is beyond what we think we can do.

The limit is our imagination, without any doubt

Giovany Vecchi wrote:I thought the Set3DLook(.F.) function would solve this question

Have you managed to solve the 3D effect?

on Ca-Clipper there was a test make it but then the dbf are too big to manage
I think it can be made with array , wich is the limit for an array ?