[AccessD] A2K and .Net

Do you know if my queries (stored procedures) that use say dateadd (ie
hard coded into the query) will fail?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
Hindman
Sent: 05 July 2005 13:45
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2K and .Net


VB.net and the Net framework include their own functionality, albeit at
some 
speed penalty in the case of the framework  ...rather than dateadd, you 
could use the TimeSpan parameter in VB.net's .Add() method.

William

----- Original Message ----- 
From: "Griffiths, Richard" <R.Griffiths at bury.gov.uk>
To: "AccessD" <accessd at databaseadvisors.com>
Sent: Tuesday, July 05, 2005 3:58 AM
Subject: [AccessD] A2K and .Net


Hi

I am developing a VB.net app with A2K BE.  I will deploy .net framework
which provides all the data access to the mdb file. My question is
this....Can I use in my Access queries code such as left, mid or
specifically dateadd. Am I right in thinking these functions are part of
VBA (which I do not intend to deploy) and so on a clean machine ie.
without any MS Access that queries using these functions will bomb out -
or will ADO.net/.net handle accordingly?

TIA

Richard

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com