本文由 - 在 2014-04-15 發表於 "WebSAMS 討論區" 討論區
can provide sql code to extract such data? (the date of leave for each staff)
You may refer to http://forum.hkedcity.net/viewthread.php?tid=118127
i got this error when i copy the sql from the thread given.
Is anything that I need to pay attention to?
E-16053 : SQL Statement is empty or invalid.
I tried to copy and paste the SQL from the thread and I got a lot invalid characters. I think that's the cause of the error. So, I saved the SQL in a Word doc. Pls try again.
thanks for help
at the beginning I also deleted the invalid characters but i got the error msg.
but now i still got the same error when I used the code from the word file.
I tried the SQL again and i was able to extract the data. Pls contact your school liaison officer. I need more info for investigation.