Subject | InsertSQL |
---|---|
Author | Alfred Thomas |
Post date | 2004-05-03T12:32:45Z |
Hi
I am using TIB_Query and would like to define the following InsertQuery:
insert into \"Note\"(\"NoteID\", \"Description\", \"NoteDate\")
values(:\"NoteID\", :\"Description\", CURRENT_TIMESTAMP)
where NoteID is a parameter I would like to assign when executing the
Insert.
I am not sure where or how to assign a value to this parameter.
Regards
Alfred Thomas
I am using TIB_Query and would like to define the following InsertQuery:
insert into \"Note\"(\"NoteID\", \"Description\", \"NoteDate\")
values(:\"NoteID\", :\"Description\", CURRENT_TIMESTAMP)
where NoteID is a parameter I would like to assign when executing the
Insert.
I am not sure where or how to assign a value to this parameter.
Regards
Alfred Thomas