Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Calendar
  New Posts New Posts RSS Feed - Database Mappings
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Database Mappings

 Post Reply Post Reply
Author
Message
Boris View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 June 2007
Location: United Kingdom
Status: Offline
Points: 179
Post Options Post Options   Thanks (0) Thanks(0)   Quote Boris Quote  Post ReplyReply Direct Link To This Post Topic: Database Mappings
    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
Back to Top
SuperMario View Drop Down
Admin Group
Admin Group
Avatar

Joined: 14 February 2004
Status: Offline
Points: 18057
Post Options Post Options   Thanks (0) Thanks(0)   Quote SuperMario Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Boris View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 June 2007
Location: United Kingdom
Status: Offline
Points: 179
Post Options Post Options   Thanks (0) Thanks(0)   Quote Boris Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
SuperMario View Drop Down
Admin Group
Admin Group
Avatar

Joined: 14 February 2004
Status: Offline
Points: 18057
Post Options Post Options   Thanks (0) Thanks(0)   Quote SuperMario Quote  Post ReplyReply Direct Link To This Post Posted: 27 April 2012 at 9:49pm
Still not an issue, simply use the same tables and fields you used in the access database.
Back to Top
Boris View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 June 2007
Location: United Kingdom
Status: Offline
Points: 179
Post Options Post Options   Thanks (0) Thanks(0)   Quote Boris Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
SuperMario View Drop Down
Admin Group
Admin Group
Avatar

Joined: 14 February 2004
Status: Offline
Points: 18057
Post Options Post Options   Thanks (0) Thanks(0)   Quote SuperMario Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
Boris View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 June 2007
Location: United Kingdom
Status: Offline
Points: 179
Post Options Post Options   Thanks (0) Thanks(0)   Quote Boris Quote  Post ReplyReply Direct Link To This Post 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 timeApprove
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
Back to Top
danypd69 View Drop Down
Newbie
Newbie


Joined: 29 May 2012
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote danypd69 Quote  Post ReplyReply Direct Link To This Post Posted: 02 May 2013 at 4:14am
Hello Boris, I have the same problem.
Have you solved it ?
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.188 seconds.