Problem to retrieve data from MSS Server[U9.4]

Author: spanish_uniface@hotmail.es (uniface8)

Hi all,
I´m starting to use MS SQL Server in a client/server application, but i can´t retrieve data from the database with the "retrieve" instruction, i can with sql instruction, but with "retrieve" always return status=-3 and the message log have
"I/O function: F, mode: 0, on file/table: _SMDBA_.TELMASTEV1 index: 1 =
42000 [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure '_SMDBA_.TELMASTEV1_FET'."

This code fails:
clear/e "TELMASTEV1"
sequence.telmastev1="1111"
retrieve/e "TELMASTEV1"
$status-->-3

But if i add the filter in the read trigger it works:
clear/e "TELMASTEV1"
retrieve/e "TELMASTEV1"

;read u_where (sequence.telmastev1="1111")

It works.

Any advices?

Regards,
Rafa.

4 Comments

  1. Hi Rafa

    Hi there a need for (UnifAce-)procedures on database?

    If not, just switch  them off:

    [DRIVER_SETTINGS]

    USYS$MSS_PARAMS    procs:off,...

     

    Ingo

     


    Author: istiller (i2stiller@gmx.de)
  2. It works, great,but i´ll ask first if someone needs procs on database.

    Ty Ingo.

    Regards,Rafa.


    Author: uniface8 (spanish_uniface@hotmail.es)
  3. Hi Rafa,

    In the past, a read trigger which holds only "read" is processed differently from a trigger with a CRLF after the read.

    for a couple of standard situations, Uniface uses stored procedures to speed up processing

    As the uniface help reads: Creating Stored Procedures

    Stored procedures can be created if the procedures connector option is on. They are created either on-the-fly if the table is not yet present in the DBMS, or by the scripts generated by the Create Table utility. If created on the fly, the connector does not function correctly if the procedures option is on and there are no procedures present in the DBMS.

     

    You can get the SQL creation via:

    "Utilities" => "Deployment" => "SQL Tables"

    So if the stored procs does not exist on the database, just run the script against it.

    Success, Uli


    Author: ulrich-merkel (ulrichmerkel@web.de)
  4. Thank you Uli.

    Fantastic as always.

    Regards,Rafa.


    Author: uniface8 (spanish_uniface@hotmail.es)