This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Anybody help !!!!! Here's the deal: I am trying to do a simple insert into an Oracle database using Oracle9 provider via LightSpeed entities. Here's the code: using ( TestUnitOfWork iow = Repository.Context.CreateUnitOfWork() ){ Test test = new Test(); test.Description = "Test entry !!";iow.Add(test); iow.SaveChanges(); } Table "Test" has only one column - "Description". When program reaches the line "iow.Add(test)" it generates the all familiar error: "ORA-00942: table or view does not exist". I have tried lots of things but I can't find an explanation for this... I can do updates and deletes normally, but not inserts.... Any help is greatly appreciated 'cause I am starting to flip here !!! |
|
|
You are using the KeyTable or Sequence identity method (probably the former, as this is the default if you don't specify one explicitly), but the KeyTable table (or LightSpeed sequence) does not exist. Run the KeyTable script from the Providers / Oracle9 directory to create this table. See Identity Generation in the help for more info. (Sounds like we need to check our error messaging here -- I thought it would tell you which table it was having problems with but I guess it wasn't in this case.) |
|
|
Hi Ivan, Thank you for your help...my problem was that I did not run the LightSpeed sequence script and I was using the sequence Identity Method......but the description of the error is totally off here...not at all indicative of the real problem.....oh, well, at least it works now.....thank you again !!!
|
|