|
Home > Archive > Visual FoxPro SQL Queries > January 2006 > Alternative to REQUERY()
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Alternative to REQUERY()
|
|
| Andy Trezise 2006-01-15, 8:24 pm |
| I have a form on which I use a grid to maintain a table located on a remote
SQL server.
I use a view to access the data.
My problem is that because the application runs across a LAN and thus can be
updated from other workstations I need to keep refreshing the grid to update
it with deletes/updates by other users.
Is there another way of refreshing the grid other than requerying the base
tables all the time.
I have over 10 thousand records in my SQL table and it takes between 3/4
seconds every time.
| |
| Olaf Doschke 2006-01-16, 11:29 am |
| Hi Andy,
> I have over 10 thousand records in my SQL table and it takes between 3/4 seconds every time.
I'd say: Bad application design.
What user can monitor 10,000 records at the same time?
Why not only show the top 100 (or latest 100) records?
Have you ever heard of view parameters and what they are there for?
You could even provide users with some custom filter form
and only show the records that matter to them, eg. data from a certain
time period, customer, manufacturer, whatever...
Bye, Olaf.
| |
| Cindy Winegarden 2006-01-17, 3:24 am |
| Hi Andy,
Depending on what you're doing you can wrap the user's changes inside a
transaction and check for changes as part of the transaction. (Check out
OldVal() and CurVal().) If the values have changed you can ask the user what
he wants to do.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
"Andy Trezise" <andy@work.com> wrote in message
news:e6VGQkiGGHA.3904@TK2MSFTNGP10.phx.gbl...
>I have a form on which I use a grid to maintain a table located on a remote
>SQL server.
>
> I use a view to access the data.
>
> My problem is that because the application runs across a LAN and thus can
> be updated from other workstations I need to keep refreshing the grid to
> update it with deletes/updates by other users.
>
> Is there another way of refreshing the grid other than requerying the base
> tables all the time.
>
> I have over 10 thousand records in my SQL table and it takes between 3/4
> seconds every time.
>
|
|
|
|
|