Hi Friends,
While running Data base with sqlite, i am getting error as Data
base locked.
How to resolve from this error.
Regards,
Bhaskar.
--
View this message in context:
http://old.nabble.com/Data-base-locked.-tp33355225p33355225.html
Sent from the SQLite mailing list archive at
Hi Friends,
While i am trying to use `sqlite3_db_release_memory'. I am
getting error and warning as,
createTable.c: In function ‘db_create_table’:
createTable.c:98: warning: implicit declaration of function
‘sqlite3_db_release_memory’
/tmp/ccSyJXew.o: In function `db_create_table':
Hi Friends,
I want to select a row based on some column values. If the row is
matched, the particular values corresponding row can be displayed.
If not matched and empty message getting displaying.
Now my problem is, i want to check whether there is a row with
HI Friends,
How to check whether a table is empty or not. If a table is empty, i
want to do some logic. If not another logic.
Can any one tell me how to check if table in a data base is empty
or not, using sqlite3.
Regards,
Bhaskar.
--
View this message in context:
INTEGER.
Regards,
Bhaskar.
Kees Nuyt wrote:
>
> On Thu, 9 Feb 2012 05:07:05 -0800 (PST), bhaskarReddy <uni...@gmail.com>
> wrote:
>
>>
>>Is it possible to find the data type, even if the table doesn't have data.
>>That means, my requirement is,
>>
and their names are there but no data in that
table.)
Regards,
Bhaskar.
Marcus Grimm wrote:
>
>
> On 09.02.2012 13:12, bhaskarReddy wrote:
>>
>> Thank you. Its working.
>>
>> But why i am getting sqlite3_column_type returning 5.
>>
>
> I can only guess:
&
;
>
> On 09.02.2012 11:21, bhaskarReddy wrote:
>>
>> HI Friends,
>>
>>I dont know why the sqlite3_step getting core dumped.
>>
>> #include
>> #include
>> #include "sqlitedb1.h"
>> #include
>> #include
>
>
> Thanks & Regards
> Taleeb bin Waquar
>
> *Hum Mashriq Ke "Miskeenon" Ka Dil Maghrib men Ja Atka Hai!!*
>
>
>
>
> On Thu, Feb 9, 2012 at 3:51 PM, bhaskarReddy <uni...@gmail.com> wrote:
>
>>
>> HI Friends,
>>
HI Friends,
I dont know why the sqlite3_step getting core dumped.
#include
#include
#include "sqlitedb1.h"
#include
#include
#include
#include
#include
int db_retrieve_row(char *db_name, char *table_name, int num_of_keys, char
* col_names[],column_value_t *
HI Friends,
How can i drop a table using sqlite API.
Regards,
Bhaskar.
--
View this message in context:
http://old.nabble.com/How-to-drop-a-table-using-sqlite-API-tp33249550p33249550.html
Sent from the SQLite mailing list archive at Nabble.com.
Hi Friends,
I have to find a type of a value in sql.
Suppose if i pass to a function with column names and values.
I want to find the 'type' for that values first, suppose if it is an INTEGER
i will do some steps, if it is TEXT some other steps.
How to
Hi Friends,
I have to find a type of a value in sql.
Suppose if i pass to a function with column names and values.
I want to find the 'type' for that values first, suppose if it is an INTEGER
i will do some steps, if it is TEXT some other steps.
How to
Hi Friends,
Is there any File checking mechanism in sqilte3.
Suppose i have a file ABCD.db, before i want to create the data
base file, i want to check whether it is already exit with the same or not.
If it is exist returns an error.
Is there any sqlite function to
Hi Friends,
is it possible to delete a database with DROP command.
ex: DROP DATABASE dbName;
Regards,
Baskar Reddy.
--
View this message in context:
http://old.nabble.com/Delete-data-base.-tp33241353p33241353.html
Sent from the SQLite mailing list archive at
Hi Friends,
Is there any way to find the number of columns and column
types in a table.
I tried with "select count(*) from tablename". But it is
showing number of records.
Regards,
Bhaskar.
--
View this message in context:
Hi Friends,
Can any one tell me how to access values of a table column
with its particular row id.
I tried with "select * from ontTable where rowid=2;"
I am getting the output as 1|2|3|XYZ234|4|ABCD123|5.
Here i want the
Its working with only table name.
Regards,
Bhaskar.
Igor Tandetnik wrote:
>
> bhaskarReddy <uni...@gmail.com> wrote:
>> I am getting an error as,
>>
>> sqlite> select count (*) from LR6000.ONTtable;
>> Error: no such table: LR6000.ONTtable
>
I am getting an error as,
sqlite> select count (*) from LR6000.ONTtable;
Error: no such table: LR6000.ONTtable
Regards,
Bhaskar.
Simon Slavin-3 wrote:
>
>
> On 30 Jan 2012, at 12:45pm, bhaskarReddy wrote:
>
>> Is there any API that will return number of rows
Tank you very much simon.
Regards,
Bhaskar Reddy.
Simon Slavin-3 wrote:
>
>
> On 30 Jan 2012, at 11:42am, bhaskarReddy wrote:
>
>> Can any one tell me how to delete entire database with its name,
>> using sqlite3 API.
>
> You can't. But unless yo
Hi Friends,
Is there any API that will return number of rows (records)
present in a particular table. I want to access the table using its database
name and corresponding table.
If possible give one example.
Regards,
Bhaskar Reddy.
--
View this message in context:
Hi Friends,
Can any one tell me how to delete entire database with its name,
using sqlite3 API.
Regards,
Bhaskar Reddy.
--
View this message in context:
http://old.nabble.com/Delete-data-base.-tp33228500p33228500.html
Sent from the SQLite mailing list archive at Nabble.com.
the actual database name and field names and values should come.
Can any one tell me how to do this.
Regards,
BhaskarReddy.
}
--
View this message in context:
http://old.nabble.com/how-to-vice-variable-names-in-CREATE-query.-tp33200658p33
PI int size();
>
> SWDBI_API vector getRow();
>
> };
>
> class SwRowset
>
> {
>
> vector m_Rowset;
>
> public:
>
> void addRow(SwRow val);
>
> SWDBI_API SwRow getRow(int index);
>
> SWDBI_API int size();
>
> };
>
Hi Friends,
How to store the values of a columns in to the appropriate
variables.
struct ABC
{
int a;
int b;
char *str;
};
a bname
1 2 ABCD
2 4 WXYZ
HI Friends,
Is there any SQLite API for returning a record based on particular
Primary key id.
Regards,
Bhaskar Reddy.
--
View this message in context:
http://old.nabble.com/Is-there-any-API-that-will-return-a-record-based-on-Primary-key.-tp33166831p33166831.html
Sent from the
Hi Friends,
is it possible to collect return value of a SQL command. ex:
SELECT COUNT(*) FROM table; will return number of records in a table. Is
there any SQLite API to return this value.
Regards,
Bhaskar Reddy.
--
View this message in context:
Hi Binns,
If i execute the command "SELECT COUNT (*) FROM table;" how
i will get the return value i.e., number of records in the table ?
Regards,
BhaskarReddy
Roger Binns wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 18/01/12
Hi Friends,
Is there an SQLite API for counting number of records in a
table.
Ex: StudentNameRollNo sub1sub2sub3
total avg
abcd 188
99 88
or:%s\n",sqlite3_errmsg(db));
> exit(1);
> }
> return 0;
> }
>
>
>
> Michael D. Black
>
> Senior Scientist
>
> Advanced Analytics Directorate
>
> Advanced GEOINT Solutions Operating Unit
>
> Northrop Grumman Information Systems
>
Hi Friends,
When i tried,
query = "insert into ONTTable
(slotId,ponChannelId,onuType,onuId,adminStatus) values (?1,?2,?3,?4,?5);";
then binding each parameter.
//sqlite3_prepare_v2(db,query,strlen(query)+1, , NULL);
sqlite3_bind_int(stmt,1,ontTable -> slotId);
r.
>
>
>
> Michael D. Black
>
> Senior Scientist
>
> Advanced Analytics Directorate
>
> Advanced GEOINT Solutions Operating Unit
>
> Northrop Grumman Information Systems
>
>
> From: sqlite-users-boun...@sqlite.
Hi friends,
While i am writing data into the table the values are not storing
in a single records, instead the values are storing in improper order.
I am adding the values to the table as,
query = "insert into ONTTable (slotId) values (?1);";
Hi friends,
I check all the C APIs which are provided by sqlite. I can able
to write data to a table, using sqlite3_exec() function.
But i need a C API that will write data into table, i.e., sqlite3_exec().
Ex: if i give "database name", table name and values to that
Hi Friends,
I am using SQLite. This is the first time. And i am creating,
accessing and retrieving data from the table.
I am using sqlite3_exec() function to insert and retrieve data.
Instead using sqlite3_exec(), is there any other APIs which help inserting
data into
34 matches
Mail list logo
