Wizywyg
|
| Posted: 01/22/2003, 1:38 PM |
|
CCS = Does it generate the SQL (mysql) file to populate database?
Im trying the trial version, i dont see a sql file generated? Any ideas? Why? and if it doesn't create it, how do you create the file to import to your db?
|
|
|
 |
kangus
|
| Posted: 01/22/2003, 11:34 PM |
|
CCS builds applications, to build a database you use ER designers like ER Win or ER Studio. Or you learn DDL:
CREATE TABLE country_tax (
taxid int(11) NOT NULL auto_increment,
code char(2) NOT NULL default '',
provider char(32) NOT NULL default '',
tax_percent decimal(12,2) NOT NULL default '0.00',
tax_flat decimal(12,2) NOT NULL default '0.00',
PRIMARY KEY (taxid),
KEY provider (provider),
KEY code (code)
) TYPE=MyISAM;
Data definition language - > http://www.cecs.csulb.edu/~jewett/dbdesign/dbdesign.php...&imgsize=medium
|
|
|
|
RonB
|
| Posted: 01/22/2003, 11:58 PM |
|
" ...ER designers like ER Win or ER Studio."
Please dont make it sound more difficult then it is. For mysql you can use phpmyadmin wich is easy to grasp and free of charge. Throwing a few difficult words around makes using a database sound like voodoo and it's not. Creating a database in MYSQL is very easy and you do not need to have a degree in physics to do that. There probably is a nice book like mysql for dummy's that will teach you the basics in a few days and the basics is probably all you are going to need for starting a nice project in CC and CCS. For the more complicated projects it would be good to spend some time learning sql but again this isn't that hard.
Remember we are mostly talking about using a database for internet pages and the probability that you will need a gigantic oracle, transaction using, database is very small.
Ron
|
|
|
|
Wizywyg
|
| Posted: 01/23/2003, 12:23 PM |
|
I guess I wansn't clear enough...
DOES CCS create the sql file to populate the DB with? The examples do not have a sql file to go with to run them. (ie bookstore, task manager ), and if it does, where does that sql file go? I would like to see how the examples work so I can figure out how to use the program.
|
|
|
|
RonB
|
| Posted: 01/23/2003, 12:25 PM |
|
The applications that come with the software also contain the sql files for several databases including mysql. look under codecharge studio -> examples ->internet or intranet and you will see the .sql files. In case of mysql you can use phpadmin to run the file wich will populate the database you created for the project.
Ron
|
|
|
|
Wizywyg
|
| Posted: 01/23/2003, 12:35 PM |
|
So for all four examples it uses the one "internet.sql" file example?
|
|
|
|
Sue
|
| Posted: 01/23/2003, 3:19 PM |
|
MySQL Designer - I think it's cool :)
http://www.artronic.biz/index.php?pg=40
Not affiliated in any way ... The cheapest I have seen yet ... Bit far away though, but I got my key.
|
|
|
|
RonB
|
| Posted: 01/24/2003, 1:46 AM |
|
"So for all four examples it uses the one "internet.sql" file example? "
Yes
Ron
|
|
|
|
feha
|
| Posted: 01/24/2003, 6:06 PM |
|
You have a great tool as MySQL FRONT
at:
http://mysqlfront.venturemedia.de/index.php?act=ST&f=1&t=2&
It is great tool you can use to make db,tables etc...(db design)
regards
feha
[www.vision.to]
|
|
|
|
