Re: forms5: dynamic where in procedure?

Hi Grudrun,

i'm doing it this way:

   connection_id := EXEC_SQL.CURR_CONNECTION;    cursor_number := EXEC_SQL.OPEN_CURSOR (connection_id);

   EXEC_SQL.PARSE (connection_id, cursor_number,   pivSQL   );                -- String with the

   EXEC_SQL.DEFINE_COLUMN (connection_id, cursor_number, 1, nAnzahl );

   nRet := EXEC_SQL.EXECUTE_AND_FETCH (connection_id, cursor_number, TRUE);

   EXEC_SQL.COLUMN_VALUE (connection_id, cursor_number, 1, nAnzahl );    EXEC_SQL.CLOSE_CURSOR (connection_id, cursor_number);

• Rueckgabe des Ergebnisses
  --
  RETURN nAnzahl;

Kay Received on Tue Mar 23 1999 - 16:46:30 CET