Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View Parameter
Message
 
 
À
06/08/2005 17:33:54
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
01039109
Message ID:
01039110
Vues:
17
How SSN is stored in the table, with dashes or w/o? Does
SELECT tblcontributions
BROWSE FOR ssnumber = "222222222"
* or 
BROWSE FOR ssnumber = "222-22-2222"
displays any records?



>Trying a view for the first time with a parameter but have problems getting the data. Heres my SQL:
>SELECT Tblcontributions.*;
> FROM ;
>     data1!tblcontributions;
> WHERE  Tblcontributions.ssnumber = ( ?parssnumber );
> ORDER BY Tblcontributions.periodend
>
>When I run it and eneter a ss number as either 222222222 or 222-22-2222 it comes up empty in the browse.
>
>The ssnumber is a character type, size 11 with an input mask of 999-99-9999. Can't figure out what I am doing wrong.
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform