>Thanks again!
>
>Would you more specific to your suggestion please. How SPT would update the local table? BY using SQLSETPROP()?
Without opening the table with USE, make use of SQLCONNECT() coupled with SQLEXEC(nConn,"UPDATE mytable blah...")
As I often suggest, if scalability is a concern, make use of ANSI SQL compliant statement to manipulate data.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
