>I don't understand CDX files. What causes them to get so huge? I have an app that has a CDX file over 1.2 billion bytes big. I have other apps that don't have any CDX files at all.
>
>This particular CDX file just keeps getting bigger and bigger, and it gets bigger whenever I run the app. How is that possible?
>It takes forever to make a backup of that folder just because of that one file.
>
>I don't understand how it can get bigger by just running the program...even without having made any program changes...just running it and making no file changes and then closing it..
>
>Rich Murillo

check DELETE TAG.

CREATE TABLE TEST (tx1 C(120))
INSERT INTO TEST VALUES ('')
FOR K=1 TO 14
	INSERT INTO TEST SELECT * FROM TEST
NEXT
INDEX ON 1 TAG tag0	&& comment this and retest
INDEX ON tx1 TAG tag1
SET COMPATIBLE DB4
WAIT WINDOW FSIZE(CDX(1)) NOWAIT
FOR K=1 TO 100
	FLUSH IN (SELECT(0))
	DELETE TAG tag1
	INDEX ON tx1 TAG tag1
	WAIT WINDOW TRANSFORM(FSIZE(CDX(1)),"@R 999 999 999 999") NOWAIT
NEXT