problem with sequence of the oracle
in sakthi's weblog
in that link
http://blogs.sun.com/sakthi/entry/a_scenario_with_oracle_sequence
i found that about the sequence of the oracle and how i can use it with creator
but sadly it didn't work correctly ..i make all the steps correct but when i trying to enter a name or any string it do a strange thing... the sequence work and increment every time but the char_col don't.. in another word you can see that photo
http://img73.imageshack.us/img73/3305/poblemjv9.jpg
as you see the char col don't response it just record the last input and replace it with the first record and as you see in the photo that there's a missing number it's because when i run the project first it give me the sequence correctly and when i re run it again it jumb a number it always do that
i'm using creator 2 update1 if that matter..
please could you check the code again and tell me may be i missed somthing i hope i don't bother :)
