PPL Database Program

[RichardW]

I have been looking for a PPC development tool and having tried several settled on PPL as the fastest and most professional of the bunch. This is not to say it was the easiest to learn. More examples would have been helpful. After acquiring an IPAQ H2210 on ebay I decided to shift my desktop MS Works files to the IPAQ using PPL to provide the same capabilites as Works. Needless to say it is a "work" in progress but at this point I have something that I believe might help newbies to PPL, providing a great many examples.

The attached work1.zip file contains the work1.prj with a readmefirst file explaining how to load and run the project via the desktop IDE. Also included is a compiled desktop application which can be run after unzip. Included are sample databases and help files. This is not the most user friendly application and assumes some familiarity with DBs and SQL requirements.

Let me know of any bugs/fixes/improvements. Edit checks etc. are basic so you could do something unforeseen and get booted out to the OS. I have had some surprises with routines working differently on the 2 platforms. Let me know how it ports to other makes of pocket PCs.
[br]1185131057_404_FT0_work1.zip

[RichardW]

I forgot to include the desktop executable work1pc.exe in the work1.zip file. Here it is just in case you have problems with running and compiling the source code.[br]1185131815_404_FT5998_work1pc.zip

[RichardW]

The winflex.ppl module is missing a line of code which forces a repaint of the flex form after a page scroll event. To correct this add the statement
Form_Repaint(gblCurForm$);
to the end of the flexPageMove procedure.

proc flexPageMove(dir$)
..... code .....
Form_Repaint(gblCurForm$); // add to clear old stuff
end;

This will ensure that scrolling will not leave garbage on the lower parts of the forms.

[kornalius]

Thank you Richard for the great app.

[RichardW]

Thanks Alain. When I have finished PPL Works I will upload it. I am working on import/export functions so users can quickly load or dump databases. Also adding field/column formatting to database and listview.

As I get more familiar with PPL I find better ways of doing things which lets me reduce/reuse routines. I cannot wait to start on game programming but my next task is to convert an Adjusted Cost Base VB6 Application to PPL so I can use my IPAQ for investment/tax tracking.

[RichardW]

Work1 version 1.3 is almost ready. Just waiting to test it under PPL 1.31 as it was developed with sqlite 2. Includes routines found in the forums and demos as well as adding many new ones - my favourite is the immediate IIF. The reporting feature will let you compose simple sql programs as well as extend the reporting options. I use SQL comments as meta commands to my report writer (only 1 command at present to illustrate how to DYI). Also improving help "system" so users can add/edit there own.

[RichardW]

As promised here is the latest version of work1 tested under PPL 1.32 and SQLite 2.8. Check out the readme.txt after you unzip to get commentary and details on loading and using the source in the PIDE. Sample databases and language files are included. Please retain the sub-directory structure of \data and \packagefiles until you see what is under the hood. There are some items that need special handling if you use this on the PPC. When you make an exe for the desktop you must have sqllite_pc.dll in the same "work1" directory. [br]1191779312_404_FT5998_work.zip

[RichardW]

Here is the latest source and executable versions of Work1 tested under PPL 1.51 and SQLite 3.3.13.

Check out the readme.txt after you unzip to get commentary and details on loading and using the source in the PIDE. Same old sample databases and language files are included as with prior version. Retain the sub-directory structure of \data and \packagefiles until you see what is under the hood. There are some items that need special handling if you use this on the PPC(see readme). When you make an exe for the desktop you must have sqllite_pc.dll in the same "work1" directory.

I have uploaded the compiled programs as well (PPCs in serparate zip). Keep the exe program names as is. The main program will expect to find the appropriately named database designer depending on where you are running. The one missing component is the SQLite DLL for the PPC. You will need to include a copy of this in the PPC directory with the Work1PPC.exe program.

[br]1214488919_404_FT5998_work1.zip[br]1214488919_404_FT5998_work1ppc.zip

[zehlein]

wow, richard, this is awesome. But the program crashes everytime I try to open the sample databases on the Desktop-PC.

[zehlein]

wow, richard, this is awesome. But the program crashes everytime I try to open the sample databases on the Desktop-PC!?

[RichardW]

To be sure I downloaded and unzipped work1 from the forum. Then I went to the directory I extracted the files to, double clicked work1pc.exe and "Loaded" (rather than OPENed) the BudgetTest.sql file. It loaded and displayed in the gird control ok on my XP desktop.

Try loading the work1.prj in the PIDE and running from there. Even if the sql dll was missing the program should not crash.

[PointOfLight]

I hate to say it, but the program doesn't work on my machine either.* I've tried both running the executable and running inside of the PIDE.* I get an access violation either way, and when running it through the PIDE I have to actually terminate the application trough Task Manager.* I'm running Win2K Professional.

[RichardW]

did you get the access violation right away before the main form is displayed?

This is a long shot but maybe try substituting your version of sqlite_pc.dll for mine. I did get occasional ownership issues during my compiles on the desktop.

[PointOfLight]

The access violation error came when I tried to load an .sql file, and I did try and replace your version of sqlite3_pc.dll with mine.* That unfortunately didn't help any.* I will try it again when I get home and see if it will run for me there.

[RichardW]

it would be interesting to see if you could create a simple sql database using the designer(which can be run standalone or called thru the menu of the main pgm) and then try adding and saving records thru the main program. This might pinpoint the access problems to the sqlite implementation.

[PointOfLight]

I will try your suggestion when I get back to work on Monday, but I wanted you to know that the work1 did work on my Windows XP Home setup at home.

[RichardW]

Here is the source code for the 2 database programs that make up PPL Work1. The compiled stuff can be found in the old forum. Only the source is here due to the zip file size limitation in the new forum. See the readme.txt after unzipping for more info. There are more helpful hints in the old forum on using the source. The important thing is the DB designer must be compiled before the Works program can call it. You may load and run the dbmaker project in the PIDE. Sample DBs are provided. Unzip and load the work1.prj in the PIDE. As the readme says you will need the sqlite3 DLL in the directory. I have not provide it here.