Search problem

General questions about NeoBook

Moderator: Neosoft Support

Locked
User avatar
Dixan
Posts: 54
Joined: Sat May 14, 2016 2:48 pm

Search problem

Post by Dixan »

Dear friends, I have a new problem with the search:

strparse "NOMBRE.APELLIDOS.SEXO.EDAD.RAZA.PROVINCIA.PASAPORTE.AAM" "." "[campo]" "[nc]"
strparse "!=.=.=.<=.=.=.=.?" "." "[campotype]" "[nct]"

SETVAR "[BSAND]" "AND"
SETVAR "[BSOR]" "OR "

setvar "[filter]" ""
Loop "1" "[nc]" "[c]"
if "[VACCOL[campo[c]]]" "<>" ""
setvar "[filter]" "[filter] [campo[c]][campotype[c]][#34][VACCOL[campo[c]]][#34] [BSAND]"
endif
endloop
strlen "[filter]" "[len]"
substr "[filter]" "1" "[len]-4" "[filter]"

If "[Filter]" ">" ""
dbfQuery "VACCOL.dbf" "[Filter]"
Else
dbfShowAll "VACCOL.dbf"
EndIf

The problem now is how to search the "AAM" because the data is storaged as dd/mm/aaaa ([VACCOL.AAM]) and in the search I want to get all the data if that textentry box has a date writed in it just writing an X in the textentry box ([VACCOLAAM])
Dix@n
Locked