Syntax error in from clause

From: George Kvasha (gkhokie_at_hotmail.com)
Date: 10/30/04 

Date: Sat, 30 Oct 2004 14:47:42 -0400

What would cause a "syntax error in from clause" from the statement DELETE
FROM TABLENAME? I'm using an Access table in D6 and trying delete all
records in TABLENAME. The SQL is in the commandtext property of ADOCommand

Relevant Pages

  • RE: Convert Coordinates
    ... "Seth Schwarm" wrote: ... FROM TableName ... This returns "Syntax error in FROM clause". ...
    (microsoft.public.access.queries)
  • error in sql
    ... Can someone please help me with this syntax error. ... Declare @Tablename varchar ... Declare @sSQL varchar ...
    (microsoft.public.sqlserver.dts)
  • Re: Limitation using IN in WHERE
    ... > where fieldname and tablename are the field of the said table. ... I have over 60 funds in the list. ... >> If I just use a few funds in the IN clause it runs fine, ...
    (microsoft.public.access.queries)
  • Re: SQL works, but wont save
    ... in a subquery that is used in the FROM ... clause WITHIN an outer subquery used in a FROM ... One possible solution (assuming "TableName" ... FROM as X INNER JOIN ...
    (microsoft.public.access.queries)
  • RE: Latest Dates
    ... If you would like to select the latest date, there may need no Group By clause. ... Field2 As From TableName ... This posting is provided "as is" with no warranties and confers no rights. ...
    (microsoft.public.access.queries)