Hi,
I need to build a Socket server that will accept a requests from users, The request will be a QUERY to a SQL server or ORACLE server. The request can be a simple or complex, I just pickup the Query and send it - as is - to the DB and the results I will send back to the user.
To accomplish such a server I have a sample socket server that act very good if I have one connection.

But if I get a complex query - that may take a long time - and I save the temporary data in a one filed and another query came, Where should I save the data for the second connection?
What I am trying to say is: If I have a few variables in the form (such as integers, Strings.....) and they are occupied by the 1ST query, If another query came at the same time - What should I do to multiply the variables for the new connection? The Socket server multiply the Winsock only NOT the all form!!.
Any idea??

Regards