markw714 Posted December 18, 2013 Author Posted December 18, 2013 Ok. New problem. Everything worked flawlessly. I pulled the most recent versions of these tables to get the most recent emails and ran into an issue. If I change the general field to memo wih hex editor, the whole column goes missing. I DID create a backup of the .dbfs and deleted the gen fields so I could export to excel. Then I deleted the backups and brought in fresh versions. Now every time I hex edit a table with the gen field (and they ARE in the fresh tables), it deletes the whole column of gen fields. Pretty urgent..
Danp2 Posted December 18, 2013 Posted December 18, 2013 You haven't provided enough information for me to even make an educated guess. Only suggestion would be to review your hex editing steps to make sure that you are following the correct procedure. Latest Webdriver UDF Release Webdriver Wiki FAQs
markw714 Posted December 18, 2013 Author Posted December 18, 2013 Like before, I just opened it and changed the G to M and saved. I think it might have to do with deleting the columns on the first dbfs I used to make a new spreadsheet (where it asks do you want to make structural changes permanent), but I've done that before and just replaced them with fresh tables. I bring in the dbf, open with vfp, the gen fields are there. I run hex edit, change G to M, save as. Open with VFP again, column is GONE!
markw714 Posted December 18, 2013 Author Posted December 18, 2013 Tried pulling the entire database again AND got a different hex editor. Same thing. I don't get it. This didn't happen before.
Danp2 Posted December 19, 2013 Posted December 19, 2013 How are you determining that the field has disappeared? Is it there is you issue BROWSE without the LAST clause? Do you see it if you issue the MODIFY STRUCTURE command? Latest Webdriver UDF Release Webdriver Wiki FAQs
markw714 Posted December 19, 2013 Author Posted December 19, 2013 After I edit the fields I open with dbf view and browse. Whole column gone. It crashes if I try to browse with VFP.
Danp2 Posted December 19, 2013 Posted December 19, 2013 Can you send me a copy of the table with several records included? Latest Webdriver UDF Release Webdriver Wiki FAQs
markw714 Posted December 19, 2013 Author Posted December 19, 2013 I can't. They contain confidential information. I'm 99% sure it's some small issue I'm missing. It's just weird that it's removing them when I convert the fields, even on untouched tables.
Danp2 Posted December 19, 2013 Posted December 19, 2013 Ok... use the original table in VFP and issue the command COPY STRUCTURE TO NewTable. This will create a new table with the same structure, which you can then post. Latest Webdriver UDF Release Webdriver Wiki FAQs
markw714 Posted December 20, 2013 Author Posted December 20, 2013 I am not permitted to upload this type of file.
Danp2 Posted December 20, 2013 Posted December 20, 2013 Check your PM. Latest Webdriver UDF Release Webdriver Wiki FAQs
markw714 Posted January 17, 2014 Author Posted January 17, 2014 got it working. pulled fresh set of every table from server, hexedit the email fields, ran your code, exporting now. Going to remove the email field AFTER export to get my spreadsheet. Thanks for the help.
Danp2 Posted January 17, 2014 Posted January 17, 2014 YW. Glad you finally got it figured out! Latest Webdriver UDF Release Webdriver Wiki FAQs
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now