Hi Jim,
>Two questions:
>? SqlExec(lnConn, [EXEC proc_test ?ldDt, ?lnInt])
>apparently the ldDT and lnInt need the ? Tried running it without. What do the question marks do??The ?ldDt and ?lnInt are parameters that will be substituted by actual values when SqlExec() is executed. They're similar to the parameters of a parameterized view.
>Modified the sproc to insert the values into a test table
< snip >
>This worked fine, except when I ran the foxpro code several times the remote view to this table did not show the updates until I quit foxpro and reopened foxpro. Why doesn't the remote view refresh itself?Foxpro doesn't refresh views automaticaly. You can use REQUERY() Function to refresh a remote view when remote data has changed.
--sb--