Re: InSQRIBE and Oracle Forms 4.5

[Michael DeAngelo <Michael.DeAngelo@US.COOPERS.COM>]

The form that I implemented InSQRibe stuff in has other things in there
too.  Unfortunately I don't have time to remove the other stuff.

It was my impression that Oracle Forms 4.5 did not support ActiveX
controls, only VBX controls.  The move from Forms 4.5 to Forms 5 is very
minor so I would try to move up as quick as possible.

In forms 5, select the program menu and then under that select OLE
Importer...

Highlight the OLE class that you want to import, in your case
SQROCX.SQROcxCntrl.1.   Then highlight the properties and methods that you
want ot import.  Forms will then create one or more packages that provide
wrapper functions and procedures for the methods and properties of the
ActiveX control.  These wrappers automagicly do the data type conversions
and such.

Remember that Forms is not really object oriented, so calls that in an
object oriented language look like [Object Instance].Method(...) become
Method([handle of object instance],...).

Good Luck,  Peace, Love, Chocolate Chip Cookies!
Mike


To:       SQR-USERS@list.iex.net
cc:        (bcc: Michael DeAngelo/STT/CLC/Floral Park NY/C&L/US)
From:     jstein@MAIL.NETVISION.NET.IL
Date:     04/21/98 02:04:37 PM ZE3
Subject:  Re: InSQRIBE and Oracle Forms 4.5




Michael,
Thanks for your reply.
1.    I don't see any copyright restrictions problems.
        We have licenses for Forms & InSQRIBE !!!
        What the difference between sample SQR and sample fmb ?
2.    Do you know if Forms V5 handle AxtiveX other than V4.5 ?
3.    Can you expalin :
>SQROCX_DSQROCX is the name of the imported interface to the InSQRibe
>control.
        How we create it in V4.5 ?
Regards,
Arnon Oppenheimer
-------------------------------------------------------------------
SEMECH SOFTWARE MARKETING LTD.
TEL : (972) - 3 - 5333144
FAX : (972) - 3 - 5333132
Email: <semech@pobox.com>
------------------------------------------------------------------
-----Original Message-----
From: Michael DeAngelo <Michael.DeAngelo@US.COOPERS.COM>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Date: 20/04/98 20:24
Subject: Re: InSQRIBE and Oracle Forms 4.5

>Here is some code I wrote to begin excercising the InSQRibe control in
>Forms 5.0...
>
>The ActiveX control was embedded as 'INQRIBE'.
>HOST_RESULT was a text item I used to display a result.
>HOST_NAME, HOST_USERNAME, HOST_PASSWORD, and HOST_COMMAND are text items
>that should be self explanatory.
>
>SQROCX_DSQROCX is the name of the imported interface to the InSQRibe
>control.
>
>Good luck.
>Mike
>
>PS - I'm not sure if I could send you more due to copyright
restrictions...
>
>DECLARE
>   status NUMBER;
>   intfc  OLE2.obj_type;
>BEGIN
>   :HOST_RESULT := NULL;
>   ACTIVATE_SERVER('INSQRIBEBLOCK.INSQRIBE');
>   intfc := GET_INTERFACE_POINTER('INSQRIBEBLOCK.INSQRIBE');
>   SQROCX_DSQROCX.RemoteConnect( intfc,
>      :HOST_NAME, :HOST_USERNAME, :HOST_PASSWORD, NULL);
>   status := SQROCX_DSQROCX.RemoteIsConnected(intfc);
>   IF status = 0 THEN
>      :HOST_RESULT := 'Could not connect';
>   ELSE
>      :HOST_RESULT := 'Connected';
>      SQROCX_DSQROCX.RemoteExec(intfc,
>         :HOST_COMMAND, 'c:\rprtout.txt');
>      :HOST_RESULT := 'Seemed to work';
>      SQROCX_DSQROCX.RemoteDisconnect(intfc);
>   END IF;
>
>END;
>
>
>SEMECH wrote:
>>
>> Hi,
>>
>> Can someone send me a sample form (.fmb) that implements the
>> InSQRIBE's ActiveX RUNSQR and
>> SQR Viewer.
>>
>> Thank's in advance,
>>
>> Arnon.
>> -------------------------------------------------------------------
>> SEMECH SOFTWARE MARKETING LTD.
>> TEL : (972) - 3 - 5333144
>> FAX : (972) - 3 - 5333132
>> Email: <semech@pobox.com>
>> ------------------------------------------------------------------
>