Selecting Views

[apcapc]

Does anyone know if you can select views in a program as you would tables and if so what the correct code to use would be

Many Thanks

Andy

 

[SQLDenis]

Same syntax like a table

select * from table
select * from view

http://sqlservercode.blogspot.com/

 

[apcapc]

Thanks for that, I can select from a view when I have it open in my data session but what I want to do is write a program that can be reused again and again. If I was to do it with a table I would write the following

use c:\mytable.dbf in o shared

but I can't do this with a view can I?

All I basically want to be able to do is update a field in one view with data from another view but I can't have both views selected as open at the same time as you can with tables

REPLACE customer_lastinvoicedate WITH invoiceheader_invoicedate all

The above code just doesn't work

Help please!!!

 

[SQLDenis]

You are talking about FoxPro I assume?
This is a SQL server forum, maybe someone else can help you with that

http://sqlservercode.blogspot.com/

 

[apcapc]

Apologies, still getting used to Tek Tips layout