Query bug

Query bug

am 24.07.2011 15:21:23 von Velen

------=_NextPart_000_0031_01CC4A26.1C56B940
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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<=3D'2010-12-02' and grnno not in (Select sale_id from =
saletrans_cons where paymode=3D'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? =20

Thanks.


Veln
------=_NextPart_000_0031_01CC4A26.1C56B940--

Re: Query bug

am 24.07.2011 15:41:55 von Johnny Withers

--20cf302ad694a7ce3304a8d0dca0
Content-Type: text/plain; charset=ISO-8859-1

What's your vb code for outputting the results look like?

On Jul 24, 2011 8:22 AM, "Velen Vydelingum" 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

--20cf302ad694a7ce3304a8d0dca0--

Re: Query bug

am 24.07.2011 19:54:39 von Velen

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"
To: "Velen Vydelingum"
Cc:
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" 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=gcdmg-mysql-2@m.gmane.org