PureBasic Forums - English

According to me, the link is still pointing to 1.01.00 instead of 1.01.01.

Strange, mabe it has something to do with a proxy.
Here another link with a different name: http://www.xideas.de/purebasic/WSQB_PBC ... V10101.zip

Yes, that's OK for this link
And it's OK for table description with varchar . However, there are still 1 (for all fields excepted the first one) or 2 (for the first field) small cabalistic caracters (like small squares) on the left of the field name, for example :

[][](field name

Here is the french translation (CSauer, I put below SQL queries because I can't upload wsqb.db (I'm at work ), is it ok for you ?)
I use counters from 300 to 363 and I put 363 in table sqlite_sequence.
Tell me if it's OK :

INSERT INTO "_txtres" VALUES(300,'MNUPRG','FR','Programme');
INSERT INTO "_txtres" VALUES(301,'MNUPRGSTICK','FR','Activation de la superposition de la fenêtre principale');
INSERT INTO "_txtres" VALUES(302,'MNUPRGINFO','FR','Informations sur le programme');
INSERT INTO "_txtres" VALUES(303,'MNUPRGQUIT','FR','Quitter le programme');
INSERT INTO "_txtres" VALUES(304,'MNUDB','FR','Base de données');
INSERT INTO "_txtres" VALUES(305,'MNUDBNEW','FR','Créer une nouvelle Base de données');
INSERT INTO "_txtres" VALUES(306,'MNUDBSEL','FR','Changer de Base de données');
INSERT INTO "_txtres" VALUES(307,'MNUDBOPT','FR','Optimiser la Base de données');
INSERT INTO "_txtres" VALUES(308,'MNUTBLNEW','FR','Ajouter une nouvelle table');
INSERT INTO "_txtres" VALUES(309,'MNUTBLEDT','FR','Editer la table sélectionnée');
INSERT INTO "_txtres" VALUES(310,'MNUTBLDEL','FR','Supprimer la table sélectionnée');
INSERT INTO "_txtres" VALUES(311,'PMNUTBL','FR','Gestion de la table');
INSERT INTO "_txtres" VALUES(312,'PMNUTBLNEW','FR','Nouvelle table');
INSERT INTO "_txtres" VALUES(313,'PMNUTBLEDT','FR','Editer table');
INSERT INTO "_txtres" VALUES(314,'PMNUTBLDEL','FR','Supprimer table');
INSERT INTO "_txtres" VALUES(315,'BTNDBNEW','FR','Nouvelle BDD');
INSERT INTO "_txtres" VALUES(316,'BTNDBSEL','FR','Sélection BDD');
INSERT INTO "_txtres" VALUES(317,'BTNDBOPT','FR','Optimiser BDD');
INSERT INTO "_txtres" VALUES(318,'BTNTBLADD','FR','Ajout d'une table');
INSERT INTO "_txtres" VALUES(319,'BTNTBLEDT','FR','Edition d'une table');
INSERT INTO "_txtres" VALUES(320,'BTNTBLDEL','FR','Suppression d'une table');
INSERT INTO "_txtres" VALUES(321,'DBOPEN','FR','BDD ouverte');
INSERT INTO "_txtres" VALUES(322,'TBLWDW','FR','Editeur de table');
INSERT INTO "_txtres" VALUES(323,'TBLBTNSAVE','FR','Sauvegarde');
INSERT INTO "_txtres" VALUES(324,'TBLBTNABORT','FR','Annulation');
INSERT INTO "_txtres" VALUES(325,'TBLNAMECAPT','FR','Nom de la table');
INSERT INTO "_txtres" VALUES(326,'TBLFLDFRAME','FR','Propriétés des champs');
INSERT INTO "_txtres" VALUES(327,'TBLBTNFLDADD','FR','Ajout d'un champ');
INSERT INTO "_txtres" VALUES(328,'TBLBTNFLDSAVE','FR','Modification du champ');
INSERT INTO "_txtres" VALUES(329,'TBLBTNFLDDEL','FR','Suppression du champ');
INSERT INTO "_txtres" VALUES(330,'TBLLSTH0','FR','Nom du champ');
INSERT INTO "_txtres" VALUES(331,'TBLLSTH1','FR','Type du champ');
INSERT INTO "_txtres" VALUES(332,'TBLLSTH2','FR','Primaire');
INSERT INTO "_txtres" VALUES(333,'TBLLSTH3','FR','Index');
INSERT INTO "_txtres" VALUES(334,'TBLLSTH4','FR','Non nul');
INSERT INTO "_txtres" VALUES(335,'TBLLSTH5','FR','Auto incrémental');
INSERT INTO "_txtres" VALUES(336,'TBLLSTH6','FR','Defaut');
INSERT INTO "_txtres" VALUES(337,'TBLTYPE0','FR','TEXT');
INSERT INTO "_txtres" VALUES(338,'TBLTYPE1','FR','INTEGER');
INSERT INTO "_txtres" VALUES(339,'TBLTYPE2','FR','REAL');
INSERT INTO "_txtres" VALUES(340,'TBLTYPE3','FR','BLOB');
INSERT INTO "_txtres" VALUES(341,'TBLTYPE4','FR','NULL');
INSERT INTO "_txtres" VALUES(342,'TBLTYPE5','FR','VARCHAR');
INSERT INTO "_txtres" VALUES(343,'TBLTYPE6','FR','NVARCHAR');
INSERT INTO "_txtres" VALUES(344,'TBLTYPE7','FR','BOOLEAN');
INSERT INTO "_txtres" VALUES(345,'TBLTYPE8','FR','TIME');
INSERT INTO "_txtres" VALUES(346,'TBLTYPE9','FR','DATE');
INSERT INTO "_txtres" VALUES(347,'TBLSTA1','FR','Entrez un nom de table');
INSERT INTO "_txtres" VALUES(348,'TBLSTA2','FR','Il est nécessaire d'ajouter au moins un champ');
INSERT INTO "_txtres" VALUES(349,'TBLDEL','FR','Voulez vous vraiment supprimer la table sélectionnée ?');
INSERT INTO "_txtres" VALUES(350,'QFINISHED','FR','Requête démarrée...');
INSERT INTO "_txtres" VALUES(351,'ROWWDW','FR','Edition de l'enregistrement');
INSERT INTO "_txtres" VALUES(352,'ROWBTNSAVE','FR','Sauvegarde');
INSERT INTO "_txtres" VALUES(353,'ROWBTNABORT','FR','Annulation');
INSERT INTO "_txtres" VALUES(354,'ROWFLDFRAME','FR','Champs');
INSERT INTO "_txtres" VALUES(355,'ROWDLGSAV0','FR','Les changements sur l'enregistrement ont été sauvegardés');
INSERT INTO "_txtres" VALUES(356,'ADMINFWDW','FR','Information');
INSERT INTO "_txtres" VALUES(357,'ADMBACK','FR','Précédent');
INSERT INTO "_txtres" VALUES(358,'ADMINFFRAME','FR','Information sur le programme');
INSERT INTO "_txtres" VALUES(359,'ADMINFCAPT0','FR','Version');
INSERT INTO "_txtres" VALUES(360,'ADMINFC2','FR','[PUREBASIC COMMUNITY EDITION]');
INSERT INTO "_txtres" VALUES(361,'DBSELDLGPAT','FR','Base de données');
INSERT INTO "_txtres" VALUES(362,'DBSELDLGHEAD','FR','Veuillez sélectionner un fichier BDD SQlite');
INSERT INTO "_txtres" VALUES(363,'OPTDLG','FR','Base de données optimisée');
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('_txtres',363);
CREATE INDEX _txtres_reskey ON _txtres (reskey);
CREATE INDEX _txtres_lang ON _txtres (lang);
COMMIT;

Another thing : Is it possible to implement
1/ Schema export
2/ Database export
3/ Tables export (result like bcp out for SQL Server for example in ASCII mode)
4/ View creation

Thank you. I will implement French ressources with next release. I will feature some more requests, so I would like to ask you for additional translations as well.

You can use following query to make a french copy of all new ressources: I put your request on my todo list. You will see them on next releases.

What do you think, is this a sell-able program? I am thinking of appr. 10 Euro each copy for a full featured version. I would keep a base featured version for free. Testers like GG would get a license key for free.
What do you think about this?

CSAUER wrote:What do you think, is this a sell-able program?

Well, there are some which are free, for example :

- SQLite Database Browser 1.3 http://sqlitebrowser.sourceforge.net/
- SQLite Administrator 0.8.3.1 http://sqliteadmin.orbmu2k.de/
- SQLite 2007 Pro (Nice look) http://www.osenxpsuite.net/?xp=3
- SQLiteman 1.0 http://sqliteman.com/

I'm not sure if there is a place to have a non-free SQLite Database Software unless your soft has some more great features soft listed above don't have...

CSAUER wrote:Testers like GG would get a license key for free.

Very good idea

Another request :

5/ Any chance to have hotkeys (after typing a SQL query, type CTRL+E to Execute) ?

Hi all,

I would like to announce my next release with a few more wishes implemented, so you are able to have:

- a recent database history
- a recent query history
- export of query result
- import of query
- export of database dump (optionally including data)
- view indexes on database tree (optionally)
- German/English and experimental French language support (via preferences file)

Link: http://www.xideas.de/purebasic/WSQB_PBC ... V10200.zip

On topic for next version:
- views
- hotkeys
- program settings (like language setting, etc.)
- tabs for more than one query at once

Looking forward to your resoonse to get a feeling if there is an interest on this product.

Hi CSAUER,

Thanks for your new release.

I discovered one weird thing in your wsqb.db database. The caracter ' (quote) is translated in #~#. Try the following query to see what I mean : select * from _txtres where txtresid=358. Problem of ISO parameter in your db ? Problem of copy / paste from this forum where I put the french translation ?

Another thing that could be interesting : being able to copy from/to the query form (with a right click for example).

CSAUER wrote:Looking forward to your response to get a feeling if there is an interest on this product

For me, there is a big interest, because my 4000 lines financial project is based on SQLite

For french translation I translated some new lines :

MNUDBEXP : Export de la BDD
MNUDBIND : Liste des index
MNUDBREC : BDD récentes
MNUQRY : Requête
MNUQRYLOAD : Charger la requête
MNUQRYCLR : Effacer la requête
MNUQRYREC : Requêtes récentes
MNUQRYEXP : Export du résultat

I'm afraid you'll have some problems with caracter ^ I inserted just above.

Thank you GG for your support.
Yes, that's right. I converted the ' to #@# as this seems to bring conflicts in SQL-expressions as long as this is used for string expressions. You can use ' as well, my program is just only converting #@# to '. Recents are stored similar.

The context menu on SQL edit form is a good idea. I will implement it for next release. [EDIT] Sorry, EditorGadget does not receive RightClick event. So I put it into 'query' menu.[/EDIT]

It looks like you are the only one interested on the program development here in this forum. That's why I am not sure if I should publish next developments in the forum as a free download. If I would not, all interested testers like GG should contact me then via forum message to get a free version.

I think that would be nice to continue posting developments or evolution here in the forum for WSQB. It would show that your project exists in this community. And it's possible that if nobody (except me) seems to be concerned by your project (and I don't think so), tomorrow may change (new members... or actual members who will have to develop using SQLite).

This project must stay in this forum !

GG wrote:I'm not sure if there is a place to have a non-free SQLite Database Software unless your soft has some more great features soft listed above don't have...

I've spent a long time reviewing a bunch of sqlite tools, and for me the biggest frustration is lack of proper unicode support, i.e. foreign text display in the query output window and in the query composition window (e.g. unicode chars for the where clause), and also foreign character data entry as well as UTF-16 database creation (though I guess this is easy with a PRAGMA call). I think there's no one program that can do all this properly & elegantly yet. There are one or two programs that do unicode display & text entry properly. If your program can address all the above, at least unicode people like me are happy.

Also, you're flat out trying to get a response from any of the free program providers.. I can't get SQLite 2007 Pro to run, and got no response from the developer. I guess most of these free programs are not supported or essentially abandoned. For this reason, I tend to stick to commercial tools - though there's no one commercial tool that does it all (maybe SQLMaestro & this one http://www.sqlabs.net/ comes closest, the latter is a beautiful-looking program but has a couple of minor 'rough around the edges' issues, despite that it's nice to use). One free program that is on the right track with unicode is http://www.sqlitestudio.one.pl/ and looks like a good program, but seems to be an admin tool only, i.e. doesn't seem to create a blank db. I think it's essential that admin programs are capable of creating UTF-8 & UTF-16 databases, and more importantly capable of properly allowing data entry/edits in foreign languages (again unicode). Of course, all this may not be so meaningful if you're just dealing with english only, but when you're dealing with foreign chars particular asian languages - it becomes a major issue.

I've quickly tried your program and it doesn't seem to display unicode chars very well for a UTF-16 database.

In summary, I think if the target db engine supports unicode, the admin tool ought to be able to support it thoroughly as well..

Hi CSAUER,

Any news about this project ?

nice, although first impression was "this is crude" because of the layout, I'll have to give it a go though to see how useful it turns out to be

I've been using SQLite3 for my program configs for a while now, it's a great way of storing user profiles, info, etc. in a contained manner without too much of a resource hog.

As the previous poster mentions, all the other tools are pretty much abandoned... and it might just be not the dev's fault but people's as well, so I propose we all cheer up this sort of applications so they keep alive.

It's the dev's fault though when they quit a project and they don't release the source, that's a real pitty.

No, this project is not dead.
I am on it, but I recently concentrated on other applications and the WUI library. Latestly I had a bug in it, that was unsolved. That's why I delayed release for a while.

I updated the program and I "hopefully" added Unicode support. I did not tested it, as I have no example database. But it compiled with "unicode" flag activated. The price for that is, that the Sqlite.dll must now be excluded - as long as PBOSL_LoadDllMemory cannot deal with it.

Internally there has been changed a lot. I changed whole UI to WUI. I've got a cool skin for it (you can see on my WUI posting), but I decided to turn it off by default and keep this as a option as it should look by default like a PB tool.

Next step will be to try to compile it on PB 4.x Mac. We will see if it runs...
For Linux I need to setup a VM first. This could take some time.

@Fred/@Freak:
If there would be a interest, I can give you the sources to include this to the PB package. Then you can rename it like "Purebasic Query Browser". I think it would be a good and required addition to the package. I will support you on adaption.

Regards
CSAUER

nice with the skin looks great but when u use the splitter it flickers like hell
windows xp sp2 here