In-Reply-To: [EMAIL PROTECTED]
Larry - in case you're interested, I found a workaround that works. Code
below.
If anyone can suggest any way in which this might be improved, I'd be
grateful. If it helps anyone with a similar problem, great!
CODE:
CFSEARCH
name = "GetResults"
In-Reply-To: [EMAIL PROTECTED]
Further on this subject
This is definitely MS shooting itself in the foot - I tried
the exact same query via ODBC from Access (CF not even open
or on) using the self-same VFP DSN and received the same error
message.
Now what?
Terry Riley
Riley Varea
No, sorry, I never reported it.
If you're serious about the COM option, Rick Strahl wrote a book on using vfp6 as a
com server for internet applications - "Internet Applications with Visual FoxPro 6.0"
that you might look into.
Good luck! ;-)
Larry
[EMAIL PROTECTED] 04/29/00 06:40AM
In-Reply-To: [EMAIL PROTECTED]
Larry, did you ever report this bug to MS?
I'll have to consider the COM option
Cheers
Terry Riley
Riley Varea Associates, London, UK
--- Original message
I had the same problem - 25 items was as far as I could go.
If you're comfortable with VFP, you
Just had a very strange thing happen (repeatable):
Using a Visual FoxPro free table (delegate.dbf), CF4.01 and
the latest MDAC2.1 drivers, asking CFAS to perform:
SELECT * from delegate
where delid in
(101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,1
a bug with seniority."
--
-Original Message-
From: Terry Riley [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 28, 2000 10:22 AM
To: [EMAIL PROTECTED]
Subject: CF VFP ODBC
Just had a very strange thing happen (repeatable):
Using a Visual FoxPro
In-Reply-To: 009c01bfb11f$e7da2900$6701a8c0@CINEHUB
Provided there are no more than 24 numbers in each 'or
delid in ()', irrespective of their individual sizes ( ie
single, double or triple integer), I get the data returned. As
said earlier, stick in a 25th number and it falls over even
7 matches
Mail list logo