Hi!
Can I get some samples to work on sqlite that is how to create a database
and inserting ... don' t think again I am joking plz help me.it was bit
confusing when iam using sqlite command prompt
Regards,
Satish
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On B
Satish wrote:
> Hi!
>
> Really I am Serious about this I am very new to database and I want
> to use sqllite.so I want to know.THE Reason why asked this question is I
> have seen a video of google tech bytes in that the presenter said that
> sqllite doesn't support foreign key and alter t
On 11/13/08, Satish <[EMAIL PROTECTED]> wrote:
> Hi!
>
> Really I am Serious about this I am very new to database and I want
> to use sqllite.so I want to know.THE Reason why asked this question is I
> have seen a video of google tech bytes in that the presenter said that
> sqllite doesn
Hi!
Really I am Serious about this I am very new to database and I want
to use sqllite.so I want to know.THE Reason why asked this question is I
have seen a video of google tech bytes in that the presenter said that
sqllite doesn't support foreign key and alter table.is this True.i want
On Thu, Nov 13, 2008 at 9:31 PM, Satish <[EMAIL PROTECTED]> wrote:
> Hi!
>
>Will sqllite support Foreign Key and ALTER Table Comands .I want to know
> is there any documentation that helps me to know what are the classes that I
> can use and program.I use vc++ to connect to database.tell me if
Hi!
Will sqllite support Foreign Key and ALTER Table Comands .I want to know
is there any documentation that helps me to know what are the classes that I
can use and program.I use vc++ to connect to database.tell me if there any
wrapper classes which I can use and also provide me documentation
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
RanRan wrote:
> In the child process, I closed the database and opened a new one for the
> child process to use. Won't it fix the problem? Thank you so much again.
No, because after the fork both the parent and the child have the
database open. There
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Avinash Mittal wrote:
> I think compiler is not getting tcl.h file
>
> Now what should be done to debug these errors
Make sure the TCL development files (headers and libraries) are
available. If you don't know how to do that then you need to contact
Hi ,
As suggested i did make test but it is showing errors like:
test1.c:(.text+0x390): undefined reference to `Tcl_CreateCommand'
test1.c:(.text+0x3b8): undefined reference to `Tcl_CreateObjCommand'
test1.c:(.text+0x3d4): undefined reference to `Tcl_LinkVar'
test1.c:(.text+0x3e8): undefined refer
Roger Binns wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> RanRan wrote:
>> I have a program that would create a child process.
>
> http://www.sqlite.org/faq.html
>
> Question 6, last paragraph.
>
> Roger
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.9 (GNU/Linux)
>
[EMAIL PROTECTED]
Regards,
G.Satish
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
RanRan wrote:
> I have a program that would create a child process.
http://www.sqlite.org/faq.html
Question 6, last paragraph.
Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEARECAAYFAkkc+lYACgkQmOOfHg372QQOWgCeLkoxrDl8Xt
Hi everyone!
I have a program that would create a child process. The run-through of the
part of the program is as follows:
[code]
int main()
{
pid_t pid;
int status = -1;
static sqlite3 *dbPtr;
status = sqlite3_open( "mine.db", dbPtr );
while(1)
{
if((pid =
"Ernany" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> Is it possible to simplify the code? I have ten fields to UPDATE.
> (STATUS, Responsavel, Country,..)
>
> UPDATE Bens SET *STATUS *=
> CASE (SELECT COUNT(BENSBK.STATUS) FROM BENSBK WHERE BENSBK.BEM =
> Bens.BEM)
> WHEN 0 T
Hi All,
We have a field of datatype nvarchar in SQL Server 2005, which stores the
data in unicode.
When I export the data into SQLite, it is storing as ascii, even if I change
the datatype as nvarchar
when the table is created. I am using SQL Maestro tool to export the data from
SQL Serve
Slater, Chad wrote:
>
> Sqlite does not support modifying the unique constraints on a table:
>
> http://www.sqlite.org/lang_altertable.html
>
> So you probably need to do it the 'ol fashioned way:
>
Perfect--Just what I figured I'd need to do!
Thanks!
--
View this message in context:
http
Sqlite does not support modifying the unique constraints on a table:
http://www.sqlite.org/lang_altertable.html
So you probably need to do it the 'ol fashioned way:
BEGIN;
CREATE TABLE Vehicles_new (
VehicleID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
FK_CustomerID INTEGER NOT NULL,
Veh
Thanks you all for your support.
Finally, I was able to make SQLMaestro work.
Thanks once again
Baskaran> Date: Thu, 13 Nov 2008 10:14:14 -0500> From: [EMAIL PROTECTED]> To:
sqlite-users@sqlite.org> Subject: Re: [sqlite] SQLite Import Tool> > Here is a
link to the application and source:>
Hello ,
Is it possible to simplify the code? I have ten fields to UPDATE. (STATUS,
Responsavel, Country,..)
Thanks,
Ernany
**
UPDATE Bens SET *STATUS *=
CASE (SELECT COUNT(B
hi, Doug,
Thanks for your reply, I have just fixed that bug, the issue caused by
not closing database correctly, so next time I opened the database, all
things rolling back. Thanks for your patience and passion.
best regards
On Thu, 2008-11-13 at 09:48 -0500, Doug Currie wrote:
> On Nov 12,
Hi!
SQL Maestro Group announces the release of SQLite Maestro 8.11, a complete
Windows GUI solution for SQLite database management. The new version is
immediately available at
http://www.sqlmaestro.com/products/sqlite/maestro/
What's new in this version
===
1. Support
Shawn Wilsher wrote:
>I seem to have found a crash that is 100% reproducible in SQLite 3.6.5. I'm
>managed to make a reduced test case in a C file that can be found here:
>http://files.shawnwilsher.com/2008/11/12/test.c
I could reproduce the problem and opened this ticket to make sure it does
Here is a link to the application and source:
http://www.proghack.net/?p=40
On Wed, Nov 12, 2008 at 3:20 PM, Baskaran Selvaraj <
[EMAIL PROTECTED]> wrote:
>
> Thanks roosevelt. I will try to use the c# command.
>
> > Date: Wed, 12 Nov 2008 15:03:41 -0500> From:
> [EMAIL PROTECTED]> To: sqlite-us
I'm having problems getting good index choice in SQLite 3.6.4 for a field
which is INTEGER PRIMARY KEY AUTOINCREMENT.
I've got the following table:
CREATE TABLE Signals (sSignalID Text DEFAULT '',sText Text DEFAULT
'',sTime Text DEFAULT '',sUserID Text DEFAULT '',nRowID INTEGER PRIMARY
KEY AUTOIN
I am resending my transactions based on the result code that is returned.
Should I put the time out command in my loops or once set does time out apply to
each transaction despite the resends? And does the timeout command apply only
to connecting to the data base or to each request?
_
On Nov 12, 2008, at 10:31 PM, henry wrote:
> my app, I opened a database handler, insert some records, delete some
> records, then closed the database handler. The problem is the next
> time
> when I connect the Sqlite, the actions I did last time has all gone
> away, it did not take any effect
Hello Nithin,
Thursday, November 13, 2008, 12:15:57 AM, you wrote:
NJ> Hi,
NJ> The problem is that the process is crashing without giving me a
NJ> chance to detect the error and recover from the situation. How can I
NJ> prevent that?
NJ> How can I programatically find out the the corrupted rows
Igor Tandetnik wrote:
> "Marcus Grimm" <[EMAIL PROTECTED]> wrote
> in message news:[EMAIL PROTECTED]
>> is there a way to query if the database file is currently locked ?
>
> How would it help? Between the time you would obtain this information,
> and the time you could act on it, the answer ma
John Stanton wrote:
> How about performing your backup inside an exlclusive transaction?
hm, good idea! ;)
Probably that will lock the file (i.e. the database) and protect
from a FileCopy, anyway: I'll try that.
Thanks for the reply
Marcus
>
> Marcus Grimm wrote:
>> Hello all,
>>
>> is ther
"Marcus Grimm" <[EMAIL PROTECTED]> wrote
in message news:[EMAIL PROTECTED]
> is there a way to query if the database file is currently locked ?
How would it help? Between the time you would obtain this information,
and the time you could act on it, the answer may very well change.
Just try whate
How about performing your backup inside an exlclusive transaction?
Marcus Grimm wrote:
> Hello all,
>
> is there a way to query if the database file is currently locked ?
>
> Background:
> My application may run for weeks (hopefully) and uses EXCLUSIVE
> transactions in some threads. On a daily
has any one expressed an interest to help out? it does not seem to be all that
difficult, notwithstanding your mention of time-out issues.
please let me know a bit ore detail about the db you are exporting, and we can
see if it is a project we can do quickly for you.
thanks-
Keith T
the SLK Grou
Hello all,
is there a way to query if the database file is currently locked ?
Background:
My application may run for weeks (hopefully) and uses EXCLUSIVE
transactions in some threads. On a daily basis I would like to copy
the database file for backup purpose. I assume that this will fail
when the
33 matches
Mail list logo