When testing my application with multiple users, there is a problem somewhere:
I'm using ADO DBConnection to connect to a MS SQL Db, and ADOQuery to select records, and are manually moving data from the query result fields, to grid cells (not using the DBaeare grid). So populating the grid dynamically based on the result of a select statement.
When one user in on, everything is fine. When two user are trying the same select (with different where values), the results gets mixed up, if both activates the query at the same time. If there are 2-3 second between, everything is ok. Typically user1 gets nothing and user2 gets the result of user1's select.
I've been going through my code and changed it to only use UserSession for both vars and ADO components, and server controller.cominitialization is set to Multithreadded, but still I have the problem.
Do I need to do anything special in relation to the TIwAdvWebGrid in this context ? Is the grid it self thread safe ?