Problems with date's fields in the SQLServer

rbuser

I'm using Delphi 5, RBuilder 6.03 and SQL Server 2000.

When I use date's fields happen a error in the clause "Where".

The date format in the SQLServer is MM/DD/YYYY, but in RBuilder's SQL_CODE
is YYYY/MM/DD and with this isn't executing the clause "Where" correctly.
The properties are:

CollationType = ctANSI
DataBaseType = dtMSSQLServer
SQLType = sqSQL1

Tried with ctASCII in CollationType and sqSQL2 in SQLType too and nothing
worked.

Does some parameter exist to correct this?


Below an exemple of RBuilder( Clause with problem: Fatura.fatura_pagamento

SELECT Empresa.empresa_descricao,
Fornecedor.fornecedor_descricao,
Fatura.fatura_periodo_pagamento,
Categoria.categoria_descricao,
SUM(Item_Fatura.item_fatura_valor) SUM_Item_Fatura_item_fatu
FROM dbo.Empresa Empresa, dbo.Recurso Recurso
, dbo.Tipo_Recurso Tipo_Recurso
, dbo.Fornecedor Fornecedor
, dbo.Item_Fatura Item_Fatura
, dbo.Fatura Fatura, dbo.Categoria Categoria
WHERE
(Recurso.empresa_codigo = Empresa.empresa_codigo)
AND
(Tipo_Recurso.tipo_recurso_codigo = Recurso.tipo_recurso_codigo)
AND
(Fornecedor.fornecedor_codigo = Tipo_Recurso.fornecedor_codigo)
AND
(Item_Fatura.vigencia_outro_servico_codigo = Recurso.recurso_codigo)
AND
(Fatura.fatura_codigo = Item_Fatura.fatura_codigo)
AND
(Categoria.categoria_codigo = Tipo_Recurso.categoria_codigo)
AND (
( Fatura.fatura_pagamento >= '2004/01/04' ))
GROUP BY Empresa.empresa_descricao,
Fornecedor.fornecedor_descricao,
Fatura.fatura_periodo_pagamento,
Categoria.categoria_descricao


Thanks


Cristian L. Ferreira
Gerente de Desenvolvimento - Divis?o Servi?os
cristian@sumus.com.br
fone 55 11 6847.1838
www.sumus.com.br

nicocizik

Hi Cristian,

Try downloading a copy of ReportBuilder 7.03 trial and test with that. In
my testing with RB 7.03 and SQL Server 2000, ReportBuilder added in a
CONVERT command when inserting a date into the where clause. This may have
been a bug fix or enhancement since RB 6.03.

--

rbuser

Hi Nico,

I installed RB 7.03 Ent Trial and the problem was solved, but I have RB 6.03
Ent, How to solve for my version?

Thanks

Cristian L. Ferreira
Gerente de Desenvolvimento - Divis?o Servi?os
cristian@sumus.com.br
fone 11 6847.1838
www.sumus.com.br

nicocizik

Hi Cristian,

I'm sorry, we can only support updates for ReportBuilder 7.0 and higher.
You will need to upgrade to ReportBuilder 7.03 for this enhancement. For
more information on upgrading, please see the order page of our website...
http://www.digital-metaphors.com/Subpages/Order/Overview.html

--

rbuser

Hi Nico,

Being a problem, should not it have a correction for my version?

Thanks

Cristian L. Ferreira
Gerente de Desenvolvimento - Divis?o Servi?os
cristian@sumus.com.br
fone 11 6847.1838
www.sumus.com.br

nicocizik

Cristian,

Please do not cross post. We can only support the current version of
ReportBuilder. You are required to upgrade to RB 7.03 to receive this
enhancement.

--