Help with S1000 error

[mkyzar]

I'm trying to delete a record from a dbaseIV table. I'm able to successfully write to it but not delete from it. I read a post from July, 2000, where the person ended up converting the table to an Access database but in my case that is not possible. Any suggestions?

Thanks for your help.

mkyzar

 

[tleish]

What's the exact error that you are getting and what version of ColdFusion Server are you running? - tleish

 

[mkyzar]

I'm running ColdFusion 4.5 and the exact message is
ODBC Error Code = S1000 (General error)


[Microsoft][ODBC dBase Driver] Could not delete from specified tables.

 

[tleish]

Can you post an example of you code? Are you using anything like cfgridupdate for the management? - tleish

 

[mkyzar]

<cfinclude template=&quot;fabtoolbar.cfm&quot;>

<cfif isdefined(&quot;form.yes&quot is &quot;Yes&quot;>

<cfquery name=&quot;fabdelete&quot; datasource=&quot;mimast&quot;>
SELECT *
FROM mimast
WHERE mimast.workorno = '#form.workorno#'
</cfquery>


<!---Display Success Message--->
<cfoutput query=&quot;fabdelete&quot;>
<h3>Work Order Number #form.workorno# has been deleted.</h3>
</cfoutput>

<cfquery name=&quot;deletefab&quot; datasource=&quot;mimast&quot;>
DELETE
FROM mimast
WHERE mimast.workorno = '#form.workorno#'
</cfquery>
<cfelse>
<cfoutput><h3>Work Order Number #form.workorno# not deleted.</h3></cfoutput>
</cfif>

This is all I'm doing on the delete page. The first query I stuck in there to make sure that it was finding the correct record and the second, of course, is doing the deleting. It finds the record successfully, just won't delete it.

mkyzar