>Vlad,
>I understood that a View was a SQL, and I know that if TALK is ON that the results will be displayed, but I have TALK set to OFF in the "form" INIT & LOAD events. This is what has been driving me crazy. Putting the same SET's in the BeforeOpenTables I did not know about, but it works. Tis a puzzlement.
>
>If placing the SET TALK OFF works in the BeforeOpenTables so well, then do we have to bother placing it in the INIT? It seems redundant.
The problem here is that Form Classes don't have DataEnvironment, so you have to put this command in BeforeOpenTables of DE each time for each new form, which is inconvenient. Lots of developers here use programmatically created DE, but I've never done this. I prefer to open all my tables (viewes) in Load event of the form and don't put tables in DE. This is just a personal preference.
Anyway, you have to put set talk off in your form class Load event (no need to do it in Init) and manually add it in BeforeOpenTables, if you use form's DE.
>
>>Hi!
>>View is really an SQl Select query (SELECT-SQL command in VFP). This query when runs cause reporting of running result when TALK is ON. Opening view - same as running query.
If it's not broken, fix it until it is.
My Blog