7 replies to this topic

[ViarexJonas]

Is it possible to select only the email field in the CUST table when using dbuwin and filtering the records?

[dseibold]

If you mean, Can you filter the records based upon the email field in dbuwin? the answer is yes.
I believe the syntax is

email<>""

If you want to list the records that possess an email address.

OR

email="[email protected]"

if you want to see if your email address is in your database.

[ViarexJonas]

Actually what I'm trying to do is just get the email field instead of all the fields from the Cust table.

[ViarexJonas]

Hoping to bump this and get an answer to this question please.

[dseibold]

What are you wanting to accomplish? Do you want to export a file? What version of MOM are you running?

I'm currently using MOM 7 XL and no longer use or have dbuwin so I am trying to help you from memory of the 'old' days.

[ViarexJonas]

I'm currently running v6.2 and using DBUWin.exe to query the CUST table. I would like to export all the email suppressions. Here's the query statement I use to gather all the email suppressions: LIKE("*@*.*",Cust.email) AND Cust.noemail = .T.

The problem is that it is pulling all the fields.

[dseibold]

I'm currently running v6.2 and using DBUWin.exe to query the CUST table. I would like to export all the email suppressions. Here's the query statement I use to gather all the email suppressions: LIKE("*@*.*",Cust.email) AND Cust.noemail = .T.

The problem is that it is pulling all the fields.

I always used MS Access rather than dbuwin with MOM 5.4. Unfortunately you can't do that in 6.2. I never bothered to learn much of dbuwin other than how to find the record I wanted to look at.

However, look for a SELECT command to select the email field. It's probably set currently for all fields.

As a last resort, you could export your data to excel and then delete the columns you don't need.
Sorry I can't be any more help.

[ViarexJonas]

Appreciate the help David! Thanks again!