AutoHotkey Homepage AutoHotkey Community
Let's help each other out
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

#INCLUDE SQLite.ahk - Functions to access SQLite3 DB's
Goto page Previous  1, 2, 3
 
Post new topic   Reply to topic    AutoHotkey Community Forum Index -> Scripts & Functions
View previous topic :: View next topic  
Author Message
nickromano



Joined: 28 Nov 2007
Posts: 25
Location: USA
PostPosted: Sun Jan 06, 2008 8:36 pm    Post subject: Reply with quote
do you think this could be used to edit the calendar on an iphone because it stores the calendar file with a .sqlite extension?
Back to top
View user's profile Send private message Visit poster's website AIM Address
swa
Guest
PostPosted: Tue Jun 17, 2008 12:31 pm    Post subject: Reply with quote
hi nick
i have a problem with the show of a result of a search
i have find thios code

Code:

$sSQL := "SELECT * FROM Test;"
$i := A_TickCount
$iRC := _SQLite_GetTable($SQLITE_h_DB, $sSQL, $sResult, $iRows, $iCols)
If ($iRC <> 0)
{
   MsgBox Fehler bei GETTABLE: %$iRC%
}

But no way to show it on a msgbox %$iRC% i canīt used becouse it must be 0

i hope you can understand me and find a way to help me

soory for the bad english
swa
Back to top
rafael muller
Guest
PostPosted: Tue Jun 17, 2008 11:02 pm    Post subject: It it possible to create client-server applications? Reply with quote
A little question...

Is it possible to use the SQLite + AHK environment to write a client-server application?

Server running SQLite +
4 client computers using the same db.

I am attempting to use a simple and light interface to write an application to simulate an EMR (eletronic medical record) system.

I had written some code in PHP + MySQL, but I found it to be hard and time-consuming writing the code.

Thanks in advance.
Back to top
jetpilot86



Joined: 23 May 2007
Posts: 17
PostPosted: Wed Aug 13, 2008 12:56 am    Post subject: a bit confused Reply with quote
so what else is new.

Will this query an Access Db?

tia

Jet
Back to top
View user's profile Send private message
Bitcloud
Guest
PostPosted: Wed Oct 29, 2008 11:42 pm    Post subject: SQLite major limitations Reply with quote
Hi,

I've been using this script and SQLite, and it's great, but SQLite doesn't seem to support nested queries..

eg:
Code:
SELECT Model FROM Product
WHERE ManufacturerID IN (SELECT ManufacturerID FROM Manufacturer
WHERE Manufacturer = 'Dell')


I managed to find an alternative DLL:
http://sqlite.phxsoftware.com/

this one claims to be a full "drop and replace" for sqlite3.dll and it works for me, but it too doesn't seem to return on nested queries...

The site says it supports "nested transactions" but i'm not sure if this is the same thing as "nested queries". (is it?)

So anyway, to my question Smile
Is there:
a) an alternative syntax I can use to get a nested query? (a left join maybe? I don't know)
b) an alternative SQL dll/method i can use? (MYSQL? or is that just for PHP?)
c) any other workarounds, advice, recommendations?

Thanks in advance Smile
Back to top
IsNull



Joined: 10 May 2007
Posts: 93
Location: .switzerland
PostPosted: Thu Oct 30, 2008 7:04 am    Post subject: Reply with quote
can you post you db layout (tables, fields)? then I try to create your SQL statement Smile
_________________
http://securityvision.ch
Back to top
View user's profile Send private message
Bitcloud
Guest
PostPosted: Thu Oct 30, 2008 12:39 pm    Post subject: Reply with quote
Cheers,

my table layout is:
Quote:
input, output, connection


an example of content would be:
Quote:
john, email, associative
document, send, associative
email, send, associative

send, email, forward
send, document, forward
document, website, forward
email, john, forward


Specifically what i'm trying to achieve is to pull out every "output" where input = 'send' and connection = 'forward', but only if that output is displayed in either "input" or "output" within a query that pulls input and output when the connection is "associative". This is all from a single table

So the single result for the above verbal query would be:
Quote:
send, email, forward
send, document, forward

If you remove the "email, send, associative" entry, it should return only:
Quote:
send, document, forward

(because "email" has a "forward" connection to "send", but not an "associative" one)

Does this make sense?

So I guess the SQL query I WANT to write might look a little like this:
(excuse my poor SQL)
Code:
SELECT * from table WHERE input = 'send' AND connection = 'forward'
AND input IN (SELECT output from table where input = 'send' AND connection = 'associative')
OR output IN (SELECT input from table where output = 'send' AND connection = 'associative')


I'm running in circles with this without being able to nest these queries, but I've heard that joins can do the same job with a bit of trickery, so any help you could give would be really appreciated Smile
Back to top
IsNull



Joined: 10 May 2007
Posts: 93
Location: .switzerland
PostPosted: Sat Nov 01, 2008 9:48 am    Post subject: Reply with quote
Hi Bitcloud,

Well, that looks strange! Laughing

I think your SQL doesn't make sense.


1. So, at first, you should use other names for your fields in the table. input, output etc. are keywords.

2. Is this table createt by yourself? (Maby ots possible to design better table layout, multiple tables ...)

3.


Quote:
Specifically what i'm trying to achieve is to pull out every "output" where input = 'send' and connection = 'forward', but only if that output is displayed in either "input" or "output" within a query that pulls input and output when the connection is "associative". This is all from a single table

Its not quite easy to understand what you want. (your fields have names wich have multiple meanings. Hard to follow you.) Try to explain what you want from the table. So I can create the SQL Statement on my own. Smile
_________________
http://securityvision.ch
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    AutoHotkey Community Forum Index -> Scripts & Functions All times are GMT
Goto page Previous  1, 2, 3
Page 3 of 3

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum


Powered by phpBB © 2001, 2005 phpBB Group