Search:
Type: Posts; User: The_Hobbyist
Search:
Search took 0.02 seconds.
-
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...
-
Thank you. I appreciate this a great deal and will get to looking at it as soon as possible!
-
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...
-
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.
-
-
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...
-
I suspect you're right jmc. To be clear, I intend the application to be a single user (me) setup...
-
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...
-
I would like that, yes. It sounds scary but I'm willing to give it a go!
-
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...
-
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!
-
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...
-
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...
-
Thanks again jmc. I'll dive into those reads soon.
Cheers!
-
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).
-
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...
-
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...
-
Thanks. I'll give this a read tomorrow. I appreciate your time.
Cheers!
-
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:...
-
This is a lot to take in jmc. Thank you.
-
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. ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
Yes, this works perfectly. Thank you - both of you.
-
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.
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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
-
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...
|
Click Here to Expand Forum to Full Width
|