GOVMATE
Registered User.
- Local time
- Today, 10:58
- Joined
- Aug 10, 2007
- Messages
- 71
Hello,
I'm writing a query that will append to a table and also convert it dbase IV. The problem that I'm having is controlling the actual field width size when the new table is created as dbase IV for foxpro. It creates every field width size as 256 and I'd like to know to how controll the actual width to make them much smaller. Any help will be greatly appreciated!!!!!!!!!!!!
Here's a sample of the code I'm using below:
SELECT appl, status, branch, acctno, custno, certno, cif, taxid, taxidcd, sortname, name1, name2, addr1, addr2, addr3, city, state, zip, country, fitype, ficlass, fdictype, glcode, class, iracode, ownercd, jointcd, municipal, currbal, accrint, perdiem, intpytd, intwhytd, resrvbal, rate, origdate, term, insider, officer, brokcode, loanacct, holdcode, holdamt INTO NwAcctDeps IN '.'[dBASE IV;]
FROM tbk_CustomerDeps;
I'm writing a query that will append to a table and also convert it dbase IV. The problem that I'm having is controlling the actual field width size when the new table is created as dbase IV for foxpro. It creates every field width size as 256 and I'd like to know to how controll the actual width to make them much smaller. Any help will be greatly appreciated!!!!!!!!!!!!
Here's a sample of the code I'm using below:
SELECT appl, status, branch, acctno, custno, certno, cif, taxid, taxidcd, sortname, name1, name2, addr1, addr2, addr3, city, state, zip, country, fitype, ficlass, fdictype, glcode, class, iracode, ownercd, jointcd, municipal, currbal, accrint, perdiem, intpytd, intwhytd, resrvbal, rate, origdate, term, insider, officer, brokcode, loanacct, holdcode, holdamt INTO NwAcctDeps IN '.'[dBASE IV;]
FROM tbk_CustomerDeps;