On 6/8/15, Ward Willats wrote:
> Can a prepared statement have more than 1 statement in it (and bind
> parameters across the whole thing)?
>
> Something like:
>
> prepare_v2( h, "one statement ? ; two statement ?", -1, , NULL )
No. A prepared statement is *one* SQL statement, not more than one.
On Mon, 8 Jun 2015 15:28:11 +1000
wrote:
> Thanks for pointing it out, but I knew that the best way to show off a
> language is with examples. That's why there are nine sample Andl
> scripts comprising dozens of individual examples in the Samples
> folder. My guess is if that you're asking me to
Can a prepared statement have more than 1 statement in it (and bind parameters
across the whole thing)?
Something like:
prepare_v2( h, "one statement ? ; two statement ?", -1, , NULL )
bind_int( s, 1, )
bind_int( s, 2, )
(I ask because I am getting a SQLITE_RANGE (25) error just
There are nine sample scripts and dozens of examples in the Samples folder.
Obviously that's the area I need to work on.
Regards
David M Bennett FACS
MD Powerflex Corporation, creators of PFXplus
To contact us, please call +61-3-9548-9114 or go to
www.pfxcorp.com/contact.htm
-Original
Here is my best effort at translating this query into Andl.
(
source_packages [?(release =~
'^(sid|stretch|jessie|wheezy|squeeze)$' )
{ name, release, subrelease, version }] join
source_package_status [?(bug_name =~ '^(CVE-|TEMP-)')
{ rowid:=package, bug_name, vulnerable, urgency }]
Here is my best effort at translating this query into Andl.
(
source_packages [?(release =~
'^(sid|stretch|jessie|wheezy|squeeze)$' )
{ name, release, subrelease, version }] join
source_package_status [?(bug_name =~ '^(CVE-|TEMP-)')
{ rowid:=package, bug_name, vulnerable, urgency }]
Thanks for pointing it out, but I knew that the best way to show off a
language is with examples. That's why there are nine sample Andl scripts
comprising dozens of individual examples in the Samples folder. My guess is
if that you're asking me to write examples, the real lesson is that I didn't
Surely enough, this SQL:
SELECT t2.rental_id, t2.rental_date, t1.film_id, t3.title,
t4.category_id, t5."name"
FROM rental t2
LEFT OUTER JOIN inventory t1
ON ( t1.inventory_id = t2.inventory_id )
LEFT OUTER JOIN film t3
ON (
Can you try changing LHS and RHS in the first ON expression?
The older, larger query has inventory_id on the LHS and film_id on the RHS. Now
you have all fields on the RHS.
It would seem the QP may be inferring LEFT OUTER JOIN ON
( = )
And placing the fields first in the argument list
And
Revisiting a thread from about 3 weeks back, I have another xBestIndex puzzler.
The example query from that thread was:
SELECT t1.rental_date, t1.inventory_id, t8.film_id, t5.title AS Title,
t3."name" AS Category, t4.customer_id, t4.store_id, t4.email,
t5.length
FROM rental
david at andl.org wrote on Monday, June 08, 2015 9:23 AM
>
> Ultimately, I don't think it will really matter, because the role of
> Andl is to be platform independent. Do you care what your SQL product
> is written in?
>
Absolutely. I wouldn't be using SQLite if it wasn't C/C++, and I suspect
Hello,
Can you please tell me how Sub queries in select are parsed ?
Can you please point out which rule in the parse.y file does the job of
parsing this ?
Thank you
On 8 Jun 2015, at 6:28am, wrote:
> Thanks for pointing it out, but I knew that the best way to show off a
> language is with examples. That's why there are nine sample Andl scripts
> comprising dozens of individual examples in the Samples folder. My guess is
> if that you're asking me to write
I suggest you just read the samples off GitHub. They cover the entire
language. Download the binary, run them and you see what they do.
Regards
David M Bennett FACS
Andl - A New Database Language - andl.org
-Original Message-
From: sqlite-users-boun...@mailinglists.sqlite.org
Thank you for your thoughts. You covered quite a few topics.
Is there a PDF? No, but that's a good idea. Did you check out the samples?
They cover the entire language, and I could turn those into a PDF much
faster than a real language. It would take about a month to write a decent
tutorial and
Is the following statement still relevant even with write ahead logging mode
of latest sqlite
"..timeouts will only occur if one thread is attempting to read while
another thread is attempting to write.."
Saurabh
On Sun, Jun 7, 2015 at 4:17 AM, wrote:
> I've been reading this thread with great interest. It parallels the project
> I've been working on: Andl.
>
> Andl is A New Database Language.
>
> Andl does what SQL does, but it is not SQL. Andl has been developed as a
> fully featured database
Any properly written documentation on any subject always begins with an
executive summary (no more than a few pages), an overview (usually a
dozen more pages), then gets into the nitty gritty.
Consider if I want you to write a paragraph in Egyptian Hieroglyphics.
So I provide you with a few
On 8 Jun 2015, at 3:14am, wrote:
> I suggest you just read the samples off GitHub. They cover the entire
> language. Download the binary, run them and you see what they do.
Sorry but no. You have it reversed. Your code isn't going to touch my
computer unless you have already convinced me
On 8 Jun 2015, at 3:12am, wrote:
> Is there a PDF? No, but that's a good idea. Did you check out the samples?
> They cover the entire language, and I could turn those into a PDF much
> faster than a real language. It would take about a month to write a decent
> tutorial and reference, but that
Hello
Exception when using SQLite, Entity FW and programmatically configuring
DBConfiguration.
(BTW it works perfectly fine if settings are done in app.config instead of
programmatic. But as a library developer I do not want to ask clients to put
some config settings in their app.config. I
>> $ curl -6 http://www.sqlite.org/
>> curl: (7) Failed to connect to www.sqlite.org port 80:
>> Connection refused
Richard Hipp wrote:
> Unknown cause. Problem cleared by running "service xinetd restart".
That was quick! Works now, thanks.
(Btw, it was down for at least since beginning of
For a web browser that does not implement a 'happy eyeballs' IPv6 ->
IPv4
fallback mechanism, the www.sqlite.org web server on port 80 is
unreachable,
although it does respond to https on port 443, and ping6 is fine too.
$ curl -6 http://www.sqlite.org/
curl: (7) Failed to connect to
On 2015-06-04 03:04, Darko Volaric wrote:
> Regarding PgSQL, an advantage of encoding your own binary types is that you
> can copy them straight into your code and execute with them directly - I
> use the same encoding/data structures throughout and they serve my code and
> requirements instead of
24 matches
Mail list logo