Customer Database app

[Roboblue]

I just quickly put this together for a friend who needed a simple customer database. It has an HTML report feature, a database backup/restore feature, and I'm using WORM's menuhelper.dll to format the menubar. It uses the sqlite plugin and has plenty of room for more features.
Maybe someone can use it and if anyone wants to add to it and repost, that's all right, too.
I really didn't think it worthy of an posting in the examples section.
The apz is 1.1mb, so you will have to download it HERE.

[azmanar]

I just quickly put this together for a friend who needed a simple customer database. It has an HTML report feature, a database backup/restore feature, and I'm using WORM's menuhelper.dll to format the menubar. It uses the sqlite plugin and has plenty of room for more features.
Maybe someone can use it and if anyone wants to add to it and repost, that's all right, too.
I really didn't think it worthy of an posting in the examples section.
The apz is 1.1mb, so you will have to download it HERE.

Thanks for the sample, Robo.

It is a good learning example for me. I feel that it is good enough to be an APP for Small Biz owners.

[Roboblue]

I am glad you are getting some benefit from it. If you like, you can compact it and put it on your example site. It has bits of code from almost everyone in it.
Anyone hosting examples can host ANY example I put up. And I don't care if they are modified, as long as it helps someone.

[azmanar]

I am glad you are getting some benefit from it. If you like, you can compact it and put it on your example site. It has bits of code from almost everyone in it.
Anyone hosting examples can host ANY example I put up. And I don't care if they are modified, as long as it helps someone.

Thanks Robo, for giving the permission.

We really need a 2nd SQL APP sample ( just like a second opinion ).

The one done by Des and yourself will make good comparisons for new users to see different approaches taken for almost similar SQL outputs.

I'll put up this full version in my examples site, and will follow with knock-down versions later.

[bobbie]

Thanks Roboblue, I have something plan for this.

[stickck]

Does anyone have this AMS5 format?

Thanks

Chris

[stickck]

Never Mind! i converted it (except the Menu Bar)

Here you go!

Enjoy

Chris

[stickck]

:Updated table for DaSoulRed


add the phone number column to the database.

To add more columns to an existing database, you'll need this.

if you're starting from scratch, you can just delete the db file and change the line12 script under Project / Actions:

SQLite.Query( bla bla bla bla bla bla bla) you get the idea.

have fun!



This is in AMS 7 format!!!


chris

[DaSoulRed]

Thanks man i just understand the program

Thanks every day i try to ask less and less
Becouse i learn more and more

so thanks who those who helpme in the pass, trust me my level is going up

after all i am not a programer and im not trying to become one

im just want to get better every day

thanks dude

[stickck]

no problem. I've learned ALOT between these forums and the brain picking of the great group of people on here.

[slowe]

Hi firstly can i say thanks for this, as it's what ive been needing for my work for ages,

Can the database be modified to add CVs ? so they can be uploaded to the database and searched ?

Thanks Again

[stickck]

I'm not sure of the exact way to do that, but I would guess that you would have to use TextFile.ReadToTable then use a loop to have it import that table into the database. The help file will give you a great start with that. as for the loop, just right click in your Script panel and choose QUICK SCRIPTS ----- FOR LOOPS. That should get you started in the right direction.

but lets say you only want the Even numbered records imported, then you wold use the FOR LOOPS (WITH STEPS)

--A for loop that counts from 1 to 10 in 2's
min = 0;
max = 10;
step = 2;
for count = min, max, step do
   -- Do something here
end

Hope that helps

Chris

[chtulhu]

First of all very thankful for the work of "Roboblue" as well as modifications and explanations of "stickck"

Would like to know please, how can I change the width of individual columns if possible, I delete a nowrap attribute (HTML), but now I want that certain columns have a specified width ... will be something like <td width = 51%?? but where and how you must place it in another way? by some variable?
Please if you could give me an example I could use, since very expert in the field'm not :P

Of course, thank you very much.