Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dainova
Starting Member
31 Posts |
 Posted - 2008-03-24 : 17:18:15
|
| Hi,Having this sql=-10000 on this statement below, which referes to some mismatch between columns and host-vars.This runs from MicroFocus program against SQLServer'05 table, all hosts are well defined, same picture.Interesting thing is that if I change ws-volume for literal, eg.B3M_VOLUME = 21 it will work fine, but doesn't work with B3M_VOLUME = :WS-VOLUME:-------------------- EXEC SQL SELECT * INTO :DCLVB3M-BASE FROM VB3M_BASE WHERE B3M_REMSEQ = :WS-REMSEQ AND B3M_LOCSEQ = (SELECT B3M_LOCSEQ FROM VB3M_BASE WHERE B3M_REMSEQ = :WS-REMSEQx2 AND B3M_VOLUME = :WS-VOLUMEx1 AND B3M_BUST <> :WS-BUST) END-EXEC.------------------also anybody can point to good place to see list of all sql codes:Tx alldai |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-24 : 17:21:40
|
| variables in sql server are defined with @:WS-REMSEQ should be @WS-REMSEQ_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
dainova
Starting Member
31 Posts |
Posted - 2008-03-24 : 18:30:45
|
| Tx, Spirit1It defenetely works fine with :WS-REMSEQ, probably ODBC takes care of it. It's a piece of prod code, I just added extra AND for AND B3M_VOLUME = :WS-VOLUME. But I'll try @ anyway. Will let you know.Also pls disregard "x2,x1", those are comments, just bad formatting. |
|
|
|
|
|
|
SQLCODE -10000 (10k)