WinBinder Manual/db swap records

Swaps two records in a table.

Syntax

bool db_swap_records(string tablename, int id1, int id2 [, string idfield [, bool xchangeids]])

Arguments

• tablename is the name of the table that will be affected.
• id1 is the id number of the first record to be exchanged.
• id2 is the id number of the second record to be exchanged.
• idfield is the name of identifier field (column). Default is "id".
• xchangeids, if TRUE, exchanges the ids as well. Otherwise only the values are exchanged. The default is FALSE

Result

The function returns TRUE if successful or FALSE otherwise.

Example

// Exchange the first and third records in mytable

db_swap_records("mytable", 1, 3);

See also

• <winterpostwiki>Database functions</winterpostwiki>
• <winterpostwiki>Database support</winterpostwiki>