Jump to content


Photo

Select certain fields on CUST table using dbuwin


  • Please log in to reply
7 replies to this topic

#1 ViarexJonas

ViarexJonas

    Member

  • Members
  • PipPip
  • 10 posts

Posted 14 April 2010 - 08:39 AM

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

#2 dseibold

dseibold

    Advanced Member

  • Moderators
  • PipPipPip
  • 137 posts
  • Gender:Male
  • Location:Stockton, CA

Posted 14 April 2010 - 11:11 AM

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="yourname@domain.com"

if you want to see if your email address is in your database.
David Seibold
Wild Horses, Inc.
Operations Manager

#3 ViarexJonas

ViarexJonas

    Member

  • Members
  • PipPip
  • 10 posts

Posted 14 April 2010 - 11:14 AM

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

#4 ViarexJonas

ViarexJonas

    Member

  • Members
  • PipPip
  • 10 posts

Posted 03 June 2010 - 08:34 AM

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

#5 dseibold

dseibold

    Advanced Member

  • Moderators
  • PipPipPip
  • 137 posts
  • Gender:Male
  • Location:Stockton, CA

Posted 03 June 2010 - 08:43 AM

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.
David Seibold
Wild Horses, Inc.
Operations Manager

#6 ViarexJonas

ViarexJonas

    Member

  • Members
  • PipPip
  • 10 posts

Posted 03 June 2010 - 08:50 AM

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.

#7 dseibold

dseibold

    Advanced Member

  • Moderators
  • PipPipPip
  • 137 posts
  • Gender:Male
  • Location:Stockton, CA

Posted 03 June 2010 - 11:52 AM

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.
David Seibold
Wild Horses, Inc.
Operations Manager

#8 ViarexJonas

ViarexJonas

    Member

  • Members
  • PipPip
  • 10 posts

Posted 03 June 2010 - 12:57 PM

Appreciate the help David! Thanks again!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users