Update sql ??  
Author Message
Padley





PostPosted: Tue Jun 27 07:00:24 CDT 2006 Top

Exchange Servers >> Update sql ??

Hi,

I have created a table in sql server enterprise manager.

I am able to view and change the data in the table but after closing vfp.
all the data is like it was before.

I have send sql update on in the view designer.

I'm very new in working with remote data.

could somebody please help me with a this.

thanks in advance Stefan

Exchange Server38  
 
 
AA





PostPosted: Tue Jun 27 07:00:24 CDT 2006 Top

Exchange Servers >> Update sql ?? If you use TableUpdate() it returns a value to indicate what happened. If it
didn't succeed use AERROR() to bring back the ODBC error message.
TableUpdate(2,,,) lets you include an array in the call which lists the
records that weren't properly updated.
Are you working with a remote view or with and SQLPassThrough (SPT) SELECT
and UPDATE commands?
-Anders



> Hi,
>
> I have created a table in sql server enterprise manager.
>
> I am able to view and change the data in the table but after closing vfp.
> all the data is like it was before.
>
> I have send sql update on in the view designer.
>
> I'm very new in working with remote data.
>
> could somebody please help me with a this.
>
> thanks in advance Stefan
>