Information générale
Titre:
Cursor based on SQL Query dont return Value
Versions des environnements
Network:
Windows 2008 Server
Hello comunity
I have build this code to return my accountbank number:
Text to msel textmerge noshow
SELECT BankAccount =
Stuff((SELECT ', ' + Cast(bl.noconta as varchar)
FROM bl INNER JOIN us
ON Rtrim(us.area) = Rtrim(bl.u_area)
WHERE
userno = 1 AND bl.u_area IS not null
For XML PATH ('')),1,1,'')
Endtext
If u_sqlexec(msel,[Cursorbanknr])
Local mybanknr as String
Mybanknr = '(' + Alltrim(mybanknr) + ')'
Else
msg(msel)
Endif
If i run the query in SSMS query the value return is : 16, 35 that is correct.
But if i put a messagebox on variable Mybanknr , the value is : () , also i select the cursor Cursorbanknr and make a browse, this one is empty.
someone could give me some help!
Many thanks
LS
If i run this query on SQL server they return theses values : 16,35
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement