Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create view in ms sql (where form_type=['C']
Message
From
15/11/2006 11:42:06
Arjun Bagojikop
Dynamic Super Software
Sangli, India
 
 
To
15/11/2006 11:25:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01169818
Message ID:
01169921
Views:
7
yes friend
i know
but when i was trying to make query in sql query analyzer for testing
that time this problem occured me . i am very try to get solution
but i dont know about how to get field with quot mark

now i am creating a procedure as per your preper

create procedure formlist @form_type char(10) as
select * from table1 where form_type=@form_type
exec formlist '''C'''

IN VFP
SQLEXEC(GNCONNHANDLE,'EXEC FORMLIST ?LFORM','TMPCURS')


THANKS a lot of again
Arjun
Previous
Reply
Map
View

Click here to load this message in the networking platform