Skip to Content
0
Former Member
Aug 08, 2005 at 01:14 PM

Update MS SQL

10 Views

Hi

I try to update a MSSQL database, but I got a dump, with the text:

"No value given for one or more required parameters"

SQL error 0.

I don't have any problems with the connection to the MS SQL database.

In my code all fields are filled before I try to update.

  
modify g_import_tab transporting flag where flag = '0'.

  loop at g_import_tab.

    EXEC SQL.

      modify into e1ltco

      (
        flag,
        lgnum,
        tanum,
        tapos,
        squit,
        lenum,
        quknz
              )
     values
     (
         :g_import_tab-flag,
         :g_import_tab-lgnum,
         :g_import_tab-tanum,
         :g_import_tab-tapos,
         :g_import_tab-squit,
         :g_import_tab-lenum,
         :g_import_tab-quknz
         )
    ENDEXEC.

My table E1LTCO on MSSQL do only have the mentioned fields, but in an other order:

Flag, LGNUM, TANUM, TAPOS, SQUIT, LENUM, QUKNZ.

Please help me to solve the problem.

Br.

Lars