CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> Wishes

 prefixed tablenames

Print topic Send  topic

Author Message
wkempees


Posts: 1679
Posted: 05/21/2007, 8:11 AM

Wouldn't it be nice, to have CCS prefix table names.

Situation:
We are developing on a development system (f.i. XAMPP).
Building database tables (the schema) and building the application.
Each Page Form Grid etc is tied to the SQL through DataSource (VQB).
Now comes deployment time, using the ProjectSettings, Server Profile setting we define the parameters for the target system.
Through 3rd party tooling we move the tables to the target SQLDatabase, using the Profile we publish everything to the Server.
Testing follows and if all is well we are up and running.

Then comes the moment when others get interested in your application, cheerfully we create a third profile and publish to the new customers server.

As is popular in various other applications (Joomla, Mambo, CMSMS) we would like to create our tables with a prefix xxx_.
This would mean we would have catered for this in advance in which case tables will be prefixed but with the stress on fixed.

Therefore I submit this wish:
have a facility in Profile Setting to (optionally) set a table prefix per profile


Walter








_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message
wkempees


Posts: 1679
Posted: 07/02/2007, 3:13 PM

seconded by

http://forums.codecharge.com/posts.php?post_id=88655

Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message
roeya


Posts: 181
Posted: 07/03/2007, 12:52 AM

May be I am missing something

But why not create new database with the same table names, then all you have to do is change the connection string ?
_________________
http://www.infoneto.com/
View profile  Send private message
mamboBROWN


Posts: 1713
Posted: 07/03/2007, 10:50 PM

roeya
Because sometimes you may have a user/client that can only have one database (unless they are willing to pay extra money). By allowing them to be able to prefix the tables you can have more then one applications tables in the same database (thus cutting down cost-among other things).

Thirded by mambobrown :-D.
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.