3 replies to this topic

[JBerman]

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

[Videoflicks2004]

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

[planetdj]

Hey David,

You forgot a step:
8. Pray

[Warner]

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.