Hi
I have a small problem with the application I am busy with.I have and
msflexgrid and before the form exists it saves the selected row to the DB
using an update statement, this db entry is used in the next form and is
requested using a select statement. My problem is that sometimes the update
takes longer than the other form loading and selectinmg the Db entry
therefore it doesnt get selected. I need some advice on which controls to
use to ensure that the appropriate time is taken to let the update statement
take place and therefore the correct info selected. Should I make use of a
different mouse cursor? or should i make a small form with a progress bar on
it? But what I am trying to get my head around is the following: how do I
know when the statement is completely updated?is there anyway of determining
from the DB when it is complete? I am using and access database and
ADO.Another factor is also when the db increases will it affect the
update/insert time??
thanx in advance!
zann
I have a small problem with the application I am busy with.I have and
msflexgrid and before the form exists it saves the selected row to the DB
using an update statement, this db entry is used in the next form and is
requested using a select statement. My problem is that sometimes the update
takes longer than the other form loading and selectinmg the Db entry
therefore it doesnt get selected. I need some advice on which controls to
use to ensure that the appropriate time is taken to let the update statement
take place and therefore the correct info selected. Should I make use of a
different mouse cursor? or should i make a small form with a progress bar on
it? But what I am trying to get my head around is the following: how do I
know when the statement is completely updated?is there anyway of determining
from the DB when it is complete? I am using and access database and
ADO.Another factor is also when the db increases will it affect the
update/insert time??
thanx in advance!
zann