just grasping at staws here because it has been a long long time.
Do you really want to delete all records? I think you would use:
DELETE * from work
(note *)
----- Original Message -----
From: "Terry Troxel" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 18, 2001 8:16 AM
Subject: Re: deleting records in a dbase III table
> Here is what is returned:
>
> Error Diagnostic Information
> ODBC Error Code = S1000 (General error)
>
> [Microsoft][ODBC dBase Driver] Could not delete from specified tables.
>
> SQL = "delete from work"
>
> Data Source = "test.dbf"
>
> SQL = "delete from work"
>
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (2:1) to (2:52).
>
>
>
> ----- Original Message -----
> From: Adkins, Randy <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Friday, May 18, 2001 6:38 AM
> Subject: RE: deleting records in a dbase III table
>
>
> > Is there an error returned?
> > If memory serves me right, DBaseIII also
> > uses a command called: PACK
> >
> > Not sure it is needed in this case however.
> >
> > -----Original Message-----
> > From: Terry Troxel [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, May 18, 2001 9:18 AM
> > To: CF-Talk
> > Subject: deleting records in a dbase III table
> >
> >
> > I am stumped as to why I cannot delete records from a dbase III dbf file
> > that is defined as an odbc source using the MS dbase 3 ODBC driver.
> > I can update, insert, but no delete.
> >
> > Any and all suggestions would be greatly appreciated.
> >
> > Terry
> >
> > The datasource is defined as "test.dbf" and pointing to the directory
> > the dbf files are located. The table I am using is work.dbf.
> >
> > I am using
> >
> > delete from work
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
