Triggers in SQLite Administrator Window

Question

How to create Triggers in SQLite through SQLite Administrator Window.

Answer 1

If this query got resolved then please Accept the post that helped you as Answer.
So other members can easily find the answers.

Answer 2

Sam is right.

change your code too

1. if (chineseGrade=="A")

2. use double chineseGPA or chineseGPA = Convert.ToDecimal(4.0);

Answer 3

chineseGrade is a string variable but you are using it as if it is a method. The compiler is not psychic and neither are we. What is it that you need to do? As best as I understand your question, you are calculating a GPA for Chinese differently than for other people but as far as I know the Chinese are the same as everyone else. So perhaps the answer is that you can just use the same calculation for Chinese people as everyone else.