Even in today's world there are sysems (the ones i know for sure are
atmel's avr and microchip's pic, both microcontrollers with Harvard
architecture) for which the equality of dara and code pointers does not
stand.
By the way some PICs have a 12-14 or 24 bit wide program bus to complicate
the
On 2016/01/16 7:02 AM, audio muze wrote:
>> What do you mean by "parse" ? Just to separate a string into its delimited
>> substrings ? Since SQLite has no array or list variable-type there's no way
>> to do that because there's no way to return the result. Can you not just
>> return the
On 2016/01/16 10:18 AM, audio muze wrote:
> Thanks Keith
>
> That's what I'd tried with my first attempt but naturally it didn't work.
>
> Why is it that SQLite does not support a FROM clause in an update statement?
Because of the intent expressed with the word "Lite" in SQLite and the
fact
On Sat, 16 Jan 2016 10:18:28 +0200
audio muze wrote:
> Why is it that SQLite does not support a FROM clause in an update
> statement?
I can't answer why, but I can tell you it's fraught with potential
error. Inventing syntax runs the risk of supporting undesirable
behavior.
SQL Server has
On Fri, 15 Jan 2016 21:41:41 -0500
Richard Damon wrote:
> there are machines where it doesn't work (you just need a larger
> program space than data space).
Huh. An example of which is the "medium model" of the Intel 8086:
20-bit code pointers and 16-bit data pointers. A machine for which C
On 16 Jan 2016, at 2:31pm, R Smith wrote:
> There is of course no SQL function to do this, but thanks to CTE we can
> achieve it easily (though not extremely efficiently).
I thought that WITH could be used only for SELECT statements.
Oh wait, you want to use the WITH statement as a
> I can't answer why, but I can tell you it's fraught with potential
> error. Inventing syntax runs the risk of supporting undesirable
> behavior.
>
> SQL Server has such a syntax. Unfortunately, when you say:
>
> update T ... from S
Pretty much everything does. Yes, Sybase Transact
On Sat, Jan 16, 2016 at 1:58 PM, James K. Lowden
wrote:
> On Fri, 15 Jan 2016 21:41:41 -0500
> Richard Damon wrote:
>
> > there are machines where it doesn't work (you just need a larger
> > program space than data space).
>
> Huh. An example of which is the "medium model" of the Intel 8086:
>
On 16 Jan 2016, at 5:02am, audio muze wrote:
> The fields in question have content as follows:
> string1\\string2\\string3\\...\\stringx
>
> I want to write every record's entries to a table with each element
> being a separate record i.e.
This would require a different number of INSERT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 15/01/16 13:16, Matthew Allen wrote:
> Yeah in hindsight it wasn't the best. I was trying to do:
>
> while still running: p.communicate etc
>
> Poll is not the right method to call.
It especially is the wrong method in your scenario since you
Thanks Keith
That's what I'd tried with my first attempt but naturally it didn't work.
Why is it that SQLite does not support a FROM clause in an update statement?
On Sat, Jan 16, 2016 at 10:07 AM, Keith Medcalf wrote:
>
> Of course, if there was a FROM clause for UPDATE it would be as simple
> Is it a typo in inner query or you ARE asking for a resource from target?
Apologies all, I'm fast asleep, it should've read:
UPDATE target
SET resource = (
SELECT s.resource FROM source s
WHERE ( s.ID = ID AND s.resource IS NOT NULL )
);
On 16 January 2016 at 07:16, Roger Binns wrote:
>
> > while p.poll() == None: resp = p.communicate() print len(resp[0]),
> > resp[0]
>
> That code doesn't make sense. communicate waits until the process
> terminates. The SQLite shell won't terminate unless it gets a quit
> command, or EOF on
Apologies if I'm asking an obvious question, but I've searched and
tried various options and have not been able to arrive at an UPDATE
statement in SQLite that does what I need.
I've two tables with a unique identifier that enables me to link them.
I'm wanting to update the values of a particular
> What do you mean by "parse" ? Just to separate a string into its delimited
> substrings ? Since SQLite has no array or list variable-type there's no way
> to do that because there's no way to return the result. Can you not just
> return the value retrieved from the table and parse it in
Hi,
On Sat, Jan 16, 2016 at 12:58 AM, audio muze wrote:
> Apologies if I'm asking an obvious question, but I've searched and
> tried various options and have not been able to arrive at an UPDATE
> statement in SQLite that does what I need.
>
> I've two tables with a unique identifier that
Of course, if there was a FROM clause for UPDATE it would be as simple as:
UPDATE target
SET resource = source.resource
FROM source
WHERE source.id = target.id
AND source.resource IS NOT NULL;
This is semantically the same as:
SELECT ...
FROM target, source
WHERE source.id =
On Friday, 15 January, 2016 22:58, audio muze said:
> Apologies if I'm asking an obvious question, but I've searched and
> tried various options and have not been able to arrive at an UPDATE
> statement in SQLite that does what I need.
> I've two tables with a unique identifier that enables me
Hello !
When testing one application that uses sqlite3 with "-fsanitize=address" I
was getting an error:
==1310==ERROR: AddressSanitizer: heap-use-after-free on address
And after study the code I found that the problem is in the function
openDatabase in src/main.c , it only happens when
19 matches
Mail list logo