Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using OPENQUERY with a parameter
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Using OPENQUERY with a parameter
Environment versions
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01010162
Message ID:
01010162
Views:
67
How do I use a parameter within an OPENQUERY

THIS WORKS
select * from openquery(VFP2,
'
select * from arcust
)




NOW I WANT TO INCOPORATE A PARAMETER - DOES NOT WORK

declare @id varchar(10)
select @id = "54440"

select * from openquery(VFP2,
'
select * from arcust where ccustno=@id
'
)

Any help is appreciated
Thanks
Carmel
Next
Reply
Map
View

Click here to load this message in the networking platform