Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best Practice on Refresh Grid with Data
Message
From
10/07/2020 07:34:09
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Best Practice on Refresh Grid with Data
Miscellaneous
Thread ID:
01675136
Message ID:
01675136
Views:
116
Hi!

In our big and Old VFP9 Application we Read data from SQL Server via SQLExec(), and show the Data in VFP – Grid.
Sometimes we have to Reload the Data and since Years this is done in this sequence:
- Reload the Data (sqlexec() ) into the same named Cursor as before.
- Remove the Grid (oGrid.release() )
- Create an New Grid Instance (newobject() )
And, also since years, we fight against C5 Errors…

This time I Reviewed this refresh-code and I asked me: Is this the right Order? Shouldn’t it be
- Remove the Grid
- Reload the Data
- Create the Grid
?

What do you think? May this be a c5 Risky Code?

How do you do this?

Happy to hear your opinion
Jörg Schneider
Joerg.Schneider@SMARTCRM.de
SMARTCRM CRM powered by MS Visual FoxPro
SMARTCRM GmbH
Next
Reply
Map
View

Click here to load this message in the networking platform