Hi

I get an 'Unsuported column type: 0' error whenever I do this.


I have just discovered it is due to my component set, I am using an
IBOQuery to run this. I have just run it in FlameRobin without problems.

Thanks

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



mikcaau wrote:

>--- In firebird-support@yahoogroups.com, Robert martin <rob@c...> wrote:
>
>
>>Hi
>>
>>I am a stored procedure novice (in the extreme). I have the following
>>
>>
>...
>
>
>>Any suggestions ?
>>
>>
>...
>
>
>>CREATE PROCEDURE BackOrderedItems (DrTransRef Numeric(11) )
>>RETURNS (
>>
>>
>...
>
>
>> WHERE d.DrTransRef = :DrTransRef
>> AND d.Subrank = 999
>>
>>
>...
>.Itemref = :i_ItemRef
>
>
>> INTO Avail, Due;
>>
>>
>INTO :Avail, :Due
>
>
>> SUSPEND;
>>END
>>
>>
>>
>>
>>
>note :
>
>mick
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>