Re: [sqlite] Simple problem ?

> In each row, do you want balance before that row's credit/debit has > taken place, or after? <= does the latter, < would do the former. yes, I understand. > My statement never uses any previous value of ACCOUNT field, null or > otherwise. yes of course, how stupid of me ! thanks a lot

Re: [sqlite] Simple problem ?

, H264) developer > in > the Washington D.C. Contact [EMAIL PROTECTED] > > On Thu, Jul 3, 2008 at 12:03 PM, c.panel <[EMAIL PROTECTED]> wrote: > >> >> Hello, >> I'm learning SQL and have some difficulties to resolve some simple >> problems >>

Re: [sqlite] Simple problem ?

Good ! I've not seen like this ! but why "where t2.DATE <= mytable.DATE" instead of where "t2.DATE < mytable.DATE" because what about if ACCOUNT soon exists with no null value and you want to update? Igor Tandetnik wrote: > > c.panel <[EMAIL PROTECTED]> wr

[sqlite] Simple problem ?

Hello, I'm learning SQL and have some difficulties to resolve some simple problems with SQL. one example: Suppose I have a table with column DATE, CREDIT, DEBIT I want to create a new column that is the balance of account (ACCOUNT). My first approach is to index the table on dates, then starting

[sqlite] Re ading an SQL file with C API

Hello, Is it possible to run an sql-statement file from C API that can replace a ".read myfile.sql" command-line ? (preparing a statement require a 'char' pointer : giving the file in a large string is ok ?) thanks ! -- View this message in context:

[sqlite] getting ROWID

Hello, I execute a statement and want to have rowid(s) of each row like a : "select rowid,* from mytable;" how can I do this with C API ? thanks ! -- View this message in context: http://www.nabble.com/getting-ROWID-tp18183418p18183418.html Sent from the SQLite mailing list archive at

Re: [sqlite] SQL questions

Oh yes! "set" is the solution. I know that I have missed something... thanks a lot. no possibilities for indexing on an expression : is it a particularity of SQL or SQLite ? Igor Tandetnik wrote: > > c.panel <[EMAIL PROTECTED]> wrote: >> I'm learning SQL and SQL

[sqlite] SQL questions

I'm learning SQL and SQLite C API. 1)Suppose I have a table with many columns indexed on a column. I want to change one value in a column only. How can I make it with SQL ? 2)Is it possible to index a table on an expression (composed from column names) ? thanks for answers -- View this

Re: [sqlite] SQL understanding problem

OK! so rowid should be ok ! thank you! -- View this message in context: http://www.nabble.com/SQL-understanding-problem-tp18142381p18144242.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list

[sqlite] SQL understanding problem

I'm new to SQL(ite). I have two records in a table that have the same values in all columns. I want to replace a column of only one record. (ex: Firstname Lastname: Pierre Dupont, Pierre Dupont =>become => Pierre Dupont, Paul Dupont). How can I make it with SQL command ? How can I make it with C

Re: [sqlite] Accessing to database informations

thanks ! that was exactly what I was searching ! Dennis Cote wrote: > > > You can get the names of tables and indexes by querying the > sqlite_master table. > >select * from sqlite_master where type = 'table'; > > You can get detailed information about the columns in a table using the

Re: [sqlite] Accessing to database informations

dan.winslow wrote: > > Column names and types can be found with the following calls : > > sqlite3_column_name(ppStmt,x); > sqlite3_column_decltype(ppStmt,x); > sqlite3_column_type(ppStmt,x); > > Where ppStmt is the structure you get back from the prepare/step > functions.

[sqlite] Accessing to database informations

Hello, I'm a new user of SQLite, (and SQL too). I'm trying to find how can I access to tables names, column names and types, from a database, using C API. I found this from a result set but what about resident tables ?. Perhaps must I use a SELECT statement for this ? But If I do, does SQLLite