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
Divers
Thread ID:
00854846
Message ID:
00854850
Vues:
33
I have never been able to. I think I even tried to hack the view by putting an ampersand after the question mark. All to no avail.

>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!
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform