Forms Question

View: New views
3 Messages — Rating Filter:   Alert me  

Forms Question

by Bugzilla from svetter@ameritech.net :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

  Just starting out with Kexi and so far I think it's great.  Perhaps
when I get familiar with it I can help further develop it.  Or at least
improve on the documentation.  But for now I have a couple of questions
concerning forms.  1) I would like to have a menu form where I can enter
either a ID number which then after pressing the appropriate button it
launches me to a new form where the information is that matches the ID
number.  Can this be done and if so how?  2) If a form is displayed, I
then press a button to launch a query, when the results are returned,
can I have a button or two that, that is associated with each row
returned, when pressed launch the appropriate form?

   Also, can a rule be setup for a input area that it is to match two or
more possibilities?  Such might be that a field is either Male or Female?

Thanks!
_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi

Re: Forms Question

by Bugzilla from staniek@kde.org :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

2008/12/29 scott <svetter@...>:
>  Just starting out with Kexi and so far I think it's great.  Perhaps
> when I get familiar with it I can help further develop it.  Or at least
> improve on the documentation.

Hi Scott,
good to hear your plans :)

> But for now I have a couple of questions
> concerning forms.  1) I would like to have a menu form where I can enter
> either a ID number which then after pressing the appropriate button it
> launches me to a new form where the information is that matches the ID
> number.  Can this be done and if so how?

I am assuming you're using 1.1.3 version from KOffice 1.6.3, as 2.0 is alpha.
It's not possible by setting a property nor using a script (I think)
as there are no bindings for scripts at the interactive level yet.
Using find dialog is the only option virtually close to what you
describe, at the moment.

> 2) If a form is displayed, I
> then press a button to launch a query, when the results are returned,
> can I have a button or two that, that is associated with each row
> returned, when pressed launch the appropriate form?

Not yet. It's useful option indeed.

>   Also, can a rule be setup for a input area that it is to match two or
> more possibilities?  Such might be that a field is either Male or Female?

For two-values-based field, you can use the boolean data type and the
checkbox widget.
For more values, create a small two-column table (ID, Name) and use it
in the lookup column setup (the column in the master table should be
of type Integer. A simple kde-files.org example [1] provides more info
on the design of lookup columns.

[1] http://www.kde-files.org/content/show.php/Simple+Database?content=23137

--
regards / pozdrawiam, Jaroslaw Staniek
_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi

Parent Message unknown Re: Forms Question

by Bugzilla from staniek@kde.org :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

2008/12/30 scott <svetter@...>:
>   Let me ask you this:  Is it possible to define a one to many
> relationship?

Defining database relationships (that could allow for referential
integrity, cascade updates, etc.) is disabled currently, until we find
a way and time to do this in one go for most of our backends (this is
a price we pay for this freedom of choice).

>   Also, is Kexi written in C or C++?

Standard C++, without STL, with currently I-would-say-leading in this
class: Qt [1] and KDE libraries [2] :).

Happy New Year!

[1] http://trolltech.com/products/products/appdev
[2] http://techbase.kde.org/Development


--
regards / pozdrawiam, Jaroslaw Staniek
_______________________________________________
Kexi mailing list
Kexi@...
https://mail.kde.org/mailman/listinfo/kexi