Re: Tutorial Confusion

[Ian Skinner <iskinner@xxxxxxxxxxx>]

alan_lindsay wrote:
>  com.inzoom.adojni.ComException: No value given for one or more required 
> parameters. in Microsoft JET Database Engine code=3088 Type=1

That sounds like Access is complaining about the SQL syntax.  What 
happens if your run the query directly inside the Access database?  I've 
never used that type of join syntax with Access, I've only seen it in 
older Oracle code.

In Access I am used to seeing code that would look like this.

SELECT
  FIRSTNAME,
  LASTNAME,
  ARTNAME,
  DESCRIPTION,
  PRICE,
  LARGIMAGE,
  ISSOLD,
  MEDIATYPE

FROM
  (ARTISTS INNER JOIN
   ART ON ARTISTS.ARTISTID = ART.ARTISTID) INNER JOIN
   MEDIA ON ART.MEDIAID = MEDIA.MEDIAID

Of course if you write this inside of Access it will use a lot more sets 
of parentheses in the FROM clause.  Access really likes its parentheses.