You are not logged in.
- Topics: Active | Unanswered
#1 2013-05-21 09:56:08
- corchi72
- Member
- Registered: 2010-12-10
- Posts: 232
Why I have error 405 from TSQLRecordMany.ManyAdd with old database?
Sorry if I insist but I have a problem with the generation of new tables by the framework in the sense that if I create a new database do not occur errors that occur instead if I upgrade an existing database.
The error is 405 and occurs when I run a simple code: AReport.Objects.ManyAdd(currentClient, AReport.id,Objects.id,True);
type
TSQLObject = class(TSQLFile)
private
...
end;
TSQLBaseReport = class(TSQLFile) //new table
private
...
end;
TSQLBaseReportObjects = class(TSQLRecordMany) //new table
private
fSource: TSQLBaseReport;
fDest: TSQLObject;
published
property Source: TSQLBaseReport read fSource;
property Dest: TSQLObject read fDest;
end;
TSQLReportObjects = class(TSQLBaseReportObjects); //new table
TSQLReport = class(TSQLBaseReport )
private
fObjects: TSQLBaseReportObjects;
public
...
published
property Objects: TSQLReportObjects read fObjects;
end;
//in the model I declare only the classes [TSQLReportObjects ,TSQLReport ,TSQLObject] and not [TSQLBaseReportObjects, TSQLBaseReport]
procedure Test_ManyAdd_Object_to_Report;
var
AReport :TSQLReport;
AObject: TSQLObject;
begin
AReport := TSQLReport.Create;
AReport.Created := Iso8601Now;
AReport.Modified := AReport.Created;
currentClient.Add(AReport, true);
AObject:= TSQLObject.Create;
AObject.Created := Iso8601Now;
AObject.Modified := AReport.Created;
currentClient.Add(AObject, true);
AReport.Objects.ManyAdd(currentClient, AReport.id,AObject.id,True); //Here the error occurs 405 with an old database created from the framework of months ago
end;thanks corchi
Offline
#2 2013-05-21 12:29:56
Re: Why I have error 405 from TSQLRecordMany.ManyAdd with old database?
Created/Modified fields could be handled directly by the ORM using TCreateTime and TModTime kind of fields.
No need to set them with Iso8601Now by hand.
If you get an error 405, it means HTML_NOTALLOWED, that is you do not have write access to the corresponding tables.
You need to explicitly add the group access rights, when you add new tables to the model.
I suspect this is your problem.
Offline
#3 2013-05-21 12:43:30
- corchi72
- Member
- Registered: 2010-12-10
- Posts: 232
Re: Why I have error 405 from TSQLRecordMany.ManyAdd with old database?
I had understood that the tables were created from framerk if you do not exist, and so is done, I did not understand the rights of accesso.
Io run a server console and I connect with the client (user-synopse.) on the server side I don't declare ever the rights access.
I saw with the program SQLite2009 that the structure of the database, and the only thing I notice is that I do not get created the row in the sqlite_sequence for "FastReportObjects"
Offline
#4 2013-05-21 12:52:48
Re: Why I have error 405 from TSQLRecordMany.ManyAdd with old database?
What is the TSQLAuthGroup content?
I suspect you did change the table order in the model, when adding new table.
This may have broken the table order in TSQLAuthGroup.AccessRights column.
For instance: AccessRights='0,1-9,12-256,0,0,0,0' will only give READ access to table 1-9,12-256.
If you add a TSQLRecord in the model in the 10 or 11 index, you won't have access to the table.
In short: new tables should be added at the end of the model!
Do not change the internal order of tables within a model.
It would break not only user rights, but also RecordReference fields.
This is AFAIR stated in the documentation.
Offline
#5 2013-05-21 14:11:38
- corchi72
- Member
- Registered: 2010-12-10
- Posts: 232
Re: Why I have error 405 from TSQLRecordMany.ManyAdd with old database?
You're right, I added the new tables in the list of tables in the model and not the tail should be done as.
Now I understand! Now I better read the documentation.
thanks corchi
Offline