Hi,

I'm very new to database design and have developed an application running on
M$ Access and am currently in the process of moving the back end to MySQL,
mainly to make use with a website easier.

All is fine except for one query which contains a sub select so therefore
will not work.

The query and associated VB code is shown below, could someone have a look
at it and suggest a work around to get this part working with MySQL please?

CurrentDb.Execute "DELETE * FROM KeywordsForPicture WHERE
(KeywordsForPicture.PicID=" & Forms!frmPhotographs!textPicID & ") AND
(KeywordsForPicture.KeywordID IN (SELECT KeywordID FROM Keywords WHERE
Keywords.SubCatID=" & cboSubCategory & "))"

While I'm here are there any other tweaks people would suggest while using
the Access Front end? The Access front end is a semi temporary arrangement,
next personal challenge is to create a php driven front end.

Thanks

Alex
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.324 / Virus Database: 181 - Release Date: 14/02/2002


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to