Information générale
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
Précédent
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