General information
Category:
Coding, syntax & commands
Title:
I made a big mistake, I should have used local views...
I made a big mistake, I think I should have used local views to begin with. Now I need to upsize my application to a SQL server. The upsize wizard worked, converting all my local tables to remote views. But now NONE of my forms work! For most of the forms, I was using a SEEK to find a selected record and display it.
How do I do the same thing with views without indexes?
My main add/update screen takes a while to load now because the view download all 4,000 records. How do I speed this up and still give the user access to all records?
Any advice?
TIA!
Jeff
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only