Jump to content


Photo

Filtering DBUWIN table


  • Please log in to reply
3 replies to this topic

#1 PURE-DNJ

PURE-DNJ

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 14 December 2006 - 01:51 AM

Hi, I am trying to filter my customer table (cust.dbf) against a table i created called mycust.dbf.

I tried the following equation but it only filters with one result.

cust.custnum = mycust.custnum

can anyone advise the correct equation?

Darren

#2 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 14 December 2006 - 05:04 AM

Hi, I am trying to filter my customer table (cust.dbf) against a table i created called mycust.dbf.

I tried the following equation but it only filters with one result.

cust.custnum = mycust.custnum

can anyone advise the correct equation?

Darren


Hi Darren,

Once you create the Mycust database you need to use DBUWIN to create an index.

1. Open your new database in DBUWIN
2. Select TABLE/CREATE INDEX
3. Type the following exactly: "CUSTNUM"

Now open R & R report writer and create a new report with CUST.dbf related to MYCUST via CUSTNUM index.

I have a sample report to attach to this post but the forum generated the following error:

Posted Image Upload failed. Please ask the administrator to ensure the uploads directory is writeable
David Narciso
Ecommerce Operations Manager CVS Inc

dnarciso@cvsinc.ca

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.

#3 PURE-DNJ

PURE-DNJ

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 14 December 2006 - 05:24 AM

Hi Darren,

Once you create the Mycust database you need to use DBUWIN to create an index.

1. Open your new database in DBUWIN
2. Select TABLE/CREATE INDEX
3. Type the following exactly: "CUSTNUM"

Now open R & R report writer and create a new report with CUST.dbf related to MYCUST via CUSTNUM index.

I have a sample report to attach to this post but the forum generated the following error:

Posted Image Upload failed. Please ask the administrator to ensure the uploads directory is writeable

Oh i see,

We dont have R&R writer and was hoping to do this directly in DBUWIN, i am able to create an index ect, but really wanted to see if I could filter the cust table based on the mycust table. Do you think this is possible?

#4 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 14 December 2006 - 06:31 PM

Oh i see,

We dont have R&R writer and was hoping to do this directly in DBUWIN, i am able to create an index ect, but really wanted to see if I could filter the cust table based on the mycust table. Do you think this is possible?


Hello,

Perhaps if you tell me more about your goal with the filter function?

Exactly what is it that you want to compare between the two tables?

The easiest tool for a newbie is RR . There are a lot of reports that will make the purchase worth while.

Cheers,

Videoflicks2004
David Narciso
Ecommerce Operations Manager CVS Inc

dnarciso@cvsinc.ca

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users