Thanks all,
Ok so I've been through the tutorial again, but it doesn't really at anything about .required := false or around the other SQL statements in the Object Inspector.
I've also tried setting up .Required ;= false to all fields as suggested but I still get a MS Access error saying I'm trying to assign a null value.
What I don't understand fully is that if I just use a simple SQL statement such as
SELECT ID, Field2, Field3, Field4 From Table1
And do an insert from a set of assigned edit controls it works even if none of the field are filled in; it even sorts out the autoincrement field.
However as soon as I include an inner join to another table it fails with either the dataset is read only (without InterSQL setup) or assigning a Null value (if I set up an InsertSQL)
I'm really going around in circles here.
So I have
SQL:
SELECT Stakeholder.ID, Stakeholders.T_Stakeholder_Type, Stakeholders.SH_Name, Stakeholders.SH_Phone, Stakeholder_Types.SH_Type
FROM Stakeholders INNER JOIN Stakeholder_Types ON Stakeholders_Type.ID = Stakeholders.T_Stakeholder_Type;
InsertSQL:
INSERT INTO Stakeholder (ID, T_Stakeholder_Type, Stakeholder.SH_Name, Stakeholders.SH_Phone, Stakeholder_Types.SH_Type)
VALUES (:ID, :T_Stakeholder_Type, :Stakeholder.SH_Name, :Stakeholders.SH_Phone, :Stakeholder_Types.SH_Type);
I've set all the fields to .Required := False
All fields are attached to data aware controls.
And I get the MS access error trying to assign Null to non variant.....
Again any further help would be much appreciate.
Thanks