got the following SQL error

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by paulus Wed, 27 Nov 2002 11:07

#11304

Author: paulus
Date: Wed, 27 Nov 2002 11:07

23 lines
1359 bytes

when i type the following sql statement in ib 6.0 .

Select Sum(bedrag) , klantnr
From verkoopgeg

i get te following error  sql error -104  Invalid column Reference
(invalid token)
but when i type the statement as following

select sum(bedrag)
from verkoopgeg

or

select klantnr
from verkoopgeg

i get no errors message

the table looks as following

bedrag numeric
klantnr integer

Re: got the following SQL error

#11305

Author: Eras
Date: Wed, 27 Nov 2002 11:45

34 lines
1574 bytes

Your SQL must be:

Select Sum(bedrag) , klantnr
From verkoopgeg
Group By klantnr



"paulus" <tcwijck@wxs.nl> wrote in message news:3DE4A780.A5951374@wxs.nl...
> when i type the following sql statement in ib 6.0 .
>
> Select Sum(bedrag) , klantnr
> From verkoopgeg
>
> i get te following error  sql error -104  Invalid column Reference
> (invalid token)
> but when i type the statement as following
>
> select sum(bedrag)
> from verkoopgeg
>
> or
>
> select klantnr
> from verkoopgeg
>
> i get no errors message
>
> the table looks as following
>
> bedrag numeric
> klantnr integer
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads