Re: SQL
From: Unicorn (unicorn_at_somewhere.com)
Date: 10/28/04
- Next message: Unicorn: "Re: Memo field Truncated"
- Previous message: Unicorn: "Re: Read Binary Fields Using VB6"
- In reply to: Jowsie: "SQL"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 28 Oct 2004 19:02:01 +0930
what drivers are you using to access the DBF file? The are errors with some
ODBC drivers which result in this error the first time they are initialised.
Trapping the error and trying again is the work around for this.
The fact that you error message mentions Paradox is a little weird, dbase is
not paradox. Perhaps you could post the connections string which is causing
the problem?
Matt
"Jowsie" <Jowsie@discussions.microsoft.com> wrote in message
news:C421EC99-E58E-4D7C-A801-C1EB8B242805@microsoft.com...
> I want to create a recordset from a dbf (dbase IV) file using SQL with a
> group by statement. Is this possible?
> I receive a strange error message, saying that (translated from dutch) the
> selected setting of the sorting sequence is not supported by the operating
> system, and that I need to change the settings for the CollatingSequence
for
> Paradox in the registry. I did this, following the instructions, but it
> didn't help, I continue to receive the same error message.
>
> Even without the group by statement, I get the error, using this SQL:
> SELECT [temp].FID FROM [temp];
>
> I need this group by statement, because I need to know the number of
unique
> values and the min and max value in the field FID.
>
> TIA,
> Jowsie
>
- Next message: Unicorn: "Re: Memo field Truncated"
- Previous message: Unicorn: "Re: Read Binary Fields Using VB6"
- In reply to: Jowsie: "SQL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
