I just downloaded & installed SC without errors. When I select Database Builder, nothing happens. I’ve tried before creating a new project and after creating. It gets to the point of wanting to connect to a database but I don’t have one yet. I assumed I could use the Builder but it does not load. How do I get started with a new database. This is for MySql
Thanks,
TR
[SIZE=11px][B]Tags:[/B] [FONT=inherit]None[/SIZE]
[/FONT]
Well, I haven’t used the database builder in SC, but since you are stuck and want to get on with it now, you could do the same as many do:
Just create the database directly with a database tool. For MySQL there is the MySQL Workbench. Its free to download and install for Windows, Linux and Mac OS X, and I find it to be an excellent graphical database tool. With it you can easily define new databases (schemas) as well as tables. The table builder tool is very neat, efficient and easy to use.
Another option is the browser based phpMyAdmin tool.
After you have build a database, you can create a connection to it in your project through SC.
The problem is that with scriptcase you get a webserver (apache) and scriptcase but no database. So you need to install a database first. If you work on windows you could consider to install wamp. That will implement a production - like environment on port 80 including a mysql database. Before you deploy your applications to the web you can first deploy to wamp to see how the application behaves outside scriptcase in a controlled environment. We feel comfortable by working that way. Once you have mysql installed you can use the database designer, but I agree on orion, it’s not the best product. It’s ‘adminer’ and it has a lot of flaws. But on mysql it works.
Thanks for the suggestions. I created the database with phpmyadmin, then Data Builder allowed me to add/edit tables.
If you want to do inside SC, You must create the database from connection window. Its the natural way to do it.