on 08-08-2005 2:14 PM
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
sorry posted in wrong forum.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.