Have a market data extractor running tick tapes and saving data to sqlite db.
All coded in C++ and previously ran fine and fast on bare metal.
Processes tick tapes from NAS and saved to local sqlite db's on c drive.
We moved program onto VMWare VM's... same nas tick tapes. Writing
db's to a
On 6/4/2012 3:48 PM, Patrick wrote:
Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API?
No. But in your C program, you can always write code that reads results
from SQLite, then writes them to a file in the format of your choice.
I see the sqlite3 binary has an
On 4 Jun 2012, at 8:48pm, Patrick wrote:
> Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API?
> I see the sqlite3 binary has an interactive .output parameter. Anything
> similar in the C API?
Nope. Sorry. You have to write your own C code
Is their a syntax similar to mysql's 'SELECT INTO OUTFILE' in the C API?
I see the sqlite3 binary has an interactive .output parameter. Anything
similar in the C API?
TIA
Pat...
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Mon, Jun 04, 2012 at 09:13:51PM +0200, Gert Van Assche scratched on the wall:
> SELECT DISTINCT
> group_concat( [TB].[F2],' ') AS [Groep]
> FROM [TA] JOIN [TB] ON [TA].[Groep] = [TB].[Groep];
>
> I get this as a result:
> Groep
> 1 2 *3 3*
>
> but I would like to get
> Groep
> 1 2 *3*
>
>
> SELECT DISTINCT
> group_concat( [TB].[F2],' ') AS [Groep]
> FROM [TA] JOIN [TB] ON [TA].[Groep] = [TB].[Groep];
You probably want to do the following here:
SELECT group_concat([F2],' ') AS [Groep]
FROM (
SELECT DISTINCT [TB].[F2] AS [F2]
FROM [TA] JOIN [TB] ON [TA].[Groep] = [TB].[Groep]
);
All,
I'm sure this is not an SQLite bug, but I hope I can get rid of it:
CREATE TABLE "TA"([Groep], F1);
CREATE TABLE "TB"([Groep], F2);
INSERT INTO [TA]([Groep], [F1]) VALUES('1', 'ABC');
INSERT INTO [TA]([Groep], [F1]) VALUES('2', 'DE');
INSERT INTO [TA]([Groep], [F1]) VALUES('3', 'F');
On 4 Jun 2012, at 6:39pm, Jörgen Hägglund wrote:
> What I am trying to accomplish is an update from the source data. If the
> entry is already there, just ignore it. Otherwise add the new data.
If any unique key (including the primary key) of the existing row and
Am 04.06.12 19:36, schrieb Igor Tandetnik:
>
> http://sqlite.org/lang.html
> http://sqlite.org/syntaxdiagrams.html
>
I just found the case expression. I did not know it before. Thank you
for pointing me to that direction!
Wolfgang
___
sqlite-users
Hi!
Thank You for replying Stefanos!
Unfortunately, the errors were typos on my part. Sorry about that.
As I wrote, everything works fine the first time around.
What I am trying to accomplish is an update from the source data. If the
entry is already there, just ignore it. Otherwise add the new
Am 04.06.12 19:31, schrieb Michael Schlenker:
> Am 04.06.2012 19:25, schrieb Wolfgang Meiners:
>> Am 04.06.12 18:59, schrieb Igor Tandetnik:
>>> On 6/4/2012 12:33 PM, Wolfgang Meiners wrote:
this trigger does work but i think it is not in accordance with the
syntax diagram of TRIGGER on
On 6/4/2012 1:25 PM, Wolfgang Meiners wrote:
Am 04.06.12 18:59, schrieb Igor Tandetnik:
On 6/4/2012 12:33 PM, Wolfgang Meiners wrote:
this trigger does work but i think it is not in accordance with the
syntax diagram of TRIGGER on
http://sqlite.com/lang_createtrigger.html
Which part do you
Am 04.06.2012 19:25, schrieb Wolfgang Meiners:
> Am 04.06.12 18:59, schrieb Igor Tandetnik:
>> On 6/4/2012 12:33 PM, Wolfgang Meiners wrote:
>>> this trigger does work but i think it is not in accordance with the
>>> syntax diagram of TRIGGER on
>>> http://sqlite.com/lang_createtrigger.html
>>
>>
Am 04.06.12 18:59, schrieb Igor Tandetnik:
> On 6/4/2012 12:33 PM, Wolfgang Meiners wrote:
>> this trigger does work but i think it is not in accordance with the
>> syntax diagram of TRIGGER on
>> http://sqlite.com/lang_createtrigger.html
>
> Which part do you feel is in violation of the diagram?
On 6/4/2012 12:33 PM, Wolfgang Meiners wrote:
this trigger does work but i think it is not in accordance with the
syntax diagram of TRIGGER on
http://sqlite.com/lang_createtrigger.html
Which part do you feel is in violation of the diagram?
--
Igor Tandetnik
Hi Simon… project was cancelled… if it get's resurrected, and I still have the
problem, I'll get back to you. Thank you for your time…
Regards,
Rolf
On Jun 4, 2012, at 7:29 AM, Simon Slavin wrote:
>
> On 4 Jun 2012, at 3:24pm, Rolf Marsh wrote:
>
>> "Could you possibly
Hi,
I have written the following trigger with ideas from stackoverflow:
(OSX 10.6.8, SQLite 3.6.12)
This is for a book library. If i delete a bookexemplar from the library,
this should not be possible if this bookexemplar is on loan, which means
ausleihen.rueckgabe IS NULL. Otherwise every
On Mon, Jun 4, 2012 at 10:50 AM, Marco Bambini wrote:
> I am sorry Dr. Hipp, I am probably doing something wrong, but I just
> retried and no sessions code is in-line in the final sqlite3.c file.
>
> I downloaded:
>
>
I am sorry Dr. Hipp, I am probably doing something wrong, but I just retried
and no sessions code is in-line in the final sqlite3.c file.
I downloaded:
http://www.sqlite.org/src/zip/SQLite-d07b7b67d1b3bf65.zip?uuid=d07b7b67d1b3bf65cfe8d96d45a7f1d387bea7ce
then
cd SQLite-d07b7b67d1b3bf65
On Mon, Jun 4, 2012 at 10:34 AM, Marco Bambini wrote:
> I just tried to download:
> http://www.sqlite.org/src/info/d07b7b67d1
> from the session branch.
>
> Then:
> ./configure; make sqlite3.c
> but no session module is included in the amalgamation sqlite3.c file.
>
All of the
I just tried to download:
http://www.sqlite.org/src/info/d07b7b67d1
from the session branch.
Then:
./configure; make sqlite3.c
but no session module is included in the amalgamation sqlite3.c file.
>From the executed cp command:
cp -f ./src/alter.c ./src/analyze.c ./src/attach.c ./src/auth.c
On 4 Jun 2012, at 3:24pm, Rolf Marsh wrote:
> "Could you possibly reduce your database to just a few records -- just enough
> that it correctly reproduces your problem ? You can use the SQLite shell
> tool to .dump the database which will let you post a complete copy for
Simon… did you get my response to your last question?
"Could you possibly reduce your database to just a few records -- just enough
that it correctly reproduces your problem ? You can use the SQLite shell tool
to .dump the database which will let you post a complete copy for our testing. "
On 4 Jun 2012, at 6:14am, YAN HONG YE wrote:
> I have a sqlite db file in my pc, and now I wanna to copy my db file to my
> ipad.
The format of SQLite databases is identical on every platform. You can make a
database on one platform and read it on another.
> I need
24 matches
Mail list logo