Data Access Worldwide Knowledge Base
Article Text
PROBLEM:
When I use Load_Def to create tables in an SQL backend, the table is created as a standard table -- i.e. without a recnum field.
SOLUTION:
The DF_FILE_RECNUM_TABLE attribute that could be used to set the table to recnum table is not a defined attribute in any pre-VDF11 environment. If you need to convert files (or create tabled) using a pre-VDF11 Database Builder, you will need to use Connectivity Kit build 4.1.0.10 or higher (*) -- recnum field will be created and you should have no problems accessing those tables from a pre-VDF11 application.
(*) You can also choose to use version 3.x or lower of the Connectivity Kits.
Some tests performed show the default behavior of build 4.1.0.10 in a VDF11 environment and in a VDF10.1 environment:
VDF11.1
- Converted DataFlex table -> recnum table created
- Loaded DEF from DataFlex table -> recnum table created
- Loaded DEF from MSSQL table -> recnum table created
- Created new table ->>> standard table created
- Added field to MSSQL table (converted from DataFlex) -> structure changed and table is still recnum table
- Connected to native MSSQL table ->>> no problem for not having numeric identifier
- Moved MSSQL table filelist entry -> no problem; table moved
VDF10.1
- Converted DataFlex table -> recnum table created
- Loaded DEF from DataFlex table -> recnum table created
- Loaded DEF from MSSQL table -> recnum table created
- Created new table ->>> recnum table created
- Added field to MSSQL table (converted from DataFlex)-> structure changed and table is still recnum table
- Connected to native MSSQL table ->>> connection not possible; table without numeric identifier
- Moved MSSQL table filelist entry -> no problem; table moved
Note:
Build 4.1.0.10 of the CLI Connectivity Kits will be installed with Visual DataFlex 11.1 release.
Contributed By:
Marcia Booth
Company: Data Access Worldwide
Web Site: http://www.dataaccess.com
Web Links Related to this Article
Bug 3604: Creating a new table using structure_start using CK 4 and VDF 10.1 or earlier cannot create RECNUM tables
URL=http://www.dataaccess.com/BugTracker/PrintBug.asp?ArticleID=3604
Email this Article
Email this Article to a Colleague
Send Feedback on this Article to Data Access Worldwide
Copyright ©2010 Data Access Corporation. All rights reserved.
| The information provided in the Data Access Technical Knowledge Base is provided "as is" without warranty of any kind. Data Access Corporation disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall Data Access Corporation or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Data Access Corporation or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply. |