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" <[email protected]>
To: "Velen Vydelingum" <[email protected]>
Cc: <[email protected]>
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" <[email protected]> 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/[email protected]
