Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Parameter
Message
 
 
To
06/08/2005 17:33:54
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01039109
Message ID:
01039110
Views:
16
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform