The issue is now being looked into to see if the Python code is to blame, I'll report back on the progress.

This may be due to the way the question is checking for the expected output, also remember it is checking to make sure that the records cant be deleted, if there are any issues with line numbers, you can try remove any blank lines in your code. I'll l...

Hello, it seems that I cannot find the solution file for Worksheet5-Week10-questions (Posted on week 11) in "Worksheet solution" and "lecture notes slides" tab in the LMS. Even though I believe that the answer was discussed in one of the lectures, is...

This is because of the format of the SQLite query. I found that the error must near line 12, as the error has been specified in the excepted answer.

i added full stop, but still same error

i have encountered error Lab5 , question 3. Error is "Unexpected sqlite3 error Error near line 17 Cannot delete pos record with associated po items" my total line is 12 lines, also my local database was working with the same query. i dont know what ...

What was suggested above would be the best guide, aside for that, there aren't any formatting checks in the embedded Python code, so as long as you select the po id and an aggregate function AS total cost, that side of it should be fine. If it can be ...

i made 1 more line to make 12 lines. but i still got an error.

I still couldn't solve it. my code is a total 11 lines.. there is no 12 line

Hi, The format of this year's final exam is different from the exam format available on Onesearch. A sample exam paper and its solution are available on LMS under Lecture notes slides Week 12 CITS1402 - Practice Exam - Solution - 2024 - Sem 2....

Maybe I'm reading your screenshot wrong, but to me it looks like they've changed the question to need no full stop. If that still doesn't work, maybe try changing the amount of lines your query is so that the error is on line 12 like how it is expect...

You can find them on OneSearch )

Hi, You won't fail this unit, but according to the uni assessment policy, you will receive a late penalty for your Lab 4. For more details, please review this webpage https ipoint.uwa.edu.au app answers detail a id 2711 consequences-for-late-assi...

Unfortunately for some unforeseen reasons I was unable to turn in the SQL lab 4. Is there a possibility that I might be able to attempt that lab? Or does this mean I am failing this course?

Hi Could the teaching team please upload some past exam papers? Thanks

RAISE(ABORT, 'Cannot delete pos record with associated po items.'); i still got the error even i added full stop. i dont know what is wrong

Agree with you. Found that in the end it's requiring lines that do not do filtering, which may not require a subquery to finish indeed. Maybe the description is a bit confusing.

Adding a full stop worked thanks for that Cheers

You're missing a full stop at the end of your error message, not including it creates the unexpected sqlite3 error as the testing system is looking for the full stop. They seem to have not included the full stop in the actual question.

I was initially getting the question wrong because the actual output of my abort gave a different line number to the abort on the expected output. In my case, the expected line output was 12 while I was initially outputting an error code with line 11...