DBase linked tables

[paulorj]

Hi,

Does anyone know how can I permanently remove records from a DBase linked table? (linked to an Access Database, of course).

I wrote code like "delete from table" and it didn't work. Records are marked for deletion but not physically deleted.

Thanks in advance

 

[JoeMiller]

Here's an example of an SQL delete statement. Hope it helps!

DELETE FROM MyTable WHERE MyCriteria = 'Insert Criteria'; Joe Miller
joe.miller@flotech.net

 

[paulorj]

Hi, Joe!

No, unfortunatelly, it didn't work.

The problem is caused by the linked tables. They're DBaseV tables. In that case, "DELETE FROM table", only marks records for deletion. It doesn't actually remove them. Deleted records are not sawn anymore, but they still exist. So, the file keeps growing. And this is bad to me. I'm working in an application which will transfer those files to a handheld and files can't be big, nor grow indefinatelly!

Anyways, I'm trying another approach, which is to call an Clipper app that will "pack" those files.

Thank you very much for your answer, anyway.

Greetings from Brazil.

Paulo

 

[Denis123]

If you can get your DbaseV to Foxpro, that will pack it also.
Then send it back.