RE: [sqlite] Jumping to a record

You need to register a new function with-state to do this. Something like this: void f(sqlite_func *ctx, int arg, const char **argv) { int *state = (int *)sqlite_user_data(ctx); if (atoi(argv[0]) == atoi(argv[1])) *state = 1; sqlite_set_result_int(ctx, *state); } static in

RE: [sqlite] Jumping to a record

> Hi, > > I have a set of records selected, for example, with: > > "select * from NewsData where (upper(Zip)>='HX1' and > upper(Zip)<'HX2') order by Zip,Address,No" > > There is an INTEGER PRIMARY KEY field in the database called ID > > Given that I know I have a record with an ID of 12345, how wou

[sqlite] Jumping to a record

Hi, I have a set of records selected, for example, with: "select * from NewsData where (upper(Zip)>='HX1' and upper(Zip)<'HX2') order by Zip,Address,No" There is an INTEGER PRIMARY KEY field in the database called ID Given that I know I have a record with an ID of 12345, how would it be possib

[sqlite] New function for SQlite

Hi, I have just finished an SQL function for SQLite which will allow to call exported function form a Win32 DLL. This is an example of the calling syntax update UserPassword set Password = se_fn("mydll_01","Encrypt",'NewPassword'); or select se_fn("mydll_01","Encrypt",[Message]) from UserMess