FiveTech Software tech support forums

Thanks Rao,
With oCn:time_zone := '+00:00' is Correct.
Thanks a lot.

function Main()   local oCn, oRs[4], oDlg, oFont   SET DATE ITALIAN   SET CENTURY ON   SET TIME FORMAT TO "HH:MM:SS"   FWCONNECT oCn HOST "208.91.198.197:3306 ...

Mr. Rao,

Did you notice that the "00:mm:ss" records on the 13th day are showing up on the 12th day?

Do you have any news on this?

Thaks João.

Here it are the image:

https://uploaddeimagens.com.br/imagens/VCBQyKo

Hi Raw,

I sent the image to your e-mail because I don't know how to attach it here on the forum.

Thank your help.

Please run this test.

#include "fivewin.ch"function Main()   local oCn, oRs   local t   SET DATE ITALIAN   SET CENTURY ON   FWCONNECT oCn HOST "208.91.198.197:3306" USER "gnraofwh" PASSWORD "Bharat@1950" DATABASE "fwhdemo" PORT "3306 ...

Hi Rao,

I was able to reproduce the situation. Please run the code below that it will return 31 records, but actually are 29.

The same select in HeidiSQL correctly returns 29 records.

#include "fivewin.ch"function Main()   local oCn, oRs   local t   SET DATE ...

The FW_DemoDB( 6 ) doesn’t work.

Raw,

I tried to run your example but returned the error: 1045 Acess denied for user 'sql7148817@'189-46-180-40.dsl.telesp.net.br (using password: YES).

Thanks

Unfortunately it didn't work.
Could the problem be with my DLL version?

Hello,

I would like to know if this issue in select with TIMESTAMP field has been fixed in newer versions of FWH.

The same SELECT in SQLRDD and HeidiSQL brings the correct records, but in native mode it brings records from other dates.

Thanks.

Hi Raw,

The type of field is TIMESTAMP.

If I don´t put date(casps.data) the query does´t work and return all records.

Thanks Raw,

I modified to:
WHERE date(casos.data)>=date('2022-01-01') AND date(casos.data)<date('2022-01-12')+1;

The result is 31 records, like before.

There are two records in casos.data = date('2022-01-13') in the result.

I don´t know why.

Do you have another idea?

Hello Friends,

With this command in oQry:Query() in MySQL
WHERE cases.date BETWEEN '2022-01-01 00:00:00' AND '2022-01-12 23:59:59';
Return 31 records, the last two with date '2022-01-13 00:47:50'

Using the same Select in HeidiSql, 29 records are returned correctly within the period 01 to 12 ...

Pessoal,

Já tem alguém usando a lib ACBRNFE32.DLL para emitir NF-e em modo de produção no lugar do ACBrNFeMonitor?

Quero compartilhar os resultados e trocar experiências.

Na mosca! Resolveu. Obricado.