On 23 Apr 2015, at 9:29pm, Jeff M wrote:
> Has there been any discussion about integrating sqlite with Apple's iCloud,
> either by using Apple's Core Data as the Virtual Machine's database engine
> (so the VM would operate on Core Data objects) or by otherwise modifying the
> existing
> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> Sent: Thursday, April 23, 2015 3:47 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] building SQLite DLL
Good day,
I don't work in VB, so I can't help you in specifics on that. A quick
search on a search engine pops up some videos on how to use sqlite in
a Visual Basic project. The archives of this list have a lot of
questions where people are introduced to open, prep sql, (bind), step,
fetch,
Thanks Igor
the only response I got to the first message was "it has been bounced"
On Wed, Apr 22, 2015 at 9:51 AM, Igor Tandetnik wrote:
> On 4/21/2015 11:01 AM, Jay Smith wrote:
>
>> Before I sent the last message I had signed up to become a user.
>> My previous message was bounced. WHY
>>
Thank you Adam for responding to my post. I have the windows binaries
downloaded.
At this point I am just following the instructions in the book. And I
really am not sure what I need the dll for.
Here's the scenario. I have created a program in vb2012. The program stores
less than 20 fields of
Has there been any discussion about integrating sqlite with Apple's iCloud,
either by using Apple's Core Data as the Virtual Machine's database engine (so
the VM would operate on Core Data objects) or by otherwise modifying the
existing backend?
My motivation is to allow existing apps that
On 23 Apr 2015, at 7:56am, Manoj Kumar Pasumarthi
wrote:
`
> qAdmin: Cannot perform this operation on a closed dataset.
This is not a SQLite error message. It is generated by Delphi or by something
that uses Delphi.
If you try to open the database in the SQLite shell tool instead of that
On Wed, 22 Apr 2015 20:07:45 +0100
Simon Slavin wrote:
>
> On 22 Apr 2015, at 7:18pm, Scott Hess wrote:
>
> > The only way SQLite can get to the disk is using the vfs, so if the
> > vfs encrypts things, all of the files (main db, temp db, journal,
> > everything) will be encrypted.
>
> Guys.
Hi Kevin,
It is working by the following fix. Instead of attaching the DB, we are opening
the DB.
open 'SP_R3.s3db' ;
BEGIN TRANSACTION;
CREATE view view1] as select model from windturbine;
COMMIT;
.exit
Regards,
Manoj
-Original Message-
From: sqlite-users-bounces at
Kevin, I am getting two rows as follow:
0|main|
2|sprdb|C:\Users\manojkumar.pa\Desktop\SP\DBManagementService\Data\SP_R3.s3db
Regards,
Manoj
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Kevin
Thanks for the reply Kevin. But it didn't worked.
Regards,
Manoj
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Kevin Benson
Sent: Thursday, April 23, 2015 2:05 PM
To: General Discussion of
Hi Simon,
I have tried the text you have given in the shell tool. Still I am getting the
same error. Before executing the commands I am able to open the database. After
executing the DB is getting corrupted. I am getting following error when I try
to open DB.
qAdmin: Cannot perform this
On Thu, Apr 23, 2015 at 5:16 AM, Manoj Kumar Pasumarthi <
manojkumar.pa at hcl.com> wrote:
> Kevin, I am getting two rows as follow:
>
> 0|main|
> 2|sprdb|C:\Users\manojkumar.pa
> \Desktop\SP\DBManagementService\Data\SP_R3.s3db
>
> Regards,
> Manoj
>
> -Original Message-
> From:
On Thu, Apr 23, 2015 at 4:58 AM, Manoj Kumar Pasumarthi <
manojkumar.pa at hcl.com> wrote:
> Thanks for the reply Kevin. But it didn't worked.
>
If you issue the following after you do your ATTACH:
PRAGMA database_list;
do you see a row returned for that database you are ATTACHing?
--
--
On Wed, Apr 22, 2015 at 11:49 AM, Manoj Kumar Pasumarthi <
manojkumar.pa at hcl.com> wrote:
> Hi,
>
> I am trying to create a new view through command line script (sqlite3) as
> follow:
>
>
> attach 'SP_R3.s3db' as sprdb;
>
> BEGIN TRANSACTION;
>
>
> CREATE view sprdb.[view1] as select model from
On Tue, 21 Apr 2015 18:09:33 -0700
Ashish Sharma wrote:
> Many times I store JSON data in sqlite. It will be useful if sqlite
> came with functions which understand JSON. Presto has a nice set
> https://prestodb.io/docs/current/functions/json.html
In case you don't know, you could implement
On Wed, 22 Apr 2015 16:56:07 +0100
Simon Slavin wrote:
> You have made me realise, however, that a nice attack against
> encrypted SQLite databases might be to crash a SQLite application
> while it's processing and examine any journal files, shared memory
> file and temporary index files. It
On Wed, 22 Apr 2015 22:28:57 +
"Drago, William @ CSG - NARDA-MITEQ" wrote:
> When using SQLite the application program accesses the SQLite DBMS
> via its .dll file.
The DLL is a function-call library. A function is a named bit of
code. To "call a function" is to jump to that named bit of
Drago, William @ CSG - NARDA-MITEQ wrote:
> All,
>
> I'm not sure how to ask this question.
>
> When using SQLite the application program accesses the SQLite DBMS
> via
its .dll file. When using something like Oracle Express (a local DBMS)
the application program is communicating with Oracle
On 22 Apr 2015, at 11:28pm, Drago, William @ CSG - NARDA-MITEQ wrote:
> So, SQLite databases are accessed via .dll where as other local databases run
> a server that is accessed via ???
Most database systems have client/server architecture. There is somewhere a
server. The only program
20 matches
Mail list logo