>It is giving me a unrecognized phrase/keyword error:
>
>create sql view trouble_ticket as;
> select top 1 Trouble_ticket.trouble_ticket_id,;
> Trouble_ticket.tt_problem, Trouble_ticket.tt_solution,;
> Trouble_ticket.tt_sent_to_tech, Trouble_ticket.tt_monitor_name,;
> Trouble_ticket.system_serial, Trouble_ticket.tt_location_city,;
> Trouble_ticket.tt_location_address,;
> Trouble_ticket.tt_datetime_of_ticket,;
> Trouble_ticket.tt_datetime_of_incident,;
> FROM dbo.Trouble_Ticket
>
>I also tried: create remote view trouble_ticket as;....
>
>and it said there was a syntax error
>
>can 'top' be used in visual foxpro 6?
>I know it can be used in sql server 7.
You may have to use SQL Passthrough instead of a remote view. Look up SQLCONNECT() and SQLEXEC() in VFP Help.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.