Re: [Gambas-user] Cannot reduce windows size to modal windows

[Jaume Casado Ruiz]

Ok, then it is a feature, thank you.
I won't use this workaround, in fact I've never used it, I just discovered
it before this email.

I can read this:
"If a resizable window is shown in modal mode, then its initial size becomes
automatically its minimum size."
here:
http://gambasdoc.org/help/dev/guicomp/window

Maybe this can be added to the showmodal documentation, aren't we? Or at
least add a link to the explanation.
http://gambasdoc.org/help/comp/gb.qt/window/showmodal

Now, assuming that I have to adjust the initial Window's size, how is it
better to do? To fix its size in the form editor view (despite some fields
or contents be hidden, probably causing confusion) or programmatically with
ME.Resize()?

Thank you. Regards,

Jaume Casado Ruiz
GPG Key ID: 0xF71B3570

Free software my friend ;-)
--
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user

[Gambas-user] last instert ID in sqlite3

[Jaume Casado]

Hi there.

I'm looking for a function or method in the gb.db component to obtain the ID
of the last element inserted into the database. With the methods Create,
Edit y Find, we can run our Gambas app independently from the chosen engine
database. That's why I wanna know if there is any similar solution to get
the last insert id (of an autoincrement field in a table). Now I am working
with sqlite3 and I don't find the manner. Thus, I did it with the specific
sql query:

hResult = hConn.Exec("SELECT last_insert_rowid() AS id")
RETURN CInt(hResult["id"])

But doing it like this is not database engine independent, because in MySQL
the query was:

SELECT LAST_INSERT_ID();

Searching a little, I've found that the MySQL component includes it already:
22:23 on Oct 25, 2008gambasCommit by dvillalobos :: r1652
/gambas/trunk/gb.db.mysql/src/gb.db.mysql/ (.component .info .project
_MySQL.class): 
(link)


[GB.DB.MYSQL]
NEW: Added the function LastInsertId to _MySQL class, that returns the last
insert id for the current user.

Then, Gambas lets you to get the "last insert id" in a transparent manner?

Thank you a lot,
Jaume


-BEGIN GEEK CODE BLOCK-
Version: 3.12
GCS/E/IT/M/TW d-- s: a- C+++$ UL++ P L+++ E- W+++$
N- !o(--) K- w--(---) !O M-(+) V?(-) PS PE Y+ PGP>+
t@ 5? X+ R tv- b+@ DI-- D G++ e h++(--) r++>+++ y?
--END GEEK CODE BLOCK--

--
-- Free software my friend ;-)
--
--
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
___
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user