list_dbbind

Sets the columns to use for list DB binds.

Available in:

Apps (win) Apps (char) Reportwriter RPC Standalone PL
X X X   X

Syntax

void list_dbbind(list-name,[bind-col[,bind-col,...]])
list             list-name
int              bind-col

Description

list-name specifies the list.

bind-col is the absolute zero-based column position of the data to be used in the DB bind.

Notes

If no bind-col values are given, then all columns are used for a DB bind.

Example

Loads a list with part codes and descriptions, then uses only some of the columns to update another table.
xx = list_open("SELECT code,description,price,quantity FROM parts",1000,"Parts");
list_dbbind(xx,0,2);
exec_sql("insert into parts_temp(code,price) values(:1,:2)",xx);