Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!cs.utexas.edu!uunet!wiley!ries%arcturus
From: ries@arcturus (Marc Ries)
Newsgroups: comp.databases
Subject: SYBASE APT-Form Argument Passing?
Summary: impossible?
Keywords: APT-Workbench/1.0/P/Sun3/os3.x/1
Message-ID: <5017@wiley.UUCP>
Date: 9 Jun 89 19:24:17 GMT
Sender: news@wiley.UUCP
Reply-To: ries@wilbur.UUCP (Marc Ries)
Organization: TRW SEDD
Lines: 34
References:


    [If you don't work for SYBASE or know it, you might want to hit "n" now]

      Is  there  any  way  to pass an argument to a SYBASE
      APT-Form via a command-line argument (something like
      what Informix [with which I  have  some  experience]
      allows)?

      Here's my problem:

      I  have  a custom C program (non APT-Form).  At some
      point,  I  would  like to take a specific (variable)
      piece of  information  and  use  it  to  search  the
      database to find the information (and related info.)
      and  present  the  user  with  an  APT-Form  to look
      at/modify the retrieved data.

      Ideally, I would like to do something like:
          sprintf(buffer, "aptexec %s", my_search_criteria);
          system|fork|exec(buffer);

      APTEXEC doesn't allow arguments.

      The   work-around   suggestion   appears  to  be  to
      force-feed isql  to  create  a  temporary  table  to
      (uniquely)  store  my_search_criteria  argument, and
      then have a stored procedure read that table and use
      its contents to load the form. Jeez!


     Marc Ries
           <somewhere>!ries

     "PHOTOVOLTAICS: safe/clean Electricity from the SUN"