On Fri, 14 Nov 2014 19:23:50 +0100 (CET)
Michael Van Canneyt wrote:
> a) Did you do an insert right before the call to GetInsertID ?
> b) Is the transaction active after the insert ?
> c) The connection transaction should be the same as the transaction of the
> insert.
Got it working.
MySQL55
On Fri, Nov 14, 2014 at 8:32 PM, Marco van de Voort wrote:
> On Fri, Nov 14, 2014 at 03:11:30PM +0100, Michael Van Canneyt wrote:
> >
> > By the very nature of the problem: GetLastAutoIncValue simply cannot be
> implemented in general.
> >
> > In firebird, postgres,
>
> (and Oracle afaik)
>
> > t
On Fri, Nov 14, 2014 at 03:11:30PM +0100, Michael Van Canneyt wrote:
>
> By the very nature of the problem: GetLastAutoIncValue simply cannot be
> implemented in general.
>
> In firebird, postgres,
(and Oracle afaik)
> these values are generated using a generator/sequence.
> You don't know the
On Fri, Nov 14, 2014 at 3:23 PM, Michael Van Canneyt wrote:
>
> On Fri, 14 Nov 2014, Reimar Grabowski wrote:
>
>> On Fri, 14 Nov 2014 14:50:20 +0100
>> Reimar Grabowski wrote:
>>
>> On Fri, 14 Nov 2014 14:15:08 +0100 (CET)
>>> Michael Van Canneyt wrote:
>>>
>>> Connections for databases that h
On Fri, 14 Nov 2014, Marcos Douglas wrote:
specify a refresh SQL statement.
(coincidentally: these are the engines that use autoInc type fields
instead of sequences)
This option, to specify a SQL statement, is the programmer that write
the SQL? This should come from driver, don't?
If th
On Fri, 14 Nov 2014, Reimar Grabowski wrote:
On Fri, 14 Nov 2014 14:50:20 +0100
Reimar Grabowski wrote:
On Fri, 14 Nov 2014 14:15:08 +0100 (CET)
Michael Van Canneyt wrote:
Connections for databases that have lastinsertID you can call the method
created for this:
Function GetInsertID: i
On Fri, 14 Nov 2014 14:50:20 +0100
Reimar Grabowski wrote:
> On Fri, 14 Nov 2014 14:15:08 +0100 (CET)
> Michael Van Canneyt wrote:
>
> > Connections for databases that have lastinsertID you can call the method
> > created for this:
> >
> > Function GetInsertID: int64;
Unfortunately it does no
On Fri, Nov 14, 2014 at 2:11 PM, Michael Van Canneyt
wrote:
>
>
> On Fri, 14 Nov 2014, Marcos Douglas wrote:
>
>>> Your remarks sound like maybe you don't understand/know exactly what
>>> RETURNING does ?
>>> It was invented exactly to deal with such things.
>>
>>
>> AFAIK RETURNING is a SQL claus
On Fri, Nov 14, 2014 at 9:05 AM, Juha Manninen
wrote:
> On Fri, Nov 14, 2014 at 6:46 PM, Mehmet Erol Sanliturk
> wrote:
> > This is "official" Fedora 20 ( latest distribution ) package supplied as
> > 1.0.8 .
>
> Yes, the "official" packages of many distros are old. We cannot help that.
> You sh
On Fri, 14 Nov 2014, Marcos Douglas wrote:
Your remarks sound like maybe you don't understand/know exactly what
RETURNING does ?
It was invented exactly to deal with such things.
AFAIK RETURNING is a SQL clause. I know that but I never used before.
You tell me SQLdb will use RETURNING claus
On Fri, Nov 14, 2014 at 6:46 PM, Mehmet Erol Sanliturk
wrote:
> This is "official" Fedora 20 ( latest distribution ) package supplied as
> 1.0.8 .
Yes, the "official" packages of many distros are old. We cannot help that.
You should load Lazarus trunk from SVN. A new version 1.4 will be
forked so
On 14/11/2014 17:46, Mehmet Erol Sanliturk wrote:
> This is "official" Fedora 20 ( latest distribution ) package supplied as
> 1.0.8 .
Well, that may be, but it is still old. A lot of bugs have been fixed since.
--
___
Lazarus mailing list
Lazarus@lists
On Fri, Nov 14, 2014 at 8:40 AM, Juha Manninen
wrote:
> On Fri, Nov 14, 2014 at 2:30 PM, Mehmet Erol Sanliturk
> wrote:
> > From ( OS installed version is 1.0.8 )
>
> You mean the Lazarus version is 1.0.8? It is old!
>
> > Lazarus -> Project -> New Project from File ->
> > ...
> >
> >
On Fri, Nov 14, 2014 at 2:30 PM, Mehmet Erol Sanliturk
wrote:
> From ( OS installed version is 1.0.8 )
You mean the Lazarus version is 1.0.8? It is old!
> Lazarus -> Project -> New Project from File ->
> ...
>
>
>
I cannot reproduce in trunk. Please test again using trunk.
Ju
On Fri, Nov 14, 2014 at 11:43 AM, Michael Van Canneyt
wrote:
>
>
> On Fri, 14 Nov 2014, Marcos Douglas wrote:
>
>>> By the very nature of the problem: GetLastAutoIncValue simply cannot be
>>> implemented in general.
>>>
>>> In firebird, postgres, these values are generated using a
>>> generator/se
On Fri, 14 Nov 2014 12:49:44 -0300
silvioprog wrote:
> This means that the value returned by the function to a given
> client is the first AUTO_INCREMENT value generated for most recent
> statement affecting an AUTO_INCREMENT column *by that client*.
Just to clarify, the 'first' here is importa
On Fri, Nov 14, 2014 at 12:49 PM, silvioprog wrote:
> On Fri, Nov 14, 2014 at 11:43 AM, Michael Van Canneyt <
> mich...@freepascal.org> wrote:
> [...]
>
>> AFAIK Only sqlite does not (maybe it does today). But that is not a DBMS
>> :-)
>
>
> Yes. It would be nice execute the "last_insert_rowid()"
On Fri, Nov 14, 2014 at 11:47 AM, Michael Van Canneyt <
mich...@freepascal.org> wrote:
[...]
> I was planning some fallback mechanism, yes. And a "class function
> SupportReturningClause : Boolean" or something similar.
> Or maybe
>
> TDBCapability = (lastID,returningclause);
> TDBCapabilities = s
On Fri, Nov 14, 2014 at 11:43 AM, Michael Van Canneyt <
mich...@freepascal.org> wrote:
[...]
> AFAIK Only sqlite does not (maybe it does today). But that is not a DBMS
> :-)
Yes. It would be nice execute the "last_insert_rowid()" to return it in the
same cursor (AFAIK, Android SDK use this mecha
On Fri, 14 Nov 2014 15:55:07 +0100
Michael Schnell wrote:
> Are we (still) talking multi-core systems gaining performance by really
> parallel work ?
No, we aren't talking anything (see second mail).
If you did not get it there may be a problem with your mail client(1), if you
got it (must have
On Fri, 14 Nov 2014, luiz americo pereira camara wrote:
2014-11-14 11:43 GMT-03:00 Michael Van Canneyt :
On Fri, 14 Nov 2014, Marcos Douglas wrote:
This RETURNING clause works for all DBMS?
AFAIK Only sqlite does not (maybe it does today). But that is not a DBMS
On 11/14/2014 01:16 PM, Reimar Grabowski wrote:
but you actually gain nothing, because of how the drivers work.
Are we (still) talking multi-core systems gaining performance by really
parallel work ?
You will gain nothing in the work of the GUI framework called by the
Lazarus program *if* t
On Fri, 14 Nov 2014, silvioprog wrote:
On Fri, Nov 14, 2014 at 11:11 AM, Michael Van Canneyt
wrote:
[...]
By the very nature of the problem: GetLastAutoIncValue simply cannot be
implemented in general.
In firebird, postgres, these values are generated using a
generator/sequenc
2014-11-14 11:43 GMT-03:00 Michael Van Canneyt :
On Fri, 14 Nov 2014, Marcos Douglas wrote:
>
>
> This RETURNING clause works for all DBMS?
>>
>
> AFAIK Only sqlite does not (maybe it does today). But that is not a DBMS
> :-)
>
MySQL also does not implement it
This is the workaround i use today:
On Fri, 14 Nov 2014, Marcos Douglas wrote:
By the very nature of the problem: GetLastAutoIncValue simply cannot be
implemented in general.
In firebird, postgres, these values are generated using a
generator/sequence.
...as well as could have a trigger for these cases, encapsulating the
"pro
On Fri, 14 Nov 2014, Martin Schreiber wrote:
On Friday 14 November 2014 15:11:30 Michael Van Canneyt wrote:
The idea is to add [pfRefresh] to providerflags.
When doing an insert, the fields with this flag will be added to the
RETURNING clause and used to update the buffer.
I suggest [pfRef
On Fri, Nov 14, 2014 at 11:11 AM, Michael Van Canneyt <
mich...@freepascal.org> wrote:
[...]
> By the very nature of the problem: GetLastAutoIncValue simply cannot be
> implemented in general.
>
> In firebird, postgres, these values are generated using a
> generator/sequence.
> You don't know the
On Fri, Nov 14, 2014 at 11:11 AM, Michael Van Canneyt
wrote:
>
>
> On Fri, 14 Nov 2014, Marcos Douglas wrote:
>
>> On Fri, Nov 14, 2014 at 10:39 AM, Michael Van Canneyt
>> wrote:
>>>
>>>
>>>
>>> On Fri, 14 Nov 2014, Marcos Douglas wrote:
>>>
On Fri, Nov 14, 2014 at 10:15 AM, Michael Van Cann
On Friday 14 November 2014 15:11:30 Michael Van Canneyt wrote:
>
> The idea is to add [pfRefresh] to providerflags.
> When doing an insert, the fields with this flag will be added to the
> RETURNING clause and used to update the buffer.
>
I suggest [pfRefreshInsert,pfRefreshUpdate] as in MSEgui. MS
On 11/14/2014 03:15 PM, Juha Manninen wrote:
How to set item height in ListView?
I added :
ComponentsListView.SmallImages := IDEImages.Images_24;
in the settings GUI and somehow the height is now correct on Windows
but on Linux with GTK2 or with QT it is too low. Parts of icons are
cut off.
On Fri, Nov 14, 2014 at 10:40 AM, Michael Van Canneyt <
mich...@freepascal.org> wrote:
>
> On Fri, 14 Nov 2014, silvioprog wrote:
>
>> On Fri, Nov 14, 2014 at 10:15 AM, Michael Van Canneyt <
>> mich...@freepascal.org> wrote:
>> [...]
>> Connections for databases that have lastinsertID you can
On Fri, Nov 14, 2014 at 10:50 AM, Reimar Grabowski wrote:
> On Fri, 14 Nov 2014 14:15:08 +0100 (CET)
> Michael Van Canneyt wrote:
>
> > Connections for databases that have lastinsertID you can call the method
> created for this:
> >
> > Function GetInsertID: int64;
> That is actually exactly wha
How to set item height in ListView?
I added :
ComponentsListView.SmallImages := IDEImages.Images_24;
in the settings GUI and somehow the height is now correct on Windows
but on Linux with GTK2 or with QT it is too low. Parts of icons are
cut off.
Juha
--
On Fri, 14 Nov 2014, Marcos Douglas wrote:
On Fri, Nov 14, 2014 at 10:39 AM, Michael Van Canneyt
wrote:
On Fri, 14 Nov 2014, Marcos Douglas wrote:
On Fri, Nov 14, 2014 at 10:15 AM, Michael Van Canneyt
wrote:
On Fri, 14 Nov 2014, Reimar Grabowski wrote:
On Thu, 13 Nov 2014 13:26:32
On Fri, Nov 14, 2014 at 10:40 AM, Michael Van Canneyt
wrote:
>
>
> On Fri, 14 Nov 2014, silvioprog wrote:
>
>> On Fri, Nov 14, 2014 at 10:15 AM, Michael Van Canneyt
>> wrote:
>> [...]
>> Connections for databases that have lastinsertID you can call the
>> method created for this:
>>
>>
On Fri, Nov 14, 2014 at 10:39 AM, Michael Van Canneyt
wrote:
>
>
> On Fri, 14 Nov 2014, Marcos Douglas wrote:
>
>> On Fri, Nov 14, 2014 at 10:15 AM, Michael Van Canneyt
>> wrote:
>>>
>>>
>>>
>>> On Fri, 14 Nov 2014, Reimar Grabowski wrote:
>>>
On Thu, 13 Nov 2014 13:26:32 -0300
Marcos D
On Fri, 14 Nov 2014 14:15:08 +0100 (CET)
Michael Van Canneyt wrote:
> Connections for databases that have lastinsertID you can call the method
> created for this:
>
> Function GetInsertID: int64;
That is actually exactly what I was looking for.
I was just too dense to realize that it belongs to
On Fri, 14 Nov 2014, silvioprog wrote:
On Fri, Nov 14, 2014 at 10:15 AM, Michael Van Canneyt
wrote:
[...]
Connections for databases that have lastinsertID you can call the method
created for this:
Function GetInsertID: int64;
There is a plan to let SQLDB retrieve the val
On Fri, 14 Nov 2014, Marcos Douglas wrote:
On Fri, Nov 14, 2014 at 10:15 AM, Michael Van Canneyt
wrote:
On Fri, 14 Nov 2014, Reimar Grabowski wrote:
On Thu, 13 Nov 2014 13:26:32 -0300
Marcos Douglas wrote:
Hi,
Take a look in Greyhound project: https://github.com/mdbs99/Greyhound
I d
On Fri, Nov 14, 2014 at 10:15 AM, Michael Van Canneyt <
mich...@freepascal.org> wrote:
[...]
> Connections for databases that have lastinsertID you can call the method
> created for this:
>
> Function GetInsertID: int64;
>
> There is a plan to let SQLDB retrieve the value of some fields fro the DB
On Fri, Nov 14, 2014 at 9:53 AM, Reimar Grabowski wrote:
> On Thu, 13 Nov 2014 11:33:58 -0300
> silvioprog wrote:
>
> > I use an own "TPreparedStatement" (equivalent to TSQLQuery prepared +
> > Params, but my structure does not uses TDataset) that I get the last
> > inserted ID with (pseudo code
On Fri, Nov 14, 2014 at 10:15 AM, Michael Van Canneyt
wrote:
>
>
> On Fri, 14 Nov 2014, Reimar Grabowski wrote:
>
>> On Thu, 13 Nov 2014 13:26:32 -0300
>> Marcos Douglas wrote:
>>
>>> Hi,
>>> Take a look in Greyhound project: https://github.com/mdbs99/Greyhound
>>
>> I did and could not see how i
On Fri, 14 Nov 2014, Reimar Grabowski wrote:
On Thu, 13 Nov 2014 13:26:32 -0300
Marcos Douglas wrote:
Hi,
Take a look in Greyhound project: https://github.com/mdbs99/Greyhound
I did and could not see how it helps.
Here you can see an example using "last id":
https://github.com/mdbs99/Gre
On Fri, Nov 14, 2014 at 10:05 AM, Reimar Grabowski wrote:
> On Thu, 13 Nov 2014 13:26:32 -0300
> Marcos Douglas wrote:
>
>> Hi,
>> Take a look in Greyhound project: https://github.com/mdbs99/Greyhound
> I did and could not see how it helps.
It has a code that working with auto-inc.
>> Here you
On Thu, 13 Nov 2014 13:26:32 -0300
Marcos Douglas wrote:
> Hi,
> Take a look in Greyhound project: https://github.com/mdbs99/Greyhound
I did and could not see how it helps.
> Here you can see an example using "last id":
> https://github.com/mdbs99/Greyhound/blob/master/test/ghsqltest.pas#L285
Y
On Thu, 13 Nov 2014 11:33:58 -0300
silvioprog wrote:
> I use an own "TPreparedStatement" (equivalent to TSQLQuery prepared +
> Params, but my structure does not uses TDataset) that I get the last
> inserted ID with (pseudo codes):
Sorry, you lost me there, but not a problem (see my response to M
On 14/11/2014 10:01, Tony Whyman wrote:
Is anyone having much luck with Lazarus 1.2.6 and GDB 7.7 (I'm using
Linux Mint 17/Ubuntu 14.4).
As soon as I start using it with anything more than a simple program and
still using the default debug settings, the debugger keeps crashing when
an exception
Dears All ,
>From ( OS installed version is 1.0.8 )
Lazarus -> Project -> New Project from File ->
a *.lpr , or *.dpr file is selected ,
it is generating a
*.lpi
file by using the selected name * everywhere in the *.lpi file ,
BUT in
.
.
.
.
.
Filename Value is s
My last message was just a failure in using my mail client.
Sorry for the noise.
R:
--
___
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
On Tue, 04 Feb 2014 14:19:07 +
Mark Morgan Lloyd wrote:
> and in my experience the thing that's most likely to work is DVD
> playback because the data stream is (as I understand it) sent via a
> backdoor to the graphics chips bypassing most of the kernel and X.
On Linux and BSD at least it'
There is a new feature for reordering tabs and components in the
component palette. See "Component palette" in environment options.
Please test but don't open bug reports yet. The feature is under heavy
development and still has known issues.
One issue is that the tabs show in reverse order sometim
Is anyone having much luck with Lazarus 1.2.6 and GDB 7.7 (I'm using
Linux Mint 17/Ubuntu 14.4).
As soon as I start using it with anything more than a simple program and
still using the default debug settings, the debugger keeps crashing when
an exception occurs. Here's a typical error
While exec
52 matches
Mail list logo