[AccessD] ORDER BY BUG using Date format AARHG

DWUTKA at marlow.com DWUTKA at marlow.com
Fri Apr 2 17:07:42 CST 2004


Good point.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
McLachlan
Sent: Friday, April 02, 2004 4:57 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] ORDER BY BUG using Date format AARHG


On 2 Apr 2004 at 9:45, DWUTKA at marlow.com wrote:

> Because Format() returns a string, 

To be strictly correct, Format() returns a variant of type String.
Format$() returns a string.

Most of the string manipulation functions have two varieties , with 
and without a trailing "$".  Leaving the "$" off returns a variant 
with the additional overhead and potential problems of using that 
data type.  It's a good idea use the specific version wherever 
possible.







 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.



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



More information about the AccessD mailing list