Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Just a syntax
Message
 
À
28/05/2003 12:02:07
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Divers
Thread ID:
00793267
Message ID:
00793584
Vues:
32
SELECT * ;
FROM mytable ;
WHERE ctype IN 'M','B','D'
****
sorry , i got you confused, but
let me put my question in that way:

How to create and populate remote parameterized view that requires lists of parameters ?
****
Actually i found the one way, it's not the best thing in the word, but it works

CREATE SQL VIEW My_view;
REMOTE CONNECTION sql_conn1;
As select * from my_table ;
where my_table.type =?ctype OR my_table.type =?ctype1
**********************************************************

As i said before i worked with parameterized local views :

Create SQL View lv_view AS
Select * from my_table;
where Inlist(my_table.ctype, ?&ctype)

ctype=" 'A', 'B', 'C' "
requery('lv_view')

but it doesn't work with SQL SERVER.

thank you, sorry for bothering you
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform