Author | Topic: dbesys foxpro 3 | |
---|---|---|
Nevzat Kanbur | dbesys 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 |