Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can this be done in a view??
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Can this be done in a view??
Divers
Thread ID:
00854846
Message ID:
00854846
Vues:
65
employee_id field is Integer...

This works:

SELECT * from audits WHERE employee_id in (12,35)


This doesn't:

lcEmployeeString = '12,35'

SELECT *;
FROM audits Audits;
WHERE ALLTRIM(STR(Audits.employee_id)) IN (?lcEmployeeString)


I also tried this:
lcEmployeeString = "'12','35'"
lcEmployeeString = '12,35'
lcEmployeeString = "('12','35')"

Can I even do this in a remote view?

Thanks!
ICQ 10556 (ya), 254117
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform