Hi Thom,

I downloaded my smsql.zip yesterday and the download worked correctly. The app was designed to connect to a postgres database that I provide, which is down right now. However, you could download smsql.zip and take a look at the source. Hopefully later you could actual test the code when I have postgres configured again.

Also, If your using any tables that have many of the same primary keys like an A/R sytem where the parent has a unique primary key that relates into a child table that has many rows owned by the parent, you might try parameterized views. Using parameterized views and table buffering 5 in a VFP7 front end form could make your app much more efficient. You could try both smsql and views to see which you liked the best.