Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VFP6.0 How to set up dafualts of a column in fox pro
- Thread starter 2969
- Start date
RickSchummer
Programmer
I am a VFP developer (not VB) so you will have to take my close code and make it better <g>.
You will need exclusive use of the database table you are altering the column default values.
(So, how many VFP developers are going, crud, I did not think anyone could alter my structures unless they had a copy of VFP?)
_RAS
VFP MVP
Code:
dim oVFP
oVFP = CREATEOBJECT "VisualFoxPro.Application"
oVFP.DoCmd("open database D:\FullPathHere\MyData.DBC")
oVFP.DoCmd("ALTER TABLE MyTable ALTER COLUMN MyColumn SET DEFAULT 'OH'")
oVFP.DoCmd("use in MyTable")You will need exclusive use of the database table you are altering the column default values.
(So, how many VFP developers are going, crud, I did not think anyone could alter my structures unless they had a copy of VFP?)
_RAS
VFP MVP
)
Mike Lewis
Programmer
Rick and Rick,
If they don't have a copy of VFP, could they not do the same thing via ODBC? In other words, get an ODBC connection to a VFP database and send an ALTER TABLE command?
Mike
Mike Lewis
Edinburgh, Scotland
My Visual Foxpro web site: My Crystal Reports web site:
If they don't have a copy of VFP, could they not do the same thing via ODBC? In other words, get an ODBC connection to a VFP database and send an ALTER TABLE command?
Mike
Mike Lewis
Edinburgh, Scotland
My Visual Foxpro web site: My Crystal Reports web site:
Mike,
I believe you can. I've pointed many people to - "How To Pack a Table Through the Visual FoxPro ODBC Driver" and the ALTER table would seem to be much different.
Rick
I believe you can. I've pointed many people to - "How To Pack a Table Through the Visual FoxPro ODBC Driver" and the ALTER table would seem to be much different.
Rick
Mike Lewis
Programmer
Rick,
... and the ALTER table would seem to be much different.
True, but come to think of it, they could presumably just send an ALTER TABLE command via the VB equivalent of SQLEXEC(), assuming VB has such a facility.
Mike
Mike Lewis
Edinburgh, Scotland
My Visual Foxpro web site: My Crystal Reports web site:
... and the ALTER table would seem to be much different.
True, but come to think of it, they could presumably just send an ALTER TABLE command via the VB equivalent of SQLEXEC(), assuming VB has such a facility.
Mike
Mike Lewis
Edinburgh, Scotland
My Visual Foxpro web site: My Crystal Reports web site:
RickSchummer
Programmer
VB uses ADO which can execute SQL commands, so this should be very possible as long as VFP's ODBC or OLE DB supports the process.
It might be cheaper just to buy a copy of VFP and use the Table Designer, or hire someone who has it and have them modify the default values.
_RAS
VFP MVP
It might be cheaper just to buy a copy of VFP and use the Table Designer, or hire someone who has it and have them modify the default values.
_RAS
VFP MVP
- Status
Similar threads
- Locked
- Question