Database Mappings
Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Calendar
Forum Description: Topics Related to Codejock Calendar
URL: http://forum.codejock.com/forum_posts.asp?TID=19700
Printed Date: 14 May 2024 at 11:10pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Database Mappings
Posted By: Boris
Subject: Database Mappings
Date Posted: 27 April 2012 at 4:28am
|
Hi
I have decided to move to SQL Server .... YAY !! I used the upsizing wizard and all went ok. Good.
I have adjusted my VB6 code to use a custom provider and apart from minor changes it works. What I have found however is that the recurrence tables do not seem to map to the SQLDataHelper column names. I can see that some of the names in this code do not appear in the database table at all and some are misspelled. It is not immediately obvious how to map the columns. Can somebody provide a list of mapped columns between the Access version and the SQLDataHelper so I can rename or add tables etc?
------------- Boris Product: Xtreme SuitePro (ActiveX) version 16.4.0 16.3.1 Platform: Windows XP (32bit) - SP 3 Language: Visual Basic 6.0 SP6 VS 2005-2008-2010-2013 |
Replies:
Posted By: SuperMario
Date Posted: 27 April 2012 at 1:15pm
| there is a VB6 sample "CustomCalender" sample that shows this. With custom provider "you" make the tables, fields, etc, so the names are not important. What is important is that you give the calendar the correct information when it asks. |
Posted By: Boris
Date Posted: 27 April 2012 at 1:19pm
|
Hi
There are very important as I have shipped the CJ Access database with a few mods in to all my clients. When I have upsized their databases the Sql helper does not work. I don't want to map to the wrong field in case it breaks what they already have.
Does that explain the issue better?
Regards
Boris ------------- Boris Product: Xtreme SuitePro (ActiveX) version 16.4.0 16.3.1 Platform: Windows XP (32bit) - SP 3 Language: Visual Basic 6.0 SP6 VS 2005-2008-2010-2013 |
Posted By: SuperMario
Date Posted: 27 April 2012 at 9:49pm
| Still not an issue, simply use the same tables and fields you used in the access database. |
Posted By: Boris
Date Posted: 28 April 2012 at 10:18am
|
Hi Mario
If you read my post you will understand that it does not work!! I.E The Access database that Codejock shipped does not map to the RecordSet fieldnames that exist in the SQL Custom Provider. I would recommend that you actually have a look at the code . Believe me I have and it just fails on Debug.Assert over and over again. ------------- Boris Product: Xtreme SuitePro (ActiveX) version 16.4.0 16.3.1 Platform: Windows XP (32bit) - SP 3 Language: Visual Basic 6.0 SP6 VS 2005-2008-2010-2013 |
Posted By: SuperMario
Date Posted: 30 April 2012 at 12:22am
| There is only a custom provider, it don't care what names you use. Did you look at the VB6 custom calendar sample? |
Posted By: Boris
Date Posted: 30 April 2012 at 3:16am
I have shipped the code that I first had when I bouth CJ back in Version 10. ?? Have you changed the provider code since then. I have found that the recordset now refers to a field called UseEnd wheareas in mine it refers to EndMethod. I will take the code from the latest cut and use this from now on. Thanks for your time ------------- Boris Product: Xtreme SuitePro (ActiveX) version 16.4.0 16.3.1 Platform: Windows XP (32bit) - SP 3 Language: Visual Basic 6.0 SP6 VS 2005-2008-2010-2013 |
Posted By: danypd69
Date Posted: 02 May 2013 at 4:14am
|
Hello Boris, I have the same problem. Have you solved it ? |