I've got a cursor I generate that has a ORDER BY clause that looks like:
ORDER BY Vehicles.Status,Vehicles.Vid
In my table these fields look like:
Status VID
Available M1
Available M2
Available M4
Available M3
Available M10
There are some other settings of Status, but that's not where my problem is. What I'd like to see if all of the Status entries are "Available" is a list that looks like:
M1
M2
M3
M4
M10
Instead, it shows up like:
M1
M10
M2
M3
M4
I know it's because it's treating the field as alphanumeric, not just numbers. I tried changing the ORDER BY clause to read:
ORDER BY Vehicles.Status,VAL(SUBSTR(Vehicles.Vid,2))
..so it reads the numeric value instead, but VFP doesn't seem to like it. It gives me an error about some missing fields (Column "Status" not found). Is there another way I can do this?
Thanks,