Alaska Software Inc. - dbesys foxpro 3
Username: Password:
AuthorTopic: dbesys foxpro 3
Nevzat Kanburdbesys foxpro 3
on Mon, 23 Jan 2017 15:04:11 +0300
Hi,

The followings that I use for foxPro 2x compatible.

IF !DbeLoad ( "FOXDBE", .T.) ; lSuccess := .F. ; ENDIF
IF !DbeLoad ( "CDXDBE", .T.) ; lSuccess := .F. ; ENDIF
IF !DbeBuild( "FOXCDX", "FOXDBE", "CDXDBE" )  ; lSuccess := .F. ; ENDIF

IF !lSuccess
    Alert( "FOXCDX Database-Engine could not be built" , {"OK"} )
ENDIF

/*
   The following two lines configure the FOXDBE to create
   FoxPro 2.x compatible files and use a FoxPro 2.x compatible locking 
scheme.
*/

DbeInfo( COMPONENT_DATA , FOXDBE_CREATE_2X, .T. )
DbeInfo( COMPONENT_DATA , FOXDBE_LOCKMODE , FOXDBE_LOCKMODE_2X )
DbeInfo( COMPONENT_ORDER, CDXDBE_MODE     , CDXDBE_FOXPRO2X    )     
FoxPro 2.x compatiblity

What is the foxPro 3 or later configuration should it be ?

Any help please
Nevzat
Andreas Gehrs-Pahl
Re: dbesys foxpro 3
on Mon, 23 Jan 2017 15:04:12 -0500
Nevzat,

>What is the foxPro 3 or later configuration should it be ?

The distinction is between FoxPro and Visual FoxPro (or VFP). To be 
compatible with FoxPro (versions 1.0 through 2.6), you need to use the 
DBE settings that you mentioned in your post. To be compatible with VFP 
(versions 3 through 9), you can use the default settings of the DBEs, 
or you can explicitly set them to the following (default) values:

DbeInfo(COMPONENT_DATA , FOXDBE_CREATE_2X, .f.)
DbeInfo(COMPONENT_DATA , FOXDBE_LOCKMODE , FOXDBE_LOCKMODE_VISUAL)
DbeInfo(COMPONENT_ORDER, CDXDBE_MODE     , CDXDBE_VFOXPRO)

The first setting only affects the creation of new database files. The 
second setting is only relevant if you use your database files concurrently 
from other FoxPro, VFP, or Clipper, applications. The third option is also 
only relevant if you use the index files from other FoxPro, VFP, or Clipper, 
applications.

Otherwise -- if your Xbase++ application is the only program accessing the 
database and index files -- those settings are actually of no importance.

I suggest you RTFM for the FOXDBE and CDXDBE for more details.

Andreas

Andreas Gehrs-Pahl
Absolute Software, LLC

phone: (989) 723-9927
email: Andreas@AbsoluteSoftwareLLC.com
web:   http://www.AbsoluteSoftwareLLC.com
[F]:   https://www.facebook.com/AbsoluteSoftwareLLC