Best Way To Retrieve Data For Display & Edit

[Auguy]

I hope someone can shed some light on this subject. I have an application where the users don't need to see all of the records in a given table. Currently, I open the table and let them navigate through the records using next, prev, etc., or they can use a grid to scroll through the table. I was thinking about letting the users set some parameters and then selecting all of the fields into a cursor and doing the edits on the cursor and then doing an update back to the live table (checking for changes, etc.) Or, just selecting the unique ID from the table into the cursor and setting a relationship into the live table so the user can edit the live table directly. Anybody have any thoughts, or is there a better method?

Thanks,
Auguy

 

[Imaginecorp]

I am not familiar with SPT

AH HA.... SPT = SQL Pass Through

Got to stop doing those drugs...

 

[ilyad]

If you're using VFP8 or VFP9 you may use CursorAdapters to dynamically build where clause. You would not be able to use p-views as Mike said.

 

[opticalman]

I would like to address Mike's comment about the 'problem with views' He points out that it hard to modify the information you get with a view. I counter that multiple views with good descriptive names makes reading the code easier. I find it helpfull in maintainig my data because I can instantly see my selected fields. For example I have a remote views called rv_InsuranceAll and rv_InsuranceNew and rv_InsuranceOne. I know one is for all insurance claims, one is for all new, and the other is for one client's claims. There may be other ways to do it, but this works for me.

Jim Rumbaugh