SQL VIEWS.

[Guntruck]

Im able to create a SQL view, and grab a table from a MS SQL 7 server. But once I have that info populated into a grid, is there a way I just just edit that data and have it automatically updated on the sql server? Im really new to doing this, so excuse my oversights.


Dave

 

[weedz]

When you wish to update the view, you should issue a tableupdate().

For further info on table update, check out the item in the MSDN.

HTH,
Weedz (Wietze Veld)

http://www.crowncap.demon.nl

veld4663@exact.nl
The Netherlands

They cling emotionally to code and fix development rather than choosing practices based on analytical assesments of what works best.

After the GoldRush - Steve McConnell

 

[foxdev]

If you created the view with the View Designer, be sure that you've checked the Send SQL Updates box and identified a primary key. Otherwise, updates won't be sent. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[Guntruck]

Ok, sweet I got this thing goin, but what is happening when I get an update conflict!?


It still seems to update, yet i always get the error after I close the form im using.


Dave

 

[weedz]

Could you tell us what the error is ??

If you have an update error your error handling system should catch the error. This is totally up to you how you let your users know the record cannot be updated.

If the tableupdate returns .F. you can check the AERROR array what the error is and catch it to present your users with a message.

Explanation about AERROR can be found in the MSDN. Weedz (Wietze Veld)

http://www.crowncap.demon.nl

veld4663@exact.nl
The Netherlands

They cling emotionally to code and fix development rather than choosing practices based on analytical assesments of what works best.

After the GoldRush - Steve McConnell

 

[foxdev]

You may need to add a statement TABLEREVERT() to your cancel button or form unload, in addition to Weedz suggestions. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org