FiveTech Software tech support forums

... from the Server again.

Requerying frequently makes the application sluggish.

There is a less known method
oRowSet:Refresh()
This method refreshes only those records which are updated by other users on the network after the RowSet is updated last.
But this works only if the table contains a ...

... Copy": This button copies the currently displayed image to the clipboard.
- "Paste": This button loads an image from the clipboard and refreshes the image display.
- "Save": This button saves the currently displayed image as "SAVED.JPG" and displays a message "saved as saved.jpg ...

... good. Because our program reads an image only once from the disk and any subsequent painting is only from the memory (no disk access again), the screen refreshes will be very fast.

Btw, I just created and added a new function FW_SaveThumbnail( cImageFile, cThumbFile, nWidth, [nHeight] ) --> lSucess.

... IF MsgYesNo( "Do you wish to display deleted records ?" )
SET DELETED OFF
ELSE
SET DELETED ON
ENDIF

RETURN NIL



The ACTION statement refreshes the browse after running the function.

3) When exiting the editor, the program executes SET DELETED ON

With these steps I eliminated my concern ...

... in one row is modified and saved,

TDolphin.

Saves the changes to one record and reads all records of the entire query.
If the query has 10000 records. Dolphin reads all 10000 records again.

Fivewin LIB and ADO.

Saves changes to one record and reads and refreshes that one record only.
Very fast.