Removing table prefixes

Posts   
 
    
Dordanov
User
Posts: 10
Joined: 28-Apr-2004
# Posted on: 28-Apr-2004 15:30:05   

Hello,

Today we received our LLBLGen license to start work with, and I have the following question on which I wasn't able to find an answer in neither help file nor this forum:

In our database we have tables prefixed with p_ (platform tables) some additional tables will be prefixed with a_ (application tables)

When in the future a plugin for our program will be made, for example a forum, it might be prefixed using f_ (forum).

I read at lots of places about how to remove prefixes from the tables. However I cannot seem to specify multiple types of prefixes wich should be removed.

Is there any way to specify multiple prefixes ? I tried using p,a as well as p;a but as far as I can tell it's simply read as one whole string.

Ofcourse I could edit the Entity names bij hand when importing from the catalog, but that is obviously not the best way to go.

Thanks in advance,

Regards, Dordanov

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 28-Apr-2004 15:48:44   

You can set one prefix at the time. For a new project, try to set the prefix in the project properties first to p, select add entities, select all entities which still have a prefix, click the toggle button, now only hte p* entities are checked, add them, etc.

It's not very common tables are prefixed differently, that's why just 1 prefix is used.

I'll add the ';' idea to the todo list.

Frans Bouma | Lead developer LLBLGen Pro
Dordanov
User
Posts: 10
Joined: 28-Apr-2004
# Posted on: 28-Apr-2004 17:07:34   

Ok thx for the suggestion, we'll have to work like that first I guess.

I know it's not a common way to have different prefixes, but it can't be changed, it's the way it's decided by the "Big Bad" boss wink

thx for the quick reply though.

Regards, Dordanov