Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Differencing an upper case from a lower case in a query
Message
From
27/11/2002 12:10:12
 
 
To
27/11/2002 11:57:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00727620
Message ID:
00727626
Views:
8
m.texto="%"+UPPER(alltrim(thisform.pageframe1.page1.pageframe1.page5.text1.value))+"%"
if empty(m.texto)
=messagebox("please type something")
else
select llamadas.detalle as problema, llamadas.solucion as detalle;
from llamadas;
where UPPER(llamadas.detalle) like m.texto ;
and llamadas.bdc = .t. ;
into cursor bcproblemas3
report form bcinforme.frx preview
endif


Just understand that the query will take a little longer(*) unless you have and index on UPPER(detalle)

(*) shouldn't be noticable (unless you have an index on detalle)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform