Reply to topic

Starter questions

Ianwhit
Registered Member
Posts
32
Karma
0
OS

Starter questions

Sat Jan 23, 2016 9:34 pm
Hi All - New to this Forum!!

I have been using LO Base and MySQL for some time now for my ex-School Pupils Database but have had problems and in communications with Jaroslaw Staniek he mentioned Kexi.

I did look at Kexi a few years back but could not find some features then that I needed so never used it.
It now looks a lot more interesting. So I set-up a small 'dummy' DB to test it out.

As a result of this I have a couple of questions I can't find an answers for ...

1) How do I know what Database Engine I'm using and where is the data stored?
2) How do I make the Primary Key Auto increment by 1 for each record?
3) I've been able to create and insert Drop Down Boxes but can not find how to put in the options for them??
4) Is there a way to make Kexi start with my Form rather than the Create Screen?

Thanks for any pointers - appreciated.

IanW
Pretoria RSA
User avatar jstaniek
Moderator
Posts
939
Karma
2
OS

Re: Starter questions

Sat Jan 23, 2016 10:17 pm
Ianwhit wrote:1) How do I know what Database Engine I'm using and where is the data stored?
2) How do I make the Primary Key Auto increment by 1 for each record?
3) I've been able to create and insert Drop Down Boxes but can not find how to put in the options for them??
4) Is there a way to make Kexi start with my Form rather than the Create Screen?


Hello Ian and welcome to the forum and the community!

These are good questions for the start.
As usual, documentation, tutorial and (old) samples are here: https://userbase.kde.org/Kexi#Documenta ... nd_Samples

1) How do I know what Database Engine I'm using and where is the data stored. On Kexi startup in Welcome screen you can see the difference between file and server-based projects - the icons are different. See http://kexi-project.org/pics/2.9/kexi-2 ... -icons.png. Kexi uses a term "project" for the complete entity you create, which 'physically' can be database file or server database. There you create tables, queries, forms, etc. Please see the handbook for more info. If you use files you're using the SQLite3 engine, you can store the file(s) on your computer easily in any place, move them, send, etc. If you use server(s) you decide on what kind of server it is, types for Kexi 2.9 are as follows: MySQL (MariaDB works too without noticing any difference), PostgreSQL, MS SQL Server. Note: you cannot reuse existing ones created using other tools, you have to "import" them using Kexi's Import features. For servers you also have to make sure you have permissions for creating databases/accessing them, etc. Kexi isn't a database administering tool, you use dedicated one (or else administrators can help you).

2) How do I make the Primary Key Auto increment by 1 for each record? It's automatic, just mark a column as primary key and it's by default so-called "autonumber". Works with all supported database engine.

3) I've been able to create and insert Drop Down Boxes but can not find how to put in the options for them?? Please refer to http://blog.gmane.org/gmane.comp.kde.us ... h=20090201. Quite typically we call the boxes: combo boxes. Yes we should have it documented in our handbook even if it's easy as soon as you know where to look :)

4) Is there a way to make Kexi start with my Form rather than the Create Screen? You start Kexi with command line options (link) that help to auto-open. Look for User Mode here: kexi-project.org/screenshots.html which also lets you to hide "design" features so your users won't be able to break things too easily. One or more objects of any types can be open this way, and in any view mode (design, data...). You can create shortcut for your desktop and include the options there, then on single click the objects will be opened automatically. It's well understood that eventually Kexi should also have options in its GUI for setting up the auto-open objects and the user-mode.

Hope this helps with the basics.
J.


Best regards,
Jarosław Staniek
Image

KEXI - Open Source Visual DB Apps Builder
• Request feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help
Ianwhit
Registered Member
Posts
32
Karma
0
OS

Re: Starter questions

Tue Jan 26, 2016 12:31 pm
Thanks Jaroslaw

1) OK it's all local so that must be SQLlite - thanks, I'm happy with that.
2) I have set the ContactID to Primary Key but if I try to add a new record I get the error that ContactID has to be entered.
It's NOT doing this automatically.
3) Re Dropdown Boxes/Combo Boxes - I see that you have to set it in the table and not in the Form like Base. I did this but it then lists ALL the values in the Table, (multiples of the same thing!!). What I want is to pull down the box and have the options there to choose from. ie Mr, Mrs, Miss, Doc, Rev, Prof etc etc
4) Fine as long as you can do that I will get into it later!!

New "Funny" .....

When I set-up my "Dummy" Database I put in 5 records.
Today I opened the Form and I find 10 records like this - Nos 1,1,1, 2,2,2, 3,3,3,4,4,4,5. So it has triplicated each of the first 4 records!!???
How does this happen???

IanW
Pretoria RSA

Thanks again
User avatar jstaniek
Moderator
Posts
939
Karma
2
OS

Re: Starter questions

Tue Jan 26, 2016 12:49 pm
@IanW
If you send me the dummy file I may be able to find answers on questions #3 and #5 faster.

Re. 2, If you set primary key for a field (Kexi asks and adds it for you if you forget to), it's autonumber as well by default. You may want to double check if the Autonumber property is set true.

Also, it helps if for any question here version of Kexi is known.

Thanks for trying Kexi!


Best regards,
Jarosław Staniek
Image

KEXI - Open Source Visual DB Apps Builder
• Request feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help

 
Reply to topic

Bookmarks



Who is online

Registered users: Baidu [Spider], Bing [Bot], Google [Bot], Kresimir, Majestic-12 [Bot], Yahoo [Bot]