>>> Inandjo <<<<
- delete from table1 where table1.field1 in (select distinct field2 from
table2)
<<<<<<<<<<<<<<<<<<<<<
>From what I've read subqueries are not yet supported. We worked around
this by converting the distinct list to a comma delimited list of
values. E.g.,
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:::::::::::::
*- Create a delimited list of field1 from table1
lcDelimitedList = goQCApp.p_oFunc.m_CreateList("table1","field1")
*- Build our query string
sqlString = "Delete from table1 where table.field1 in (" +
lcDelimitedList + ")"
*- Execute query string
If !goQCApp.m_SqlExec(sqlString)
return messagebox("Rutt, row.... Query Failed
=>"+sqlString",16,"ABORTED")=6
endif
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:::::::::::::
Note that where MySql is happy with both double and single quotes (for
strings), Microsoft Sql Server chokes on double quotes; we found it best
to use single quotes.
We're in the midst of our conversion (from Visual Foxpro to MySql/Sql
backend) and have not yet seen a limitation in using this approach.
- Bill K.
>-----Original Message-----
>From: Inandjo Taurel [mailto:[EMAIL PROTECTED]]
>Sent: Monday, February 17, 2003 8:35 AM
>To: [EMAIL PROTECTED]
>Subject: How to write delete query??
>
>
>SQL SQL
>hi all,
>i have a query that works just fine on Dbase, but just crashes
>on mysql.
>How can i write it in one statement for it to work both on
>Dbase and mysql?
>
>
>the query:
>- delete from table1 where table1.field1 in (select distinct
>.
>
>Thanx
>
>
>_________________________________________________________________
>MSN 8 with e-mail virus protection service: 2 months FREE*
>http://join.msn.com/?page=features/virus
>
>
>---------------------------------------------------------------------
>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
>
>
---------------------------------------------------------------------
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
