Re: [sqlite] Jumping to a record

"Brian Pugh" <[EMAIL PROTECTED]> writes: > 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 r

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