>I can generate the create sql view code ok. What I need to do is update the DBC on the remote computer when I send an updated exe to the customer. Do you have a good way to do this?
>
>TIA
>
>>You can use eview out of the files section to do that.
>>You also can do it with coding.
>>look at create sql view as select ...... in the help
>>Chapter 8 of the programmers guide is very helpfull too. Halfway there is a sample of how to do this.

---

That was that the previous posting was meant for.
For the last thing here is some code i use to create the view Groepen in my database.
Be sure the proper database is open and set active when you call this code.

	Create SQL View Groepen As;
	Select Kostgrp.groep, Kostgrp.omschrijvi, Kostgrp.printen,;
	  Kostgrp.bestgrp, Kostgrp_a.omschrijvi;
	 From  flexdata!kostgrp Inner Join flexdata!kostgrp Kostgrp_a ;
	   On  Kostgrp.bestgrp = Kostgrp_a.groep;
	 Order By Kostgrp.groep
	DBSetProp('Groepen.Groep','Field','KeyField',.T.)
	DBSetProp('Groepen.omschrijvi_a','Field','Updatable',.T.)
	DBSetProp('Groepen.printen','Field','Updatable',.T.)
	DBSetProp('Groepen.bestgrp','Field','Updatable',.T.)
	DBSetProp('Groepen','View','SendUpdates',.T.)

To remove a view use:

	Drop View lvStafArt

Hope this helps you