Recent content by satyenshanker

This happens when you create some objectes in that data session and did not kill them. Try this is command window x= "" DO FORM xx (form with private data session having the init code: x=CTREATEOBJECT("Custome") Close the form (by clicking on window close)...

You could do the same in the load event too. Satyen

There could be multiple reasons for GPF, most often one is a bad control source. Check and see if the control source for each object is ok and available. Satyen

Try clearing the resource file (SET RESOURCE OFF) before running the report. Satyen

I would search in the registry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Outlook Express Satyen

Are you sure there are not uncommitted transactions? Try =TABLEREVERT() =SQLROLLBACK(sn_ConHandle) Satyen

Since these forms are modal, you cannot run a event automatically after the read events. So, start a timer object and re-run the menu after a specified interval. Satyen

Sorry, I was off on a vacation so I could not get back to you in time. Can you post the SQL statement that you are trying. Satyen

Does any other SQL statement work? Satyen

I guess next time I have to try it first to get rid of such syntax errors. Thanks Satyen

When a modal form FoxPro automaticall disables all the menu bars. The only way to bring the menu back is by running the menu program again. The question is when? It has to be fired after the show event? Mmmm, what even fires after the show? Actviate .... No. . . . . . . . . . . We used a...

LOCAL ARRAY la_temp IF ANETRESOURCES(la_temp, "Network Name",1) > 0 *-- The array la_Temp will have the names *-- of all the computers on that network ENDIF Satyen

Do a requery after Table Revert. REQUERY() Satyen

Try giving the login and password along with the DSN name STORE SQLCONNECT('db_data', 'sa', "") TO gnConnHandle Satyen

It is great and you have use it on large data sets. Watch out for simple queries FoxPro rushmore tends to use the original table as the result set. Ex: SELECT * from sydtabl ORDER BY tablid WHERE tablid = "AP" ? dbf() You will notice it returns the original table. To fix it use...