dodgebros
Posts: 11
|
| Posted: 06/04/2012, 8:20 AM |
|
Hi, I built a postgres database using phppgadmin.
These are the database table:
class_master
recid
name
date_time
recid
class_date
class_time
instructor_id
location _id
class_id
location
recid
name
instructor
recid
name
These are the table relationships:
class_master.recid -> date_time.class_id
instructor.recid -> date_time.instructor_id
location.recid -> date_time.location_id
I used the Codecharge Application Builder to build the app. I did set the relationships when I created the Data Dictionary. When I run the app and try to add the first instructor I get this error messgae on that page..."Database error: ERROR: relation "instructor" does not exist LINE 1: INSERT INTO instructor (name) VALUES('John Smith') ^ "
Can someone tell me what this error message is saying and where to look to fix it??
THANKS !
dodgebros
|
 |
|
Lucius
Posts: 220
|
| Posted: 06/04/2012, 11:49 AM |
|
If your table names do contain UpperCase letters, (also applies to fields) you need to use double-quotes: "instructor" for example. Postgres is specific this way and CCS does not do any error handling for you here.
If this is not the issue, please add some
print_r($Component->DataSource->SQL);
to before execute insert event, it will output you the exact SQL CCS is trying to run against your DB. Then try to use (debug it) in your phppgadmin.
|
|
|
|
|
 |
|
|
|
