Re: quickly get new lines in REMOTE SQL VIEW

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

ok thanks Dan, Fred! i own u beer :)

Dan Freeman rašė:
That's correct, and you should be selecting less data in the first place. ;-)

Dan

"Jeronimas" <jerka@xxxxxxxx> wrote in message news:et4dtiPYHHA.4232@xxxxxxxxxxxxxxxxxxxxxxx
So as i understant, there is the only way in VFP to make it work faster - selecting less data - writing WHERE or SCOPE conditions. Right?
p.s. it's me, Herkus:)


"Fred Taylor" <ftaylor@xxxxxxxx!REMOVE> wrote in message news:%23Be22oMYHHA.2320@xxxxxxxxxxxxxxxxxxxxxxx
How many rows are being returned in your view? Using SQL as the backend, you have to think very differently from the usual VFP mindset that you have all the records available all the time. You need to bring down from SQL only those records you need "right now", not the entire table.

--
Fred
Microsoft Visual FoxPro MVP


"Herkus" <no@xxxxxx> wrote in message news:uMK6tELYHHA.5044@xxxxxxxxxxxxxxxxxxxxxxx
I use remote sql view. But if there are inserted new rows into table, i still can't see them in my view until i run REQUERY... REQUERY is very slow. Is there other quicker way to refresh view and get new lines as well?




.

Relevant Pages

  • Re: quickly get new lines in REMOTE SQL VIEW
    ... and you should be selecting less data in the first place. ... selecting less data - writing WHERE or SCOPE conditions. ... still can't see them in my view until i run REQUERY... ...
    (microsoft.public.fox.helpwanted)
  • Re: quickly get new lines in REMOTE SQL VIEW
    ... there is the only way in VFP to make it work faster - ... selecting less data - writing WHERE or SCOPE conditions. ... still can't see them in my view until i run REQUERY... ...
    (microsoft.public.fox.helpwanted)