SQL Explorer

[sqluser]

Hi

I am new to Progress but have a good understanding of SQL, I am trying to use the SQL Explorer tool in Progress 9.1D to query and update data. I can create a simple query but not filter anything without receiving errors. for ex

Select name, custnum,custid,company from pub.customer

Works just fine.

If I try:
Select name, custnum,custid,company from pub.customer
where custnum = 4

Works fine
However if I try
Select name, custnum,custid,company from pub.customer
where company = "FEDEX"
I get the following error message
SQL exception 1
SQL State 42S22
JDBC Progress Driver Column Not Found/Specified (7520)

Thanks ,

 

[StefGay]

Hi,

double quote (") are used to enclose fields name, use single quote (') around your varchar data.

Regards.

Stéphane.