2. PHPRunner General questions
  3. [SOLVED]  master detail - not autoincrementing
This topic is locked
[SOLVED]

 master detail - not autoincrementing

 		6/30/2011 4:00:38 PM
PHPRunner General questions
B
 bluepoint author

I have a simple table customers and table orders ...master detail hello world data base structure. The detailed orders table field ID is not auto incrementing and hence the second record can not be added as it has the same ID as the first record.... I read this post below but none of this helped. It seem to imply that their is a bug in 5.3 an greater. But this is a very basic thing to do so I cannot believe the product has a bug in it like this ....it auto increments fine in mysql web based table programme on my host company. It just does not do this in the phprunner application when I do an add detailed record to the orders table from the masters table....
I am reviewing the product for purchase but already ran into two issues that should be very basic but do not seem to be straight forward. It make me fear there are many issues like this in the product.
http://www.asprunner.com/forums/topic/13731-master-detail-inline-add-not-working-5-2/pagefromsearch1
C
 		cgphp 6/30/2011

bluepoint,
if you have updated your db in the mysql web based table program, remember to resync the db in PHPrunner before to perform a new build.
http://xlinesoft.com/phprunner/docs/list_page_options.htm
B
 		bluepoint author 7/1/2011

Thanks CGPHP, but I have done that 50 times, I have even drop the tables readded them, even restarted from scratch again...still the same thing....very bizarre as this is a very very basic thing.....
I have scanned the forum, and apparently their are allot of people having this same problem...never really saw solutions....
Sergey Kornilov admin 7/1/2011

Looks like something is not right with setup. For instance, you cannot choose autoincrement field as a foreign key in details table.
If you need help with setup post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. Let us know how we can reproduce this issue.
B
 		bluepoint author 7/1/2011



Looks like something is not right with setup. For instance, you cannot choose autoincrement field as a foreign key in details table.
If you need help with setup post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. Let us know how we can reproduce this issue.


What, you just reproduced it? That right as you say...so you see the issue. I have already posted this
J
 		Jane 7/1/2011

Hi,
this error happens because you've set up StatementNo (primary auto-increment field) as OwnerID on the Advanced security settings dialog on the Securitytab. OwnerID is filled automatically with value from users table.
You need to create another field to save OwnerID value in the Statement table.