Search:

Type: Posts; User: The_Hobbyist

Page 1 of 4 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Having a difficult time visualizing the schema...

    I see your pictures. The sapphire is beautiful! Must be the lighting....lol ;)

    I'm still working through some stuff. I'll report back when I need to.

    Thank you again for this. It is...
  2. Re: Having a difficult time visualizing the schema...

    Thank you. I appreciate this a great deal and will get to looking at it as soon as possible!
  3. Re: Having a difficult time visualizing the schema...

    Well, that's pretty awesome of you! I would be quite interested in looking at that. Thank you!

    Please, take your time. Don't divert your resources away from anything important, I can wait. In...
  4. Re: Having a difficult time visualizing the schema...

    Going back over this thread, I'm only just realizing that I didn't fully answer this question.

    It is to be a single user, single collection application.
  5. Re: Having a difficult time visualizing the schema...

    Thank you Zvoni.
  6. Re: Having a difficult time visualizing the schema...

    Its getting a little confusing here and I've been away all weekend (family obligations). Perhaps I can attempt to clarify:

    The app is to work in two ways - the first portion of the app is to act...
  7. Re: Having a difficult time visualizing the schema...

    I suspect you're right jmc. To be clear, I intend the application to be a single user (me) setup...
  8. Re: Having a difficult time visualizing the schema...

    I don't think I ever made the statement that I want the application to accommodate multiple users. Its intended to be an application just for a single user. The idea of multiple pictures per...
  9. Re: Having a difficult time visualizing the schema...

    I would like that, yes. It sounds scary but I'm willing to give it a go!
  10. Re: Having a difficult time visualizing the schema...

    You're not wrong, Amethyst will always have the same crystal structure but considering that there are 1000's of types of rocks and crystals and only a handful of crystal structures, I thought it best...
  11. Re: Having a difficult time visualizing the schema...

    That's a ton to process! Thank you for the time and effort (everyone). I'm going to ponder this for a while and see if I can make heads or tails of it.

    Thank you again. I'll be back, I'm sure!
  12. Re: Having a difficult time visualizing the schema...

    Yes, after going back and reading my original post again, I see I failed to pose a specific question. Furthermore, I'm not being very clear, that's my fault. Apologies.

    Since the Gemstones table...
  13. Having a difficult time visualizing the schema...

    Part way through the development of my application, I decided that I would add a new chunk of data to the database. There are sort of two sides to my app, a general encyclopedia side and what I want...
  14. Re: [RESOLVED] Working with SQLite and image files? Save the file or the file path?

    Thanks again jmc. I'll dive into those reads soon.

    Cheers!
  15. Re: Working with SQLite and image files? Save the file or the file path?

    Yes I was. Its still a little confusing to me but its less confusing than when I first started down this path. Thanks again for the patience and the help (everyone).
  16. Re: Working with SQLite and image files? Save the file or the file path?

    Thank you! I got it now... You folks are the best! This is how to add the adapter parameter properly:



    .Add("@Picture", DbType.Binary, 0, "Picture")


    Now I'm going to read Zvoni's...
  17. Re: Working with SQLite and image files? Save the file or the file path?

    Yes, jmc, I intentionally didn't tell you what the error was because I'm attempting to figure this out on my own. It's unlikely at this point that I will but I'm making an effort. At the very...
  18. Re: Working with SQLite and image files? Save the file or the file path?

    Thanks. I'll give this a read tomorrow. I appreciate your time.

    Cheers!
  19. Re: Working with SQLite and image files? Save the file or the file path?

    Oh! God.... I don't need anymore holes in my head. Those hole would be just as likely to let stuff out as they are to let stuff in... I already struggle terribly with short term memory less. :ehh:...
  20. Re: Working with SQLite and image files? Save the file or the file path?

    This is a lot to take in jmc. Thank you.
  21. Re: Working with SQLite and image files? Save the file or the file path?

    Thank you! I am now able to open an image file and save it to the database. I was using VarBinary as the data type because it was used in the example. Originally I was trying to use Byte. ...
  22. Re: Working with SQLite and image files? Save the file or the file path?

    OK. Enough of that chit chat... :rolleyes:

    I've decided, based on the fact that my DB is bound to be relatively small that I will go ahead and try to use jmc's method. While working with his code...
  23. Re: Retrieve the autoID # when adding a new row

    Yes, thank you. I had already thought of that. I created a thread in the database forum hoping to discuss the pros and cons of the different methods of image handling before I replied to jmc...
  24. Re: Retrieve the autoID # when adding a new row

    I'm having trouble finding it. The forum's search function seems to return a very broad assortment of threads but this is likely more due to my inability to structure the search properly. Proper...
  25. [RESOLVED] Working with SQLite and image files? Save the file or the file path?

    I've been reading about how best to work with image files using VB.NET and SQLite and how to either save them directly to the database or how to save their file location to the database. Frankly, I...
  26. Re: Retrieve the autoID # when adding a new row

    I can hardly wait to start asking about the code example that jmc offered the forum about 15-16 years ago on how to save image files into the database and then recall them and displaying them in a...
  27. Re: Retrieve the autoID # when adding a new row

    Thanks Wes. Somewhere along the line, I suppose I did remove the WithEvents declaration when defining the dataadapter. Why, when or how it was removed, I don't know. I obviously removed it but I...
  28. Re: Retrieve the autoID # when adding a new row

    Well, that sure helps me to understand what and why this needs to be done. Thank you, this should help me. This is the clearest, easiest to understand (for a lay person) explanation of why this is...
  29. Retrieve the autoID # when adding a new row

    It has been brought to my attention that in order to prevent concurrency errors when editing a newly saved record in the database, that I should retrieve the autoID number of that new record before...
  30. Re: bindingsource.addnew() problematic with data bound Checkbox

    These are good points but likewise, surely you can understand that I've only been doing this for a few weeks. I've been reading as much as I can but not only is it overwhelming at times, I...
  31. Re: bindingsource.addnew() problematic with data bound Checkbox

    Yes, this works perfectly. Thank you - both of you.
  32. Re: bindingsource.addnew() problematic with data bound Checkbox

    I'm using your work around and a regular checkbox - it works perfectly fine. I was really against the ThreeState box if I could help it.
  33. Re: bindingsource.addnew() problematic with data bound Checkbox

    Hey! This hack works! I'm going to run with it. I'd like to understand why it doesn't work the other way but for now, I'll implement it and maybe come back to this issue down the road.

    Thank...
  34. Re: bindingsource.addnew() problematic with data bound Checkbox

    Thank you. You've at least confirmed that I'm not crazy... Well, maybe...lol ;)

    Another interesting tidbit is that when I hit the button to add a new record, the insertion of a new, blank row...
  35. Re: bindingsource.addnew() problematic with data bound Checkbox

    The only thing that I can think of is that the default setting is not actually setting the value to 0 and this is causing problems. If I have no interaction with the checkbox, lets say that I hit...
  36. Re: bindingsource.addnew() problematic with data bound Checkbox

    Oh!! OK.....Lingo! I still get terribly confused with the lingo. Thank you for that clarification. :)

    In any event, I can't make it work yet. I feel like its very close though. Calling the...
  37. Re: bindingsource.addnew() problematic with data bound Checkbox

    I have configured everything on my end as you do above with possibly one exception. I don't know how to define the dataadapter parameter.

    Just to confirm, using DB Browser for SQLite, I do have...
  38. Re: bindingsource.addnew() problematic with data bound Checkbox

    The data column is set so that it will not allow null values with the default value being '0'. Since it is my understanding that I'm trying to work with a regular checkbox and not a three state...
  39. Re: bindingsource.addnew() problematic with data bound Checkbox

    Upon further testing, yes, there appears to be some issues with the records that are saved. I'm trying to determine how and when these records go screwy. Testing now.

    *EDIT for correction
  40. Re: bindingsource.addnew() problematic with data bound Checkbox

    This absolutely fixes my issue! Thank you!

    Just for the record: my data table column type is registered as BOOLEAN with a default value of '0', the checkbox property ThreeState is set to FALSE...
Results 1 to 40 of 142
Page 1 of 4 1 2 3 4



Click Here to Expand Forum to Full Width