PLUGIN EXAMPLE: SQLite

[Desmond]

This example demonstrates how to use the SQLite Plugin. The attached project is a simple 'phonebook'. From various input objects it accepts contact info:
First Name
Last Name
Email Address
Phone Numbers
Addresses

The contents of the SQLite database are displayed in a listbox. It allows records to be added, deleted, and modified. As well, a record can be searched for by Last Name.

This project is a example of what can be accomplished using the SQLite plugin. Happy Learning!

Please feel free to download, play with, improve on, and re-post this project file.

Note that this project requires AMS50 PRO and the SQLite plugin to function.

EDIT: Added Screencap

[azmanar]

Mind Reader

Hi,

I like this sample app on how to use SQLite.

You raised the level of Customer Services. Now everyone of them must learn mind-reading skills to be on the job. hehe.

[Desmond]

I'm glad you are finding it useful. Enjoy!

Feel free to make modifications / improvements / whatever and post back here.

[Dez]

I really liked this example...nice job Desmond.

Here is a little interface for the phonebook.
Button file is also attached so you can position to your liking.

I did not add or delete any script.

Dez

[Desmond]

Glad to have helped. Love your forum name, by the way.

[sandstorm]

Error: Plugin "SQLite\SQLite.lmd" is not licensed for re-distribution

Error: Plugin "SQLite\SQLite.lmd" is not licensed for re-distribution

I am getting the above error message when running SQLite apz. How can I resolve this problem?

[playmenow]

reinstall the plugin power pack if u have it or uninstall ams5, restart windows, delete the folder fron program fikes & install ams6...it will work 100%...

[sandstorm]

This example demonstrates how to use the SQLite Plugin. The attached project is a simple 'phonebook'. From various input objects it accepts contact info:
First Name
Last Name
Email Address
Phone Numbers
Addresses

The contents of the SQLite database are displayed in a listbox. It allows records to be added, deleted, and modified. As well, a record can be searched for by Last Name.

This project is a example of what can be accomplished using the SQLite plugin. Happy Learning!

Please feel free to download, play with, improve on, and re-post this project file.

Note that this project requires AMS50 PRO and the SQLite plugin to function.

EDIT: Added Screencap

Thanks for sharing your expertise. I find this very useful for my project. Please help me with this questions:

1. I want to make two fields as searchable, LASTNAME and PHONE NUMBERS. How do I do it?

2. How can I make the EMAIL ADDRESS field clickable?

PLEASE HELP...

[azmanar]

Hi,

I would suggest you use Web Objects to display results for:
1. Email link
2. Search DB

You can do many more things with it.

[sandstorm]

Hi,

I would suggest you use Web Objects to display results for:
1. Email link
2. Search DB

You can do many more things with it.

Thanks for your response. I am not programmer and I don't know how to do it. Can you please help write the code or give me hint on how I can get what I want?

[stickck]

Here's another sample that i converted to AMS5.

Roboblue originally created this sample in AMS6. Thanks Roboblue!

http://www.indigorose.com/forums/showpost.php?p=85433&postcount=7

chris