>There is a certian Accounting product out there, written in VFP5.0. That sells the product based on datbase size. You can buy half GIG, 1 GIG , ect. How can you programatically put a size limit on datafiles?
The code snippet below is not accurate, but the concepts are correct.
lcFile = c:\temp\junk.dbf\
If FILE(lcFile)
Set compatible on
lnSize = FSIZE("myTable")
do case
case lnSize / 10000000 = 1
? '1 gig'
case lnSize / 10000000 = .5
....
endcase
Endif