Maybe a strange question.
I'm developing a web application that need to use temporary tables to perform complex calculation on data.
I thought to use a multitable dataset where keeping record got from SQLServer and update them.
Those tables are connected between them and with others tables on the server by standard references such as id->r_id.
There a way to run an standard sql update command between dataset tables? And between a dataset table and an external table?
For example "UPDATE DSTABLE1 INNER JOIN DSTABLE2 ON DSTABLE1.R_ID = DSTABLE2.ID SET DSTABLE1.FIELD1 = DSTABLE1.FIELD1+DSTABLE2.FIELD1" or something like that.
Thank you in advance
Stevie B. Gibson
I'm developing a web application that need to use temporary tables to perform complex calculation on data.
I thought to use a multitable dataset where keeping record got from SQLServer and update them.
Those tables are connected between them and with others tables on the server by standard references such as id->r_id.
There a way to run an standard sql update command between dataset tables? And between a dataset table and an external table?
For example "UPDATE DSTABLE1 INNER JOIN DSTABLE2 ON DSTABLE1.R_ID = DSTABLE2.ID SET DSTABLE1.FIELD1 = DSTABLE1.FIELD1+DSTABLE2.FIELD1" or something like that.
Thank you in advance
Stevie B. Gibson