This topic is locked

table names

6/15/2006 2:31:02 AM
PHPRunner General questions
K
ken.stessens@telenet.be author

Hi there,
When adding a new table, an underscore ('_') is automatically inserted at the beginning of the table name (WHY?).
Let's say I have 3 tables:

_customers (I did type 'customers')

_requests (I did type 'requests')

_orders (I did type 'orders')
On the 'formatting tab' page, I select the '_requests' table and I use the 'wizard lookup' to select a customer from the list to be added in the corresponding row for the '_requests' table. The same procedure for the '_orders' table (none of the tables are linked as Master-Details).
However, in the dropdown box of the wizard lookup, the following list appears:

_customers

_orders

_requests

<Select table>
So the list order is alphabetically, but due to the underscores, the '<Select table>' option is at the bottom and not on the top as it should be. The problem is that the following drop down boxes are not rendering for the first option, so I cannot select the '_customers table' because it is on top of the list. On the other hand, it is possible to select the '<Select table>' option at the bottom, resulting in the following drop down boxes to render, which does not make sense.
It looks like we're having a bug :-) ?

great job though!
cheers,

Ken

J
Jane 6/15/2006

Ken,
thank you for pointing me to this bug.

We'll fix it in the next PHPRunner update.

K
ken.stessens@telenet.be author 6/15/2006

Hi Jane,
no problem. I need to register in a couple of days, so maybe you can give some discount :-)
Anyway, I guess the underscores at the beginning of the table names are there on purpose (you should have seen those if not). why is that?
I got around the listing problem by creating a dummy table with the name '__' (double underscore). It gets on top of the list (being unselectable), and the other tables listed correctly.
Kind regards,

Ken

Sergey Kornilov admin 6/15/2006

Ken,
we add undescore in front of manually created tables. The purpose is to separate manually created tables from the rest of tables. Tables with underscore in front appear on the top of Datasource tables screen.
We'll fix this problem with tables list on Lookup wizard screen.
You may contact me directly at support@xlinesoft.com to talk about discount.