Does Sql Server recognize Dsum, Dcount, Dmax, Dmin functions?...

[Effie Ladovrechis]

Does Sql Server understand these d-functions. If not, then what can I do.
Our code is written in VB and our database system is changing from Microsoft
Access to Sql Server. I use these functions throughout my queries and I'm
having trouble with them in Sql Server.

What can we do?

[Roy Harvey]

Effie,

>Does Sql Server understand these d-functions.

No.

>If not, then what can I do.

I don't know what Dsum and the other do, but the sound similar to the
SUM, COUNT, MAX and MIN functions that SQL Server does support. See
the Books On Line, Transact-SQL Reference, under F for Functions.

Roy

[Gianluca Hotz]

Effie Ladovrechis <ef...@gsi.ca> scritto nell'articolo
<uJSn3VT...@uppssnewspub04.moswest.msn.net>...
> Does Sql Server understand these d-functions. If not, then what can I
do.

> Our code is written in VB and our database system is changing from
Microsoft
> Access to Sql Server. I use these functions throughout my queries and
I'm
> having trouble with them in Sql Server.
>
> What can we do?
>

SQL Server does not have any Domain Aggregate Functions.
You should replace those functions with plain SQL.

For example a

DSUM("[Freight]", "Orders", "[ShipCountry] = 'UK'")

is converted to a plain

SELECT SUM(Freight) FROM Orders WHERE ShipCountry = 'UK'

Best regards,
--
Gianluca Hotz __
Technical Service Manager at Alphasys srl / \/ /
MCP Windows & MCP + MVP SQL Server / /\/ /
Currently working for Ekar spa \ \/ /\
http://ghotz.home.ml.org \__/\ \