>hi friend
>i have inserted like
>lform_type=['C']
>sqlexec(gnconnhandle,'insert into table1(form_type), Values (?lform_type)')
>sqlexec(gnconnhandle,'select * from table1 where form_type=?lform_type','tmpcurs')
>BUT I WANT CREATE VIEW IN MS SQL 2000
>I had try
>create view view1 as
>select * from table1 where form_type=(how to take command here )
>
>THANKS
Same way as in SPT:
create view view1 as
select * from table1 where form_type=?lform_type
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.