[AccessD] Delete query will not run

Gustav Brock gustav at cactus.dk
Sat Sep 13 03:16:44 CDT 2003


Hi Chester

> I see a '.Net' in your sql string and it's probably not ready for prime
> time.  Microsoft is getting away from using dot net in their naming so it is 
> probably wise to do so as well.

> It's Friday.

> Hen

Yeah, that's dangerous.
Chester, try stripping it down to the essentials:

<SQL>

  DELETE *
  FROM
    [tbl DOI data by well]
  WHERE
    [tbl DOI data by well].WELLNOMST =
    [tbl Ft Stockton DOI Info].WELLNOMST;

</SQL>

/gustav

>>I am probably missing something real simple here. Thought I had done
>>this before. Keeps asking for parameter value. Anyway here is the sql.
>>
>>DELETE [tbl DOI data by well].WELLNOMST, [tbl DOI data by
>>well].WellName, [tbl DOI data by well].APINUMBER, [tbl DOI data by
>>well].Net, [tbl DOI data by well].Comment
>>FROM [tbl DOI data by well]
>>WHERE ((([tbl DOI data by well].WELLNOMST)=[tbl Ft Stockton DOI
>>Info].[WELLNOMST]));



More information about the AccessD mailing list