How do you insert a record with a nullable column ?
To insert a NULL, move -1 to the null indicator, To insert a valid value, move 0 to the null indicator
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is the difference between search record and add search record 17.11.08
Search Record: Specify the search record for the component.The search record controls access to rows of data in a table, and its keys and alternate search keys...Write a program to remove duplicates from a sorted array. 10.11.08
int remove_duplicates(int * p, int size) { int current, insert = 1; for (current=1; current < size; current++) if (p[current] != p[insert-1]) { p[insert] = p[cu...Write a program to remove duplicates from a sorted array. 01.11.08
int remove_duplicates(int * p, int size) { int current, insert = 1; for (current=1; current < size; current++) if (p[current] != p[insert-1]) { p[insert]...What are the column name qualifiers ? 14.07.08
A column name qualifier are used as a table designator to avoid ambiguity when the column names referenced exists in more than one table used in the SQL stateme...What is the maximum allowed length of a Record Group ? 21.05.08
Record group column names cannot exceed 30 characters....What are record groups? 15.05.08
A record group is an internal Oracle Forms data structure that has a column/row framework similar to a database table. However, unlike database tables, record...What are column-name qualifiers used ? 09.04.08
Column-name qualifier are used as table designator to avoid ambiguity when the column names referenced exist in more than one table used in the SQL statement. C...How do you retrieve the data from a nullable column ? 17.03.08
Use null indicators. Syntax ... INTO :HOSTVAR:NULLIND...How do you display an editable drop-down list? 24.12.06
Displaying a drop-down list requires a template column in the grid. Typically, the ItemTemplate contains a control such as a data-bound Label control to show th...How you will set the datarelation between two columns? 14.03.06
ADO.NET provides DataRelation object to set relation between two columns.It helps to enforce the following constraints,a unique constraint, which guarantees t...