Select Query Column Problem

[Strider]

Hello again,

in the progress database i have been given there are lots of column names containing a dash in the ie. prod-desc

So my query will look like:
SELECT prod-desc FROM Pub.Products

And i get an error:
Column not found/specified (7520)

I have tried putting [] around the column-name as you would do in access but that dont work.

Is there any specific characters to put around the column name so it will take it as a whole?

Cheers

 

[Lee Curzon]

Hello again,

in the progress database i have been given there are lots of column names containing a dash in the ie. prod-desc

So my query will look like:
SELECT prod-desc FROM Pub.Products

Try :
SELECT "prod-desc" FROM Pub.Products

 

[Strider]

cool ya that works inside my VB.Net code

it showed up nothing inside Progress SQL Explorer

 

[Lee Curzon]

it showed up nothing inside Progress SQL Explorer

At least you can get it to connect.

You're one up on me.

 

[Strider]

ya it takes a while to get everything working in progress, well especially if your like learning as you go....