I am using nt4 cf 4.01
Microsoft][ODBC dBase Driver] Could not delete from specified tables.
Here is the error that is thrown.
You can see my sql call in it as well. I am trying to delete all the
records.
I have made a workaround by creating a blank dbf and dbt and then
deleting the files and copying the blanks as the originals to start over.
But I really would like to be able to delete or know why I can't. I too
have been working with dbf files for awhile.
Terry
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: C Frederic Valone <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Friday, May 18, 2001 6:58 AM
Subject: Re: deleting records in a dbase III table
> Are you getting an error? If so what is it please post the code and I'll
take a look... I have worked a bit with dbf files and may
> be able to help. Also helpfull would be the os and cf version you are
using.
> Thanks,
> Frederic
> Terry Troxel wrote:
> >
> > 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
