Mary,
Wednesday, August 14, 2002, 7:23:47 PM, you wrote:
MS> here is is ...
MS> 'check to see if agent/dist code are already in temp table
MS> sSql = "SELECT *" & _
MS> " FROM TempSap " & _
MS> " WHERE ProducerID='" & FixSQLString("" &
MS> rs3!WritingAgentID) & "'" & _
MS> " AND TaxID='" & FixSQLString("" & rs3!taxid)
MS> & "'" & _
MS> " AND DistributionCode='" &
MS> FixSQLString(sDistributionCode) & "'"
MS> Call SendToDwDb(sSql, rs5)
Mary, it would be nice if you post not only your INSERT statement, but
the output of SHOW CREATE TABLE and the output of the query result,
too. Provide also exact SELECT statement, i.e. with actual values for
producerid, taxid and so on.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
