Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL statement is not working...
Message
From
29/07/2005 10:24:50
 
 
To
29/07/2005 10:07:00
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01036917
Message ID:
01036976
Views:
17
>The problem is solved, this is my code now:
>
>SET EXACT ON
>m_trim_lidnrfactuur = ALLTRIM(m_lidnrfactuur)
>
>SELECT branche, debnr, factuurnr, factuurdat FROM m_facturenbestand ;
>WHERE VAL(debnr) == VAL(m_trim_lidnrfactuur) AND ;
>branche = m_branchenrfactuur AND ;
>INT(VAL(pagina)) = 1 ;
>INTO TABLE temp4
>
>Greetings,
>Ron

I also Set Exact On in my startup program, and never set it off!
Previous
Reply
Map
View

Click here to load this message in the networking platform