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 DATABASEThen right click and select New Local View... or New Remote View... depending on where the data is located.