C
Carlos Adriano Portes
Hi again!
Now I am having some problens with a query involving date, look at the
following:
SELECT FAT_ID, FAT_EMISSAO, FAT_VENCIMENTO FROM FATURA WHERE (FAT_ID=16) AND
(FAT_ATIVA=TRUE) AND (FAT_EMISSAO BETWEEN #4/1/2006# AND #6/1/2006#);
The query returns no rows, and according to the table there is a record that
attends to the condition.
Here's the tabl
FAT_ID FAT_EMISSAO FAT_VENCIMENTO FAT_DESCONTO FAT_DESCONTO_ATE FAT_ATIVA FAT_INICIO FAT_FIM CLI_ID USU_INCLUSAO USU_NOME_INCLUSAO USU_ALTERACAO USU_NOME_ALTERACAO USU_EXCLUSAO USU_NOME_EXCLUSAO USU_REATIVACAO USU_NOME_REATIVACAO
16 5/1/2006 10/1/2006 R$ 0,00 Sim 21/12/2005 10:59:46 5/1/2006
10:59:50 3 5/1/2006 09:03:07 ADMINISTRADOR 5/1/2006
09:36:18 ADMINISTRADOR 5/1/2006 09:37:06 ADMINISTRADOR
17 5/1/2006 10/1/2006 Sim 21/12/2005 10:59:46 5/1/2006
10:59:50 1 5/1/2006 09:04:52 ADMINISTRADOR 5/1/2006
09:36:20 ADMINISTRADOR 5/1/2006 09:37:07 ADMINISTRADOR
....
Could you please help me with it?
Thanks in advance
Now I am having some problens with a query involving date, look at the
following:
SELECT FAT_ID, FAT_EMISSAO, FAT_VENCIMENTO FROM FATURA WHERE (FAT_ID=16) AND
(FAT_ATIVA=TRUE) AND (FAT_EMISSAO BETWEEN #4/1/2006# AND #6/1/2006#);
The query returns no rows, and according to the table there is a record that
attends to the condition.
Here's the tabl
FAT_ID FAT_EMISSAO FAT_VENCIMENTO FAT_DESCONTO FAT_DESCONTO_ATE FAT_ATIVA FAT_INICIO FAT_FIM CLI_ID USU_INCLUSAO USU_NOME_INCLUSAO USU_ALTERACAO USU_NOME_ALTERACAO USU_EXCLUSAO USU_NOME_EXCLUSAO USU_REATIVACAO USU_NOME_REATIVACAO
16 5/1/2006 10/1/2006 R$ 0,00 Sim 21/12/2005 10:59:46 5/1/2006
10:59:50 3 5/1/2006 09:03:07 ADMINISTRADOR 5/1/2006
09:36:18 ADMINISTRADOR 5/1/2006 09:37:06 ADMINISTRADOR
17 5/1/2006 10/1/2006 Sim 21/12/2005 10:59:46 5/1/2006
10:59:50 1 5/1/2006 09:04:52 ADMINISTRADOR 5/1/2006
09:36:20 ADMINISTRADOR 5/1/2006 09:37:07 ADMINISTRADOR
....
Could you please help me with it?
Thanks in advance