HI SHelbytl,
The Dataenvironment has its own environment and it nneds to have its own set of SET commands. What I do is.. create a set_environment as a procedure at the end of my Main.PRG and it contains all my set commands..
** My default environment settings
*********************************************************
PROCEDURE set_environment
SET CENTURY ON
SET CONFIRM ON
SET CURRENCY TO "Dhs "
SET DATE BRITISH
SET DELETED ON
SET EXCLUSIVE OFF
SET MESSAGE TO
SET MULTILOCKS ON
SET NEAR ON
SET NOTIFY OFF
SET REPROCESS TO AUTOMATIC
SET SAFETY OFF
SET STATUS BAR OFF
SET SYSMENU OFF
SET TALK OFF
ENDPROC
*********************************************************
Then my form class has in its Load event..
DO set_environment
DODEFAULT()
and teh same code is repeated in the Dataenvironment.BeforeOpenTables event if any SQL or VIEWs are used.
This take care of the issues.
Hope this helps you

ramani

(Subramanian.G),FoxAcc, ramani_g@yahoo.com