Mike! Thanks a million!
I've tweaked it a tiny bit I had to add 'CLOSE all' after UPDATE TEMP SET FIELD_LEN = 60 WHERE FIELD_TYPE = "C"
I'll now change it slightly to make suit our needs. Cannot image it would be so simple!
Thanks and greetings from the London! ;-)
Kind Regards,
Thanks Olaf.
I've copied your program, run it on one of our databases and all I've got is a new table called 'curnew' with three fields iint, nnumber, ctext
What am I doing something wrong here.... ?
Thanks for your advice Olaf.
..but It's exactly opposite. We have a sortation program, which exports files to CSV only.
Once you save a CSV file as a .dbf it's changing all field widths to whatever it wants (i.e.e maximum length of characters in that field)
The problem is, I need to shuffle up...
Hi,
To begin with, I'm not an expert obviously but been using VFP for a while now.
At work, we have a various databased/tables coming to us. I need basically to write a simple program which would:
a) List all field names in a table (that's an easy part)
b) After listing these it would change...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.