Program generator

new BookmarkLockedFalling
meerkat
Senior Member
****

meerkat Avatar

Posts: 250

Post by meerkat on Mar 6, 2025 8:45:41 GMT -5

EDIT
---------------------------------------------------------------------------------------------
Lots of cosmetic changes.
Instead of photos only, it now supports all media including photos,music, and video.
It will display or play most major media types including;
Audio - MP3,Wav,Ogg,WMA
Video - MP4,AVI,WMV,FLV
Image - JPEG,PNG,GIF,BMP
Tile the media in a grid similar to photo albums. Click to enlarge any media. Great for photos and video.
Create DropDown, Check Box, or Radio for any field. This is great for referential integrity. For example if you have a gender field, during maintenance could display a radio button for Male or Female.
Auto Seq fields are maintained including reuse of deleted numbers.
-------------------------------------------------------------------------------------------
Download
Last Edit: Jul 10, 2025 8:15:50 GMT -5 by meerkat: new download area
carlgundel
Administrator
*****
Creator of Run BASIC

carlgundel Avatar

Posts: 975

Post by carlgundel on Mar 8, 2025 16:27:25 GMT -5

Wow, I'm going to be really busy. ;)

Thanks.
meerkat Avatar
This should help give you a jump start with RB. Been a while since I used RB, so don't expect the best.
This is a simple program generator. Given a database, and a record Id and optional auto seq, and photo id field, it generates a program. It's a very simple program but should give you the ability to build upon it when installing a system. It generates;
* List the record at 30 Lines per page. Changeable during run.
* Go to Next or Previous page
* Jump directly to a page
* Click on any heading will sort the data in that sequence, Click again and it sorts descending
* View detail
* Login with user/pass you define and it gives you privileges to Add,Change, or Delete
* Adding records finds gaps in the auto sequence field or if none uses the last + 1
If you have no auto sequence field it uses the records rowid
* You can add photos. Normally a photo id is the first 3 characters of the table + the auto sequence field . So for a customer with a customerNum of 123, you should use CUS0123.jpg. Therefore looking at the image directory you know what each photo belongs to
* Create CSV of your selected records and in the order you selected.
* Drill Down. You can drill down with wildcards on multiple fields. The wild cards can search for data that begins with, contains, or ends with.
* Help gives you most of this information.
* I have not fully tested the drop down, radio, or check boxes that can be attached to a field during maintenance.
* I have not tested joins including inner and outer joins. But it's possible to build a temporary record combining the records you would join, generate the code, and change it to the individual records you would normally goin. So it's that simple.

meerkat
Senior Member
****

meerkat Avatar

Posts: 250

Post by meerkat on Apr 19, 2025 21:17:21 GMT -5

Generate RunBasic code to add,change,delete,list,sort,search.
Made a lot of changes to RBgen.

Some additions include; db Tables can have a image Id. You can upload media including movies, music, html, photos and others. you can tile your db table and show a 5across by n nown images. The db table updated from your upload.
It uses imageMagic to dynamically create thumb images for quicker display in grids.
Fields names ending in email will validate entered emails on the client side before being sent to the server.
Fields names ending in url will validate entered urls on the client side before being sent to the server.
Fixed a few bugs.

Download
Last Edit: Jul 10, 2025 8:18:00 GMT -5 by meerkat
metro
Full Member
***

metro Avatar

Posts: 207

Intel Core2 QUAD CPU @2.54 x 4 Mint Linux 19.3 Mate