Thanks for the quite reply. Our scope of the new application is very limited. We do not have plan to rewrite/update these other foxpro applications at this moment.
Sounds to me that this task is not doable, it requires the other foxpro apps to be modified. Is it true?
Can DTS in SQL 2K converts SQL data to dbf file that is compatible to Foxpro 2.6 DOS version? Also can the DTS converts data to Foxpro index file (.cdx) and memo field (.fpt).
If not, what are the alternatives? Converting to these files is necessary because the current dbf interfaces to few...
Thanks for the sugguestion donutman. Our company policy has many/complex rules when it comes to the timekeeping/payroll system. Our current system also tie with budget related information as well. IMO, it requires a lot of work even if we could purchase an off-the shelf package to use.
Are...
Currently I am developing a timekeeping system that requires it to display 15-increment time span for each employee in his/her timesheet/reports. This is what I've done in the SQL Server DB for looking up/display individual start/end time...
TimeClock Lookup table
Regular Decimal...
I have created a temp table (#TempTable) as follow...
DATE HOURS TYPE TIME_BEG TIME_END
Sep 1 2004 12:00AM 5.0 P 12.0 17.0
Sep 6 2004 12:00AM 2.0 W 0.0 0.0
Sep 6 2004 12:00AM 2.0 HP 17.0 19.0
Sep 6 2004 12:00AM 1.0 HP 19.0 20.0
Sep 6 2004 12:00AM 3.0 HP 20.0 23.0
Sep...
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.