Jump to content


Photo

Update Tables through DBUWin


  • Please log in to reply
3 replies to this topic

#1 JBerman

JBerman

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 17 January 2007 - 07:44 AM

Hey guys, neat forum you have here!

I am new to MOM as the company I just began working for has it in production. I wanted to use DBUWin to update the ord_date field in the CMS table so I made a copy of the table, updated the copy and then renamed the current CMS tables and replaced it with the copy. This did not work due to the index not matching, or so it seems, and I wanted to know how I should have done this. Should I have just made a copy of the live table and then went on updating the live table, replacing it with the backup if anything went wrong?

I do not have much experience with FoxPro databases and I was wondering if there are any other ways to get into the database that are known to be ok with the MOM? I tried to copy a table and create an ODBC connection to link it to access but it failed. I would love a way to run SQL commands instead of having to use DBUWin. Thanks in advance, looking forward to being a member of the forum!

Josh

#2 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

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

Posted 18 January 2007 - 04:53 AM

Hey guys, neat forum you have here!

I am new to MOM as the company I just began working for has it in production. I wanted to use DBUWin to update the ord_date field in the CMS table so I made a copy of the table, updated the copy and then renamed the current CMS tables and replaced it with the copy. This did not work due to the index not matching, or so it seems, and I wanted to know how I should have done this. Should I have just made a copy of the live table and then went on updating the live table, replacing it with the backup if anything went wrong?

I do not have much experience with FoxPro databases and I was wondering if there are any other ways to get into the database that are known to be ok with the MOM? I tried to copy a table and create an ODBC connection to link it to access but it failed. I would love a way to run SQL commands instead of having to use DBUWin. Thanks in advance, looking forward to being a member of the forum!

Josh



Hi Josh,

Welcome to MOMFAQ!! If you really want to replace the date in CMS you should do the following:

1. BACKUP MOMWIN folder.
2. Open DBUWIN
3. Open CMS
4. Select FILE/REPLACE FIELD
5. Select field you want to edit
6. Insert date in the following format without the quotes "{mm/dd/yyyy}"
7. Option to filter results that get updated. -- ideally you filter your results after step 3 to protect records that you don't want to update.

Cheers,

Videoflicks2004
David Narciso
Ecommerce Operations Manager CVS Inc

[email protected]

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 planetdj

planetdj

    Advanced Member

  • Members
  • PipPipPip
  • 109 posts
  • Location:Reno, NV, USA

Posted 25 January 2007 - 04:59 PM

Hey David,

You forgot a step:
8. Pray

;)
Chris Whybrew
PLANET DJ, INC
www.planetdj.com

#4 Warner

Warner

    Newbie

  • Members
  • Pip
  • 2 posts
  • Location:Canada

Posted 22 February 2007 - 01:05 PM

Hey guys, neat forum you have here!

I am new to MOM as the company I just began working for has it in production. I wanted to use DBUWin to update the ord_date field in the CMS table so I made a copy of the table, updated the copy and then renamed the current CMS tables and replaced it with the copy. This did not work due to the index not matching, or so it seems, and I wanted to know how I should have done this. Should I have just made a copy of the live table and then went on updating the live table, replacing it with the backup if anything went wrong?

I do not have much experience with FoxPro databases and I was wondering if there are any other ways to get into the database that are known to be ok with the MOM? I tried to copy a table and create an ODBC connection to link it to access but it failed. I would love a way to run SQL commands instead of having to use DBUWin. Thanks in advance, looking forward to being a member of the forum!

Josh


I'm using an ODBC connection and an Access database to query MOM tables. We use it for custom reporting, to create and print customized invoices with variable messaging based on customer and order data, and to update MOM tables based on specific criteria. I find Access easier and much more flexible than dbuwin, but I guess I'm biased because I know Access much better.

A funny thing is there was a small file in my momwin folder called .dbf (that's right, no file name, only extension) and the ODBC connection worked only after removing that file from the momwin folder. Try that, and if you still have problems, let me know.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users