I hate to bother everyone (again), but I'd rather ask before I start tearing apart a lot of work and messing stuff up.
I have two forms that use the same database. There will be several more by the time i finish, but just two for now.
On one form, the main one, I have three grids. On it I have:
- 3 DataSources
- 3 SQLQueries
- 1 SQLite3Connection
- 1 SQLTransaction
That works perfectly.
On the second form, I added (yet again):
- 1 DataSource
- 1 SQLQuery
- 1 SQLite3Connection
- 1 SQLTransaction
When I switch between forms, I'm finiding all of this is tangling up on me, causing the database to keep locking up. So when I started disconnecting them through code, my grids stopped displaying data until I clicked the Refresh button.
I don't need those other data components on the second form, right? I've already seen that, by adding the main form to the
uses of the second form, I can access the main form's data components. Everything works right now, but the grids going blank is kinda ugly