CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 Entering Table Attributes Problem.. generating problem...Keys problem

Print topic Send  topic

Author Message
Chris
Posted: 02/26/2004, 10:42 AM

In the application builder, once i have set the connection with the database and at thepoint to choose which tables to use.. i get the error with the primary keys.. tha there is no primary key.. but i have set one in the database..

The other thing is that i cannot see all the attributes of my table to find my primary key...

I have this error:
"Set the following parameters for 'comp_locations' table: Primary Key for the record"
"Set the following parameters for 'company' table: Primary Key for the record"

I want to make a database where a company table can have many locations.. so there is one to many relationship and i am using InnoDB Tables type to support foreign keys (I am using MySQL - PHP)

For example i have company_ID as key for the company Table and comp_loc_ID for the Company Locations Table... This key in the above situation it doesn't appear in the attributes to be selected to set the key.... for generating the page,code etc...
Also i have some more atttributes in each table and they also don't appear...From the 11 atributes that i have in the Company table when i need to select this key, i can not see them all..

Please help me.. i need to start building this page..

These are some of the errors that i receive.. after i press finish.. Of course.. actually i am not actually finished because in the tables.. some attributes are missing .. which some of them are the primary keys and they are not present in the web page.... and in the selection for attributes...

Warning:Component " (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "NewGrid1 (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "employees (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "employeesSearch (Record)" was not found in the HTML during the synchronization process.
Warning:Component " (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "NewGrid1 (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "employees (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "employeesSearch (Record)" was not found in the HTML during the synchronization process.
Generating "NewPage1"
Warning:Component "company (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "companySearch (Record)" was not found in the HTML during the synchronization process.
Generating "NewPage1"
Warning:Component "company (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "companySearch (Record)" was not found in the HTML during the synchronization process.
Generating "NewPage1"
Warning:Component "company (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "companySearch (Record)" was not found in the HTML during the synchronization process.
Generating "NewPage1"
Generating Common Files
Warning:Set the Project Date Format property to work correctly with the Date fields.
Publishing to "C:\Inetpub\wwwroot\NewProject7"
peterr


Posts: 5971
Posted: 02/26/2004, 1:26 PM

Chris,
Have you contacted our support yet?
If you need technical help, it may be best to ask the support for help rather than other users. Posting on the forums is OK if you want to wait to see if possibly someone will answer but if you expect to resolve a problem, please contact us directly, as described below.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message
Chris
Posted: 02/27/2004, 12:09 AM

I have contact you,

But i haven't received...a solution to this problem yet...
peterr


Posts: 5971
Posted: 02/27/2004, 12:26 AM

Could you please PM me with your case number. I'll check into it.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message
QBS
Posted: 05/17/2005, 2:03 AM

Did you ever get around the last error?

Warning: Set the Project Date Format property to work correctly with the Date Fields.
===================================

Quote Chris:
In the application builder, once i have set the connection with the database and at thepoint to choose which tables to use.. i get the error with the primary keys.. tha there is no primary key.. but i have set one in the database..

The other thing is that i cannot see all the attributes of my table to find my primary key...

I have this error:
"Set the following parameters for 'comp_locations' table: Primary Key for the record"
"Set the following parameters for 'company' table: Primary Key for the record"

I want to make a database where a company table can have many locations.. so there is one to many relationship and i am using InnoDB Tables type to support foreign keys (I am using MySQL - PHP)

For example i have company_ID as key for the company Table and comp_loc_ID for the Company Locations Table... This key in the above situation it doesn't appear in the attributes to be selected to set the key.... for generating the page,code etc...
Also i have some more atttributes in each table and they also don't appear...From the 11 atributes that i have in the Company table when i need to select this key, i can not see them all..

Please help me.. i need to start building this page..

These are some of the errors that i receive.. after i press finish.. Of course.. actually i am not actually finished because in the tables.. some attributes are missing .. which some of them are the primary keys and they are not present in the web page.... and in the selection for attributes...

Warning:Component " (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "NewGrid1 (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "employees (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "employeesSearch (Record)" was not found in the HTML during the synchronization process.
Warning:Component " (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "NewGrid1 (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "employees (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "employeesSearch (Record)" was not found in the HTML during the synchronization process.
Generating "NewPage1"
Warning:Component "company (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "companySearch (Record)" was not found in the HTML during the synchronization process.
Generating "NewPage1"
Warning:Component "company (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "companySearch (Record)" was not found in the HTML during the synchronization process.
Generating "NewPage1"
Warning:Component "company (Grid)" was not found in the HTML during the synchronization process.
Warning:Component "companySearch (Record)" was not found in the HTML during the synchronization process.
Generating "NewPage1"
Generating Common Files
Warning:Set the Project Date Format property to work correctly with the Date fields.
Publishing to "C:\Inetpub\wwwroot\NewProject7"


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.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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