Bug 3965: Conversion Wizard: Converting Recnum table to standard table could generate errors in Recnum indices

Product: Dataflex 11.1
Component: Database Builder
Current status: Fixed/Implemented
Fixed in Build: 11.1.104.0 and component revision 11.1.53.3 on 01/04/2006 in file n/a
Logged by: Marcia Booth on 09/08/2006
Last edited by: Marcia Booth on 09/08/2006
Reported by: Quality Assurance of Data Access Worldwide
First reported in: Visual Dataflex 11.1
Tested by: Marcia Booth on 09/08/2006 using build 11.1.104.0 and component build 11.1.35.2

Bug Text

The conversion wizard replaces all references to recnum in existing indices with the columns of the primary key when converting from Recnum table to standard table. If the index already contained one (or more) columns of the primary key, an error would be generated -- SQL backends do not allow columns to be repeated in the same index. We now check if the column is already part of the index and if so, do not add it.

Workaround

Solution: Unzip the attached zip file and place the DBBldr.exe in the Bin folder of your Visual DataFlex 11.1.

Email this Bug
Email this Bug to a Colleague
Send Feedback on this Bug to Data Access Worldwide

Web Links Related to this Article
File DatabaseBuilder_11.1.53.3.zip
URL=http://www.dataaccess.com/BugTracker/files/3965.DatabaseBuilder_11.1.53.3.zip

The information provided in Data Access BugTracker 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.