> > Hi,
> >
> > I am desperately looking for a documentation on commands to set certain values in the vfpoledb-driver.
> > It took me a while to find out, that I have to "SET DELETED OFF" in order to retrieve items from a table with a delete-flag.
> >
> > Is there any complete cheat-sheet around what parameters are possible to set. Can't find anything on that except a sort of best-of-parameters.
> >
> > Thanks a lot in advance antoschka
>
> There is information in the VFP Help File. See under topics:
>
> OLE DB Provider for Visual FoxPro
> Language Reference for OLE DB Development
> Visual FoxPro OLE DB Provider Data Support
> Supported Visual FoxPro Commands and Functions in OLE DB Provider
> Unsupported Visual FoxPro Commands and Functions in OLE DB Provider
> Supported OLE DB Objects
> Standard and Custom OLE DB Properties
> Visual FoxPro Data Access Using the OLE DB Provider
>
>
> Regards
> Andy Kramek
> Microsoft MVP (Visual FoxPro)
> Tightline Computers Inc, Akron Ohio, USA

Hi, unfortunately I only found in "Supported Visual FoxPro Commands and Functions in OLE DB Provider" a list of commands without explaination.
Other Commands
DROP TABLE Command
SET ANSI Command
SET AUTOINCERROR Command

SET BLOCKSIZE Command
SET COLLATE Command
SET DELETED Command

SET ENGINEBEHAVIOR Command
SET EXACT Command
SET EXCLUSIVE Command

SET FULLPATH Command
SET MULTILOCKS Command
SET NULL Command

SET PATH Command
SET REPROCESS Command
SET UNIQUE Command

Furthermore the list seems not complete since commands like "SET HOURS" or "SET CENTURY" are not included - not in supported nor in unsupported Commands. By Trial and Error I know that they are supported.

Any Idea how to find out more on that, in order to find a complete list?

Thanks in advance

antoschka