982909 wrote:You are digging yourself a DEEP hole by using double quote marks & Mixed Case table & column names!
I have several tables with the sql bellow:
CREATE TABLE "Appointment"AVOID using Reserved Words like "DATE" as column or table names!
( "Appointment_ID" NUMBER,
"Employee_ID" NUMBER CONSTRAINT "NN_Dentist_Appointment" NOT NULL ENABLE,
"Patient_ID" NUMBER CONSTRAINT "NN_PATIENT_Appointment" NOT NULL ENABLE,
I'm trying to make an application in Oracle Application Express and I've tried making an SQL report using the following SQL query:Any table can have only ONE Primary Key.
CREATE OR REPLACE FORCE VIEW "Appointment_REPORT" ("DOCTOR", "PATIENT", "Content", "Date") AS
select concat(concat(v.name,' '),v.surname) as doctor, concat(concat(pa.name_patient,' '),pa.surname_patient) as pactent, p.content, p.date
from Appointment p, Amployee v, Patient pa
The SQL works fine and gives me lovely results in my report. However, I don't know how to link the SQL to my actual Appointment table. Deleting, updating or creating new appointments through this view is impossible because I get the following error Unexpected error, unable to find item name at application or page level.
I understand how to make a form on the Appointment table but given how that table contains lots of primary keys (numbers) it's not preferable for the user to have to deal with that.
Can I have some help with linking the two andto which "two" do you refer?
making it functional?Since you have told us what functionality is desired or expected,