Paradox, BDE and ODBC -- OH MY!

  • Thread starter Thread starter Curtis Justus
  • Start date Start date
C

Curtis Justus

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
 
Hi Curtis,

Curtis Justus said:
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.
Click to expand...

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.[/QUOTE]

Could it be that other codes have some trailing spaces?
Click to expand...
 
¤ 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 ~~~ [email protected]
Microsoft MVP (Visual Basic)
 
Back
Top