thecharlie
New member
- Local time
- Today, 03:49
- Joined
- Aug 4, 2006
- Messages
- 1
Hey guys,
great forum! I have one question:
I've been trying to run this query but everytime I do, I get this error:
[Oracle][ODBC]Function Sequence Error(#0)
This is my query:
update summit_child, child_id
set summit_child.id = child_id.id, summit_child.child_first_name = child_id.child,
summit_child.child_last_name = child_id.last_child,
summit_child.child_birth_datedb = child_id.dob_child,
summit_child.sex_cd = child_id.gender_child, summit_child.child_seq_num
= switch(summit_child.child_seq_num = "1", "2",
summit_child.child_seq_num = "2", "3", summit_child.child_seq_num
= "3", "4", summit_child.child_seq_num is null or
summit_child.child_seq_num like " ", "1")
where summit_child.id = child_id.id
and child_id.child = summit_child.child_first_name
and child_id.last_child = summit_child.child_last_name;
any help would be very much appreciated
great forum! I have one question:
I've been trying to run this query but everytime I do, I get this error:
[Oracle][ODBC]Function Sequence Error(#0)
This is my query:
update summit_child, child_id
set summit_child.id = child_id.id, summit_child.child_first_name = child_id.child,
summit_child.child_last_name = child_id.last_child,
summit_child.child_birth_datedb = child_id.dob_child,
summit_child.sex_cd = child_id.gender_child, summit_child.child_seq_num
= switch(summit_child.child_seq_num = "1", "2",
summit_child.child_seq_num = "2", "3", summit_child.child_seq_num
= "3", "4", summit_child.child_seq_num is null or
summit_child.child_seq_num like " ", "1")
where summit_child.id = child_id.id
and child_id.child = summit_child.child_first_name
and child_id.last_child = summit_child.child_last_name;
any help would be very much appreciated