Subject: | Re: single row query - progress
| Date: | Fri, 18 May 2018 03:27:12 +1000
| From: | Bernie van't Hof <berniev@bje.com.au>
| Newsgroups: | pnews.paradox-dos
|
No, that's fine. SQL will add, and the column name alias is paradox style.
But
GROUP BY
`t3`.`A/C#` AND `t3`.`Name` AND `t3`.`Amt`
Should be comma separated instead of AND. Spotted it, as luck would have it, just after posting.
- Bernie
On 18/5/18 1:45 am, Larry DiGiovanni wrote:
> Bernie van't Hof wrote:
>
>> I already fixed another bug. Can you see it? Hint: Not pdox related.
>
> In the earlier QBE to SQL you posted?
>
>> '3' + '2' AS `3 + 2`,
>
> I thought that looked a little weird. Didn't have time to decide if MySQL would concatenate
or add.
>
> --
> Larry DiGiovanni
>
|