Re: Tadoquery problem

i think you need space after the "="

"jacques" <admin@xxxxxxxxxxxxxxxxx> wrote in message
news:424eac81$1@xxxxxxxxxxxxxxxxxxxxxxxxx
>
> I get a "Syntax error near FROM clause" when i try to execute the
following
> during runtime:
> query1.sql.text:='Select * from [tblename] where Name=:username'; I've
tried
> the [thblname] without the brackets and i still get the same result.
>
> I've tried to use the sql property in the object inspector using "Select *
> from [user]" and that seems to work, but i really need it to work at
> runtime.
> Any suggestions?
>
>
>


.

Relevant Pages

  • Re: Query to add Foreign Key constraint to existing tables?
    ... > I get a "Syntax error in CONSTRAINT ... > clause", and the DELETE word is automatically selected ... You may need to execute it via the OLE DB provider e.g. in Access2000 ...
    (microsoft.public.access.queries)
  • bind_param question
    ... The actual query my application uses is much longer and the rest of the ... values in the where clause are varchar's. ... This would help too if the execute is in a loop. ... Prev by Date: ...
    (perl.dbi.users)
  • Re: DTS Global variable in an Insert?
    ... I can successfully use the placeholder '?' ... in a where clause, but when ... I use it in the FROM part, I get a syntax error. ... Prev by Date: ...
    (microsoft.public.sqlserver.dts)
  • Execute Delete Where clause
    ... Can anyone please tell me the correct syntax for a where clause. ... execute to delete records from a table. ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Inner Outer Joins etc D7-ADO-Access2000
    ... Can someone possibly help me with this, basically i'm try to do a left join with 3 tables, but i get a "Syntax error in from clause" error from Delphi. ... Here's the SQL i use: ... Prev by Date: ...
    (borland.public.delphi.database.ado)