Deleting records via sql

Article View: borland.public.vdbase.data.sql

Article #1562

Back to borland.public.vdbase.data.sql Previous Next

#1562

From: J�rgen Ahorn
Date: Fri, 05 Dec 1997 00:00

17 lines
854 bytes

Hi there,
can anyone help me with following problem:
I want to delete all records from a dBASE IV table via sql under Visual
Basic 3.0.
For example:
Database.Execute ("DELETE FROM table")

Now, when I fire this statement, all records are deleted, but not
physically.
I read in the handbook, that I need the command "PACK" or "ZAP". But
how do I fire it via sql?

Thanks.

J.Ahorn
email: J.Ahorn@t-online.de

Technical Details

Message-ID: <669cv1$1nl2@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,8ca21fe658d487a9,start
X-Google-Attributes: gidff5a1,public
From: "J�rgen Ahorn" <J.Ahorn@t-online.de>
Subject: Deleting records via sql
Date: 1997/12/05
Message-ID: <669cv1$1nl2@forums.borland.com>
X-Deja-AN: 295514153
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: Software-Entwicklung
Newsgroups: borland.public.vdbase.data.sql