I use vfp8 and winxp.
On a regular basis I have to append records from a fox 2.6 table to a table
in a vfp8 database.
The code below works, but it gives me two windows the user have to deal
with. A 'table update warning' window and a 'select code page' window.
As far as I gather from previous postings the first window no one knows how
to get rid of, but what about the second?
Sincerely,
Jan Nordgreen
The code:
* oapp.cdatfolpat is the folder for the database and cfilepath is the fox
2.6 table
caux = oapp.cdatfolpat + 'newathlt.dbf'
COPY FILE (cfilepath) TO (caux)
IF INDBC('newathlt', 'TABLE') then
REMOVE TABLE 'newathlt'
endif
ADD TABLE 'newathlt'
* append the new records to the sdstud.dbf table
USE newathlt IN 0 EXCLUSIVE
SELECT sdstud
INSERT INTO sdstud (st_house, st_sex, st_studid, st_class, st_name) ;
SELECT st_house, st_sex, st_studid, st_class, st_name FROM newathlt