Bio

[JDog37]

I am trying to make this work, I did however figure out how to add data to the listbox. I am asking for help on the paragraph, and adding photos...:rolleyes

Now I know I got to check the SQLight plugin, but how dose this save?? Pictures, and info?

Sorry for the novice questions. :rolleyes:o

[JDog37]

Have I offended anyone here? I'm NOT being smart or mad. I just don't understand why every time I post something, i seldom get a response?:huh
I know peeps are busy, but there are others who are able to help and they don't. I mean 30 + users read it but not 1 reply? I don't know allot about programing or code but I tried to answer some peeps.

I love this forum and also the people I have met. With that said, I just wish there was more help.

Yes I try to read the "Help" files but to someone learning it dose get confusing. I'm sure I'm not the only one who feels this way.

I, like others, sit and wait for a response, eager to learn and it seems that others who knows more about code, get more attention for there projects.

I am sorry If I have offended anyone...:rolleyes

Thanks.

[Bruce]

Hang in there Jdog! It may take awhile for a responce. :yes

[Dermot]

Your project contains 4 lines of code, come on! You obviously have to do a little more than check the box to use SQLite. Have you looked at the many examples posted on here? Have you looked at the SQLite help file? There is more than enough info available to get started.

In this post you asked about SQLite and were give directions and help http://www.indigorose.com/forums/showthread.php?t=23008&highlight=sqlite+sample . So why not use that to get started at least? Or this http://www.indigorose.com/forums/showthread.php?t=11869&highlight=sqlite+contact+database . You will at least see how to create/open a databse, add new reocrds, edit records etc.

If you want to actually store images in the db, then take a look at this (http://www.clarasolutions.com/downloads/images_in_sqlite.zip) example I did.

By the way, outbursts like this will not help, infact they will have the opposite affect. You basicially posted a blank project and want someone to write the code for you, instead of using the many examples and help file to get at least a partialy working app and then ask for help when you are stuck.

Keep in mind that it is a holiday weekend (at least in Canada), people are busy getting kids ready for back to school etc.

[JDog37]

1St off Dermot, I said, and i quote " I'm NOT being smart or mad." And "I love this forum and also the people I have met. With that said, I just wish there was more help." I was NOT having an "Outburst" as you put it. I have said since I joined I didn't want anyone to "Write the code for me", I think you need to read before you jump and answer with an attitude.

#2) I said, and I quote "Yes I try to read the "Help" files but to someone learning it dose get confusing." I was telling you and everyone else how I had a hard time with them. SORRY everyone dose not have programing or coding experience such as yourself. That's why I ask for HELP.

#3) You said: [Q]By the way, outbursts like this will not help, infact they will have the opposite affect. You basicially posted a blank project and want someone to write the code for you, instead of using the many examples and help file to get at least a partialy working app and then ask for help when you are stuck.[Q] Remember, LEARNING, not trying to make people do it for me. I want to learn how, not have someone do it totally for me. If I would have seen that post then I would have used it and tried to do it on my own. Geeezzz

You just attacked me for no reason. Why? I never asked you for anything. Just because someone has problems, you cant assume they have not tried. I did see the post from desmond, but I aint sure how to implement it into my project. The code i did do, I typed it to understand it, I did not past and copy like most do.

Dude, Sorry to **** you off enough to get that ****ed. BUT I am willing to forget it if you are. This is not what I joined this forum.

Bruce: Thank you for some kind of response, I do appreciate it!:yes

Thanks again.

[Dermot]

Sorry, but I was not attacking you, just pointing out that you can't expect much help when you made no atempt yourself and that people might be busy etc. I was civil and did not use any bad language. I pointed out some things and provided help and examples and I am the one who was attacked.

I posted three links to examples one of which I created myself. These examples have all the code you will need. You just have to change it a little for your app, things like field names etc. They are great for learning from and you keep saying that's what you want to do, so I don't know what else one could do.

Nothing wrong with copy and pasting code as long as you know you will have to make a few changes to suit your project. The SQLite Plugin help file has a ton of code examples that are all explained. Everything is there including craating a db, creating tables, adding fields, adding data, querying data etc.

If it is all to difficult then maybe take a step back and study one of the examples until you have a basic understanding about databases and how to work with them in AMS. Then start your app, either from scratch or by modifying a sample.

[azmanar]

JDog,

I do understand your frustration because I've been there. So, the best way to learn AMS is to search and hack through most examples in Intrigue's collection and all AMS forum examples.

When you really are stucked, pose questions here, politely. What we do here is on our own time.

[Dermot]

Here is my image example modified to do what you wanted.

[DavidVR]

Good work dermont this example is very helpful for everybody, in special for me because now I know how to work with the SQL plugin
:yes:yes:yes
Thanks¡¡¡

[JDog37]

I am sorry if it seemed I atacked you this time. I am frustrated and maybe was'nt to nice on how I chose to reply back.. For that I am truly sorry Dermot.

I thank you for the time you took out for the example. I will try to do more on my own. I just need a little guidance sometimes. Iwill study as much as I can BEFORE, i ask...

I also thank you for the links they are very helpful.

I hope we can chat in the future and maybe even work on a project together where I dont have to ask you all for so much.

Start over?? I'd like that. I mean thats what this forum was built for right! :yes

Again Dermot, sorry for the miss communication, I did thought you did attack me, and I guess I should have thought it out a little more.

Thank you for your replies,
JDog
:yes

[JDog37]

Ok, I tried to build the same project from scratch, I did ok, BUT the save wouldn't work so I copied all objects, checked the SQLight plugin, and no luck:huh

But when I went into the doc folder and copied the db from Dermot it worked???? Now I don't understand why when I copied all objects and page scripts, it wouldn't work, but with Dermot's db it dose?? Can anyone explain it?

I thought when I copied the page script it opens a db. If one didn't exist it would do it for me. That shouldn't make a diff. should it? If so why?

[Dermot]

There is no code in that example for creating the database. I included a pre-built one so there was no point. When you open a database using SQLite.Open(), it will create the database if it does not exist but it will be empty. You have to write code to create the tables, fields etc. There is no way this can be done automatically for you. Creating dabases using code can be tedious especialy if you need a lot of tables with a lot of fields. It is much easier to build the database with a tool like SQLite Browser. http://www.indigorose.com/forums/showthread.php?t=24440&highlight=sqlite+browser

[ShadowUK]

I've had that on my mind for a while, A file database action plugin. To be honest, I'll try it but SQLite is an advanced subject.

You got stuff like INSERT blah INTO blah and SELECT rawr WHERE something = condition.