ccangel
Posts: 3
|
| Posted: 05/13/2010, 12:24 PM |
|
Hi,
I am try out CC4.3 trial version to generate PHP code and to connect to my MySql 5.x server using myODBC 5x.
I am able to connect to the server and build application. CC documentation shows that it has capability to understand the foreign key relationship between two tables and will show such relationship in a GUI format. But, the project that I generated didn't show such relationship. Is this because I am using a trial version? Please help.
Another question: is there a way to resync CC to MySQL DB? For example, after we generate an application, is it possible to resync that application to its DB for any changes made to the DB files like change of column names or adding a new field to a file in DB?
Thanks,
_________________
CCAngelFly |
 |
 |
jjrjr1
Posts: 942
|
| Posted: 05/13/2010, 2:41 PM |
|
You gotta use the MySql connector 3.1 CCS does not work with ver 5.
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com |
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 05/13/2010, 5:40 PM |
|
jjrjr1,
I have to disagree with you. The MySQL 5.x odbc does work with CCS 4.3 (at least it does with Windows XP using the XAMPP stack).
ccangel
What development stack are you using?? XAMPP or Wampserver?? Have you setup your Mysql user account correctly??
|
|
|
|
andy
Posts: 183
|
| Posted: 05/14/2010, 1:58 AM |
|
Check out this thread. See Melvyn's final comment.
http://forums.yessoftware.com/posts.php?post_id=110587
_________________
Andy
RAD tools for rich UI controls:
http://www.koolphptools.com |
|
|
|
ccangel
Posts: 3
|
| Posted: 05/17/2010, 8:54 AM |
|
Thanks for the input. Really appreciate it.
I am using Vista Pro Box with MyODBC 5.1.6 32 bit. My database is running off a LAMP stack. Both the linux box and Vista box are in the same private network. I am using root user to connect to the database.
I tried with MyODBC 3.1 and the problem persists.
Please help.
_________________
CCAngelFly |
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 05/17/2010, 6:10 PM |
|
ccangel,
In regards to your first question. While CCS does recognize foreign key relationships in a database it will only generate web pages based on tables and or views in the database. It will not generate web pages based on a relationship of multiple tables.
In regards to your second question, Once you generate the application you have a few choices of keeping the generated code in sync with the updated database.
Choice 1: regenerate the page(s) that are effected (you will have to re add your custom code)
OR
Choice 2: add the updated database fields to the effected page(s) yourself (Easiest and best choice-No loss of custom code.)
OR
Choice 3: regenerate the whole application again based on the new database updates and start all over adding your custom code.
There actually is a fourth choice but in my opinion it is way to complicated. It involves merging of different versions of code in your source control software. By far, Choice 1 or 2 are the best choice.
|
|
|
|
tallmik
Posts: 23
|
| Posted: 05/17/2010, 6:45 PM |
|
I'm using 5.x mysql odbc on XP, and it works fine... and i pretty much only use InnoDB.
Just select the datasource from the left hand column, and right-click, selecting "refresh" and CCS knows about the new DB structure.
You are on your own as far as putting changed/new columns on your pages and custom code tho.
Just in the process of putting up a Win7 box with CCS/Xampp (as well as lamp environments running in Virtual Box).
M.
|
|
|
|
datadoit
|
| Posted: 05/18/2010, 5:43 AM |
|
CCS has had that "Save Builder Options" checkbox in since v3, but it
doesn't -do- anything. I think where that was going was to be able to
go back through the builder and add columns, sorts, etc. after database
edits.
I think that would be a tremendous feature to have.
|
|
|
|
ccangel
Posts: 3
|
| Posted: 05/18/2010, 11:00 AM |
|
Thanks everybody!!
It would be great if we can have database sync function at code level in new CCS release.
_________________
CCAngelFly |
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 05/18/2010, 7:06 PM |
|
ccangel
Make sure you add it to the wishes forum.
|
|
|
|
