ok , but I have now just programmed around the error.... to meet my deadline...
-----Original Message----- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 6:08 AM To: [EMAIL PROTECTED] Subject: Re: RE: null 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 --------------------------------------------------------------------- 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
