RE: getParameterMetaData bug?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

This exception java.sql.SQLException with message "Incorrect syntax near
the keyword 'FROM'" for a query such as the following seems to be a bug in
the JDBC driver.

SELECT program FROM programs WHERE (code = ?)

You may wish to open a support incident with PSS if you want to pursue the
possibility of getting a fix for this.

.

Relevant Pages

  • RE: Search Form - Take 2
    ... The search function is working like a charm when I enter a keyword in the ... as its due to the fact that the columns in master allow Nulls. ... Recommendations and Accomplishments tables an extra ... Create a query in which the Master table is joined to each of the other ...
    (microsoft.public.access.gettingstarted)
  • Re: IS NULL not working in WHERE clause.
    ... At this point it's pretty hard to say whether it's a bug or corruption. ... And just to be certain - you said the query operators each select ... in the query plan that checks time_id for null, ... >This execution plan shows a single execution string. ...
    (microsoft.public.sqlserver.programming)
  • Re: Help needed on creating a subform
    ... Don't enter anything in this procedure yet but scroll down below the End Sub ... "ORDER BY QuoteId DESC, Keyword" ... based on the current value of the quote id. ... A UNION query concatenates the results of two separate queries. ...
    (microsoft.public.access.forms)
  • Re: Creatinig a database to update in alphabetical order
    ... You can then create a Query which takes all of the records in the ... Some attributes of a movie would be the Title, the studio, ... MovieID Autonumber Primary Key ' links tables together ... Keyword ...
    (microsoft.public.access.gettingstarted)
  • Re: A bug in MS Access
    ... I tried using exactly what you described, and received an error message that ... the delete query was invalid because it required a parameter. ... I do not believe you have a valid bug here. ... > I created a table ADDRESSDETAILS with following Columns ...
    (microsoft.public.access.modulesdaovba)