close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 12 years ago

Closed 12 years ago

Last modified 11 years ago

#1696 closed defect (fixed)

fail in SqlInsertFast

Reported by: Jorge Owned by: Jorge
Priority: normal Milestone: Mantainance
Component: Database Version: 3.1
Severity: normal Keywords:
Cc: rtless@…

Description

If you execute the following code

Real StdLib::SqlEngine::SqlInsertFast("tableName", [[ [["a" ]] ]], 1);

you will get the following error:

<E>
ERROR: [1] Número de argumentos insuficientes para Text SqlFormatText (Text txt, Real gestor)</E>
[Call stack]
[4] Text StdLib::SqlEngine::SqlFormatText (Text txt, Real gestor)
[3] Text StdLib::SqlEngine::SqlFormat (Anything var, Real gestor, Text format)
[2] Text StdLib::SqlEngine::SqlFormatText (Text txt, Real gestor)
[1] Real StdLib::SqlEngine::SqlInsertFast (Text nameTable, Set data, Real saveQuery)
<E>
...

Change History (2)

comment:1 Changed 12 years ago by Jorge

Resolution: → fixed
Status: new → closed

Es un error que salta si la variable global StdLib::SqlEngine::GesAct está un valor de gestor no válido, los valores válidos son:

Real GesMic = 0;
Real GesOra = 1;
Real GesMys = 2;
Real GesAcc = 3;
Real GesPos = 4;
Real GesTer = 5;
Real GesRed = 6;

comment:2 Changed 11 years ago by Jorge

(In [6150]) refs #1696, corrección en SqlInsertFast

    Text dualstr = If(GesAct <: SetOfReal(1,2)," from dual","");
    "select "+TxtListItem(recordSet, ", ")+dualstr
Note: See TracTickets for help on using tickets.