*-- SQL Server northwind database *-- get the customers lcSql = "SELECT * FROM customers" SQLEXEC(o.inSql, lcSql, "customers") ?customers.region *-- change some data on the backend from the command window SQLEXEC(o.inSql, "UPDATE customers SET Region='MyRegion' WHERE customerId='ALFKI'") *-- re-issue the SPT command SQLEXEC(o.inSql, lcSql, "customers") ?customers.regionIt looks like you are looking for a REQUERY() function. Unfortunately, REQUERY() only works with remote views but not with SPT. But if you re-execute the SQLEXEC() command, then you should get the latest data from the backend. One problem with this approach is that if you have a grid that is bound to an SPT cursor and you run the SQLEXEC() again, then the grid will loose all the settings because the SPT cursor is closed before it's recreated. To avoid this problem do the following:
lcRecordSource = ThisForm.YourGrid.RecordSource ThisForm.YourGrid.RecordSource = "" *-- requery backend SQLEXEC(lnSql, lcSql) *-- restore recordsource ThisForm.YourGrid.RecordSource = lcRecordSourceI hope this helps. If I totally missed your question, then maybe you can provide some code to demonstrate the problems you have.