Column not found/specified 7520

[zacdesai]

Hi All ,

Can you please provide some insight to this problem.
We finally got our odbc connection working. Thanks to Caper and gang for all your help.

Im receiving an error from the reporting app when I try to run queries, Ive tried various formats but this is basically my query :
SELECT PUB."vmsold" FROM PUB."vhmast" WHERE PUB."vmsold" = FALSE .
I either receive a syntax error or currently this error - Column not found or specified 7520 .

Appreciate your help.
Zakaria

 

[Casper]

How about:

select vmsold from pub.vhmast where vmsold = 0;

or

select pub.vhmast.vmsold from pub.vmhast where pub.vmhast.vmsold = 0;

HTH,

Casper.

 

[zacdesai]

Hi Casper ,

Thanks for the suggestion. No joy though - I get a syntax error.


Regards
Zak

 

[vinod_home]

start with a simple query.

select * from PUB."vhmast";

 

[Casper]

Hi Casper ,

Thanks for the suggestion. No joy though - I get a syntax error.


Regards
Zak

Works for me though. Look at the field names: in your example vmsold should be a field of table vmhast. Is that the case?

Casper.

 

[zacdesai]

Thanks Vinod ,

I actually tried it that way and worked my way up. Its now working.

Sorry , In my 1st post, I mis-spelled the vm-sold field as vmsold.

The working query is :

Select "vm-sold" from pub."vhmast" where "vm-sold" = 0 :blush:


Thanks everyone.
Zak