>Hi guys,
>
>just want to know, if anyone have some sample code on howto use SQL in a text box, I want to choose something from combo as a criteria in a SQL statement, but once i form a statement, what should i do? insert into cursor? and how do i insert SQL result as textbox values.

lcSql = [select * from ]+allt(cbo.cisplayvalue)+[ into cursor mycursor]
&lcSql
if _tally > 0
   textbox.value = allt(mycursor.somefield)
endif

>and how to create a predefined view, for example, i want to create a customized cursor view in >the database pulling data from multiple dbf. where would i do that without having to write >code? i tried using the GUI query stuff, but not work...

MODIFY DATABASE

Then right click and select New Local View... or New Remote View... depending on where the data is located.