Re: OPO EXEC SQL Query

gordonh_at_acslink.net.au (Gordon E. Hooker) wrote:

<snip>

>SELECT CASE vCategory
> CASE 1
> EXEC SQL select named into :vQty from platformline where platformid =
>:vPlatformID and model like :vModel (This would all be on one line)
> CASE 2
> EXEC SQL select concurrent into :vQty from platformline where platformid =
>:vPlatformID and model like :vModel
>END SELECT
<snip>

Why don't you try checking the status of the EXEC SQL using SQLERRCODE(). This will tell you whether the EXEC SQL was successfully executed by the server or if an error was returned. If I am not mistaken, an error in EXEC SQL will not be displayed to the user, the user will have to check manually.

-- 

======================================================================
Mohamad Nazri Shuib                     E-mail: mnshuib_at_gware.po.my
GroupWare 2000 Sdn Bhd                  Tel: (603) 253-5331
19G Medan Setia 1                       Fax: (603) 253-9927
Plaza Damansara
Bukit Damansara
50490 Kuala Lumpur
MALAYSIA
======================================================================