General information
Category:
Coding, syntax & commands
I removed all the ALLTRIM()'s out of my query. But still I get all the numbers that have a '5' (like in my example) This is the query:
SELECT branche, debnr, factuurnr, factuurdat FROM m_facturenbestand ;
WHERE debnr = m_lidnrfactuur AND ;
branche = m_branchenrfactuur AND ;
INT(VAL(pagina)) = 1 ;
INTO TABLE temp4
But..........
If I say like this:
SELECT branche, debnr, factuurnr, factuurdat FROM m_facturenbestand ;
WHERE VAL(debnr) = VAL(m_lidnrfactuur) AND ;
branche = m_branchenrfactuur AND ;
INT(VAL(pagina)) = 1 ;
INTO TABLE temp4
I don't get any records at all ?! I only added the VAL() function in my query.
I really don't know how to solve this one......
Greetz,
Ron
Previous
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