Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Paradox and ODBC

Status
Not open for further replies.

Lionel

Programmer
Dec 15, 2000
5
FR
I try access a PDX tabel using ODBC .
Work well but my table contain a field like :
Number Transaction

So as i do : SELECT TABLE."Number Transaction" FROM TABLE

it dunot work, says : FIELD "Number transaction" not found


Ne helppp :>>
 
Try SELECT [TABLE.Number Transaction] FROM TABLE

or

SELECT TABLE.[Number Transaction] FROM TABLE

What ODBC drivers are you using? I need something with better performance than Microsoft.

mhanegan@selectron.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top