Parameters an SQL statement...

From: Jose Maria Veneroso (jmvene_at_sgie.com)
Date: 01/25/04 

Date: Sun, 25 Jan 2004 20:30:19 +0100

I'm using parameters in a Tadoquery. I need to debug the SQL statement to
see if there is any syntax error. Could someone explain me how to read o
obtain the SQL statement generated after the asignation of the parameters
value?

For ej

Miquery.sql.Add('Select * FROM empleados WHERE id=:id);
Miquery.parameters.parambyname('id').value:='888';

After that i need to see the "SELECT * FROM empleados WHERE id=888"...

Thank you

Relevant Pages

  • Re: Syntax error in FROM clause
    ... It appears that the maximum length of the SQL statement has been reached. ... "George wilson" wrote in message ... >><MS ACCESS MVP> ... >>> a "Syntax error in FROM clause" and is unable to view ...
    (microsoft.public.access.forms)
  • Re: INSERT command doesnt work in Access
    ... that OleDbException, that says "Syntax error in SQL statement". ... Lately I've tried simple OleDbCommand, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: rewrite QBE SQL statement
    ... I am now getting a syntax error that tells me that I am missing an operator ... Is there a way to rewrite this as nested subqueries in such a way ... I am trying to write a SQL statement based on a SQL statement from the ... I am trying to rewrite this into workable SQL that I can pass as string ...
    (microsoft.public.access.modulesdaovba)
  • Re: Syntax error in INSERT INTO statement.
    ... > I got syntax error in INSERT INTO statement. ... Run the page and look at the sql statement in the browser window. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: Change table date/time field to text field in code
    ... That means your SQL statement is not correct. ... > When I try this method, I am getting error 3293 Syntax error in ALTER ... >> Dim strSql As String ...
    (comp.databases.ms-access)