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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using VFP apps with migrated databases to SQL Server
I have this multiuser VFP 9 that has grown uncultivated for the last decade, and the idea for long time has been to migrate all the data to SQL Server. After some time normalizing the old database, the migration is complete, but there is this tiny thing that is resisting (and this probably is...- cmonroy
- Thread
- Replies: 12
- Forum: Microsoft: FoxPro
-
Is possible to add a timestamp column to a table?
Excellent! Thank you for your input. What I was missing was setting the table's default value for this particular use: ALTER TABLE <ANYTABLE> [ADD/ALTER] <DATETIMEFIELD> DATETIME NOT NULL DEFAULT DATETIME().- cmonroy
- Post #4
- Forum: Microsoft: FoxPro
-
Is possible to add a timestamp column to a table?
In other platforms, like SQL Server, you can create a table with automatic timestamp, like this: create table sample (what integer, where char(8), when datetime default current_timestamp) Thus, when you insert data in the tabke, like: insert into sample (what, where) values (1, "Here") The...- cmonroy
- Thread
- Replies: 3
- Forum: Microsoft: FoxPro
