General information
Forum:
Microsoft SQL Server
Hi Michael,
Because i want OPTIMIZE roundtrip whitout uses ODBC bindig ?var .
On these mode i can build one offline string command, and send
it to the Server, or send it one step by step in online mode.
Example ( metalanguage ):
OpenConnection(c1)
OpenStantment(s1,c1)
ODBCExec(s1,"DECLARE @contextVar1,@contextVar2 .... ")
ODBCExec(s1,"set @contextVar1=...,set @contextVar2=.... ")
ODBCPREPARE(s1,"SELECT ... from TX where X1=@contextVar1 and x2= @contextVar2 .... ")
OpenStantment(s2,c1)
ODBCPREPARE(s2,"SELECT ... from TY JOIN TZ ON Y1=@contextVar1 and Y2= @contextVar2 .... ")
ODBCExec(s1)
ODBCExec(s2)
.....
OpenStantment(s3,c1)
ODBCExec(s3,"DECLARE @writeVar1,@writeVar2 .... ")
OpenStantment(s4,c1)
ODBCPREPARE(s4,"insert tab1 (f1,f2,f3,f4)values(@contextVar1,@contextVar2,@writeVar1,@writeVar2")
-- cycle
ODBCExec(s3,"set writeVar1=...,set writeVar2=.... ")
ODBCExec(s4) -- exec update
ODBCExec(s3,"set writeVar1=...,set writeVar2=.... ")
ODBCExec(s4) -- exec update
ODBCExec(s3,"set writeVar1=...,set writeVar2=.... ")
ODBCExec(s4)
....
You known any DB Server with these feature ?
Fabio
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only