Skip to main content

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

  • November 19, 2018
  • 4 replies
  • 0 views
Jan Cees Boogaard

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 replies

    Jan Cees Boogaard

    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.

    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)
    Jan Cees Boogaard

    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.

    Thank you Uli.

    Fantastic as always.

    Regards,Rafa.


    Author: uniface8 (spanish_uniface@hotmail.es)
    Jan Cees Boogaard

    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.

    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)
    Jan Cees Boogaard

    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.

    It works, great,but i´ll ask first if someone needs procs on database.

    Ty Ingo.

    Regards,Rafa.


    Author: uniface8 (spanish_uniface@hotmail.es)

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement