create/query/insert/update or execute?
>
> M--
> - Original Message -
> From: "Tomas Hylander" <[EMAIL PROTECTED]>
> To: "Martin Gainty" <[EMAIL PROTECTED]>
> Cc:
> Sent: Monday, November 26, 2007 1:38 AM
> Subject: Re: Problem with
From: "Tomas Hylander" <[EMAIL PROTECTED]>
To: "Martin Gainty" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, November 26, 2007 1:38 AM
Subject: Re: Problem with a Procedure
> Hi!
> I must say I cant see how this would help me. I know the tabels isnt
> empty since
Hi!
I must say I cant see how this would help me. I know the tabels isnt
empty since when running in query browsern I get a result.
There must be something else thats wrong..
...but thanks anyway!
/Hylsan
On Nov 23, 2007 4:43 PM, Martin Gainty <[EMAIL PROTECTED]> wrote:
>
> Tomas-
>
> I would ef
Tomas-I would effect a quick iterative check on the table(s) to see if they are
empty e.g.
SELECT count(trans2.nettovikt) from trans2;
(If recordcount>0) then
SELECT SUM(trans2.nettovikt) FROM trans2 INNER JOIN artikel on
trans2.artikel=artikel.artikel
(If recordcount>0) then
SELECT SUM(trans