General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to create view in ms sql (where form_type=['C']
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only