SQL Equivalent for Progress Statement

[dyelar]

I've tried about 3 dozen different combinations to translate the following statement into SQL.

output to _user.d.

for each trading._user where trading._user._userid = "itdba":
export trading._user .

I've been able to do the following to get a user listing, but I can't figure out how to specify the userid.

select * from pub."_user";

I get a variety of errors when I try different where clauses, but I've not been able to get any different combination of referencing pub or trading to work out the appropriate reference userid. I can provide error messages, if needed, but can anyone provide me some pointers?

Thank you for any help provided.


This is under Progress 10.1C, if that proves to be important.

 

[tamhas]

Did you quote the field and table names?

i.e., PUB."_user"."_userid" = 'itdba'

 

[dyelar]

Yes, I was, but based on your example, I see the problem I was having. I was double quoting the string itdba rather than single quoting it. It now works. Thank you!