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);