Daniele Grillo 23.Jan.13 12:38 PM a Web browser LC LSXAll ReleasesAll Platforms
I have a simple question about LSX code...I would use the same connection for EXECUTE 2 query combined....How to is possible?
This is my code tnx to all!
Dim conn As New LCConnection ("db2")
Dim fieldlist As New Lcfieldlist
conn.database="DB2DAABASE"
conn.userid="USERID"
conn.password="PWD"
conn.MapByName=True
conn.connect ''Esegue la connessione CLI al DB2
Formula=|SELECT * FROM TABLE|
Call conn.Execute(formula, fieldlist)
while (conn.fetch(fieldlist)>0)
key=fieldlist.FIELNAME(0)
%REM
NOW I NEED TO CREATE A NEW SQL QUERY HOW CAN I USE
SAME SESSION?
NewFormula=|SELECT * FROM TABLE2 WHERE CODE=|+key
Return to top
Print this page
