Thanks will look at that.

At 11:51 13/07/2004, you wrote:

>> Good day
>> =\-=\=\==-\
>>
>> I want to know if how I understand VIEWS are correct.
>>
>> The view is a query stored on the server that gets run when the
>> user executes it.
>> if a where clause is added to the VIEW from a query as in :
>>
>> select * from myVIEW where ref_no >= 4599
>>
>> the Server will FIRST execute the View then implement the where
>> clause on the views result.
>>
>> Otherwise only views that is on ONE table can be updated.
>>
>> Thanks in Advance for any responses.
>>
>> Yours Sincerely
>>
>> Johannes Pretorius
>>
>
>yes to all but you can update any field in a view as long as you construct
>the update SQL yourself. You are actually updating the source table/column.
>IBO components make this quite easy if you use them.
>Alan
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004


[Non-text portions of this message have been removed]