It's something like :
conn.execute ("insert into tmptable select
supplier_code,0,0,0,0,0-sum(amountpaid),0 from custpayments where
paymentdate<='2010-12-02' and grnno not in (Select sale_id from
saletrans_cons where paymode='Credit') group by supplier_code")
Veln
----- Original Message -----
From: "Johnny Withers" <joh...@pixelated.net>
To: "Velen Vydelingum" <ve...@biz-mu.com>
Cc: <mysql@lists.mysql.com>
Sent: Sunday, July 24, 2011 17:41
Subject: Re: Query bug
What's your vb code for outputting the results look like?
On Jul 24, 2011 8:22 AM, "Velen Vydelingum" <ve...@biz-mu.com> wrote:
Hi,
I have the following query which is fine when I run it from the mysql
shell
screen:
select supplier_code,0,0,0,0,0-sum(amountpaid),0 from custpayments where
paymentdate<='2010-12-02' and grnno not in (Select sale_id from
saletrans_cons where paymode='Credit') group by supplier_code
but when I use VB to send this same query the results exclude the last
record.
Can anyone tell me why I'm having this issue with VB?
Thanks.
Veln
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org