General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Parameterized views
Hello,
I am a Foxpro 6 beginner, and I have written a Foxpro report based on a parameterized view. This view compares the alphanumeric parameter to an alphanumeric field ACNO in its base table to select its records.
My problem is that the parameter the report passes to the view can be either in the form of a word (as in "PAUL") or a number (as in "5515"). I have both these examples stored in the field ACNO.
I find that the report will show beautifully when "PAUL" is used as the parameter, but flashes on and off (because the report is empty) when the parameter is "5515". For some reason the view does not like to compare alphanumeric fields to a parameter where the parameter is a number (as far as I can see). I can find no other reason for this event.
How do I get round this?
Thanks,
Trimtro
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only