How many guesses do you want? ;-)
At 08:49 AM 12/29/00 -0800, you wrote:
>Do they send out some replies that
>they hope DON'T help?
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600
> This is a documented, well-known MDAC bug with Win2K SP1.
> Dave Watts
OK, I'll stop posting erroneous replies (for a while).
-David
P.S. Why do people use HTH at all? Do they send out some replies that
they hope DON'T help?
~ Paid Sponsorship ~
Get Your Own Dedicated
Chris,
This works for me, using CF Express 4.0 and with an ODBC MS Access
datasource:
select FirstName+' '+LastName as Name
from...
I was thinking of an insert statement when I wrote that the value must
match the db field datatype. Sorry about that.
-David
On Fri, 29 Dec 2000 09:39:44 -050
> I'm setting up a new computer (Win 2K Professional) and some
> queries that work on other computers do not work on this one.
> The problem queries involve concatenation or setting constants
> in the query. The problem happens with Access 97 and 2000
> databases. Running CF 4.5.1 Professional
> 1. 'X' is a string, 0 is a number. The value you use must match Field1's
> datatype.
Field1 is a field I'm defining in the query. It does not exist in the
database.
> 2. In Access, both the "+" and "&" are concatenation operators; they
> differ in that the "+" will *add* values if either oper
1. 'X' is a string, 0 is a number. The value you use must match Field1's
datatype.
2. In Access, both the "+" and "&" are concatenation operators; they
differ in that the "+" will *add* values if either operand is numeric.
Perhaps ODBC uses only the "+" for concatenation?
-David
On Thu, 28 Dec
6 matches
Mail list logo