Re: problem to SELECT using Microsoft Access (posted again, because of posting error)


Let's consider code as this:

with ADOQuery1 do begin
Sql.Text:=
'select Column2 ' +
'from Table ' +
'where Column1 = '#39'THREAT_EVENTS'#39;

Open;

// Exception: Parameter Column1 has no default value;

I tested that query. I get an error "syntax error in from clause" which is
becuase Table is a reserved word
changing that to [Table] fixes that error

Using Access database with Jet 4.0 Oledb provider
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: probably not as complex as Im thinking...
    ... No, sorry, I get a syntax error in Group By clause here, and I tried not ... >> OK, I have 4 queries, the SQL view of which I have below, with brief ... Please understand that I use the Query Design Grid to make ...
    (microsoft.public.access.queries)
  • Re: GROUP BY clause not working
    ... using PEAR and I'm getting DB Error: Syntax Error when using the GROUP ... you cannot use columns in a query containing a GROUP BY ... clause, unless they are part of the clause or an aggregate function. ... SELECT LocationID FROM HardwareInstallationsSummary WHERE LocationID = ...
    (comp.lang.php)
  • Re: GROUP BY clause not working
    ... using PEAR and I'm getting DB Error: Syntax Error when using the GROUP BY clause. ... Here's my query: ... SELECT * FROM HardwareInstallationsSummary WHERE LocationID = $loc_ID GROUP BY EquipmentTypeID ...
    (comp.lang.php)
  • Re: VB MS Access Syntax error in FROM clause Error
    ... in a query are reserved words. ... "VB MS Access Syntax error in FROM clause" wrote in ... >FROM clause." ...
    (microsoft.public.data.ado)
  • RE: Any good T-SQL quick reference recommended?
    ... The full syntax of the SELECT ... SELECT Clause ... Specifies the columns to be returned by the query. ... Specifies that duplicate rows can appear in the result set. ...
    (microsoft.public.sqlserver.programming)