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
