Paradox, BDE and ODBC -- OH MY!

Hi!

If this is not the place to post this, I apologize in advance...

I am connecting to a Paradox 4.X database using ODBC. I have the latest
version of MDAC loaded and have BDE 5.11 loaded.

When I run the following query:

select * from mytable

I get the following results back (sorry for any bad tabbing):

Code Sub Code Value
001 A 1
001 A 2
001 A 3
...

However, when I run this query:

select * from mytable where [Code] = '001'

I get only the first row back.

Any ideas?

Thanks in advance,
cj

Miha
Wed Jan 07 11:23:55 CST 2004

Hi Curtis,

"Curtis Justus" <senorcj@nospam.ser.it.is.com> wrote in message
news:ujW5AsT1DHA.560@TK2MSFTNGP11.phx.gbl...
> Hi!
>
> If this is not the place to post this, I apologize in advance...
>
> I am connecting to a Paradox 4.X database using ODBC. I have the latest
> version of MDAC loaded and have BDE 5.11 loaded.

Gee man, what do you do with BDE ? ;-)

> When I run the following query:
>
> select * from mytable
>
> I get the following results back (sorry for any bad tabbing):
>
> Code Sub Code Value
> 001 A 1
> 001 A 2
> 001 A 3
> ...
>
> However, when I run this query:
>
> select * from mytable where [Code] = '001'
>
> I get only the first row back.

Could it be that other codes have some trailing spaces?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Paul
Wed Jan 07 13:11:23 CST 2004

On Wed, 7 Jan 2004 10:26:27 -0600, "Curtis Justus" <senorcj@nospam.ser.it.is.com> wrote:

¤ Hi!
¤
¤ If this is not the place to post this, I apologize in advance...
¤
¤ I am connecting to a Paradox 4.X database using ODBC. I have the latest
¤ version of MDAC loaded and have BDE 5.11 loaded.
¤
¤ When I run the following query:
¤
¤ select * from mytable
¤
¤ I get the following results back (sorry for any bad tabbing):
¤
¤ Code Sub Code Value
¤ 001 A 1
¤ 001 A 2
¤ 001 A 3
¤ ...
¤
¤ However, when I run this query:
¤
¤ select * from mytable where [Code] = '001'
¤
¤ I get only the first row back.
¤
¤ Any ideas?

I personally don't care much for the ODBC driver for Paradox. Is there any difference if you use Jet
OLEDB and the Paradox ISAM? Below is a connection string example:

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=d:\My Documents\Paradox;Extended Properties=Paradox
5.x;"


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

adamz5
Tue Jan 13 09:13:06 CST 2004

Donwload the latest odbc drivers for paradox
http://www.datadirect.com this should solve it