General information
Category:
Forms & Form designer
You're going to have other problems besides slowness. You really shouldn't use data manipulation functions like TRIM() on the output fields of a SELECT statement. VFP will size the resulting column based on the first column encountered -- if your TRIM() results in a width of zero, well that's what you get.
Use views to create result sets. Do your data manipulation on the result sets -- not in the view definition.
>I've got a view that looks like this: create sql view "lvclientcharges" as select trim(clast)+', '+trim(cfirst),csac_id,chosp_id,dbirth,dcontact,nclient_id from clients where nclient_id in (select nclient_id from charge_visits) order by clast,cfirst
Previous
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