Search:
Type: Posts; User: pmeloy
Search:
Search took 0.03 seconds.
-
Yes current data would all be kept normalized of course (too hard and slow to keep it denormalized) but I'm thinking that each month or each year I should transfer old transactions into non...
-
In this case it isn't counting. Its the number of items supplied by the user.
-
AH that was it! It didn't like the column name "number". I thought it was a syntax error in the INSERT command like "INSERTINTO" or something like that. I remember running into a similar reserved...
-
I'm calling dataadapter.update() but it says "System.Data.OleDb.OleDbException: 'Syntax error in INSERT INTO statement.'" but the insert statement was generated with an OleDbCommandBuilder so I can't...
-
I have my databased normalized like crazy and I've been thinking about histories. I already denormalize prices when a transaction occurs (store the price itself, not a reference to the price). Prices...
-
I've been trying to figure out how to handle brushes in WPF. I want to let the user configure the colors they like and save that in a database which I've more or less figured out how to do (use...
-
Strange, that query works perfectly in MDBviewer using the SQL window but I'm still getting blank fields using vb2017/wpf, strange. I get the results and just display in an autocolumn datagrid so I...
-
I'm a newb so I can't even imagine what that separate entity might be. I'm very interested now but that is probably better in it's own thread.
-
Ah I finally got what I was looking for. Not useful at all but I really wanted to figure it out
select p.name,s.name,sp.name,sp.servings
FROM (products p
INNER JOIN servings s ON p.servingid =...
-
If Camel and Marlboro red have the same servings then they have the same prices. Marlboro blue is more expensive so I had to create a serving for it alone.
Not every product has a serving, if the...
-
I fail to see the problem. If Camel changes prices then just create a new servings with different prices. If the price was in the product table then I would have to have a different product for...
-
It probably won't be of much help but I added the DB as a datasource so I could get this shot from the designer. A product can only have one serving but a serving can has many servingparts
184968
-
servings and servingparts are still the table names. Category passed though my brain but just didn't seem to fit.
-
Not a reflection on you. I'm a newb basically in all of this so my terminology sucks bigtime
-
Actually it is probably the naming that is confusing. Servings are a way to break up packaged parts or sell prepared items.
Example here in the philippines it is very common to buy a single...
-
Nope, close though-snack bar
-
Sorry I messed up when I said the products to servings were one to one. I was thinking that because one product can have only one servingid. In fact is is many to one so I guess the servings table is...
-
I have three tables. One is a product which I need the id and name from. The second is a servings table that has only two fields, id and name. the third is a servingsparts table with several columns....
-
I finally found out how to get the value of a datagrid cell. Cast e.EditingElement to the type of column then just use it like any other control
Private Sub dg_CellEditEnding(sender As Object,...
-
Actually no, that wasn't it. I set up a test combobox to see what the selectedvalue would be but messed up and said SelectedValue instead of SelectedValuePath. Once I noticed and fixed that the list...
-
Ack I figured it out. I messed up creating the list of classes so the ID is a string, not a number. I was looking at the wrong observablecollection before. It doesn't like a string to set an integer...
-
Yes, it works! My function
Private Function CheckKeyboard() As Boolean
Dim present As Boolean = False
Dim Sq = New SelectQuery("Win32_Keyboard")
Dim objOSDetails = New...
-
I've been experimenting and found out my tablet has three keyboard devices! One is USB and disappears when the keyboard is detached. For this particular tablet I can just look for the USB one and if...
-
Yours looks much more sensible. I was looking at that comparison and thought "What the heck?".
Thanks to that link I searched on some slightly different terms and found a wonderful example that...
-
Well it returns TRUE regardless if it is on my laptop or on my keyboardless tablet :( at least I know I can actually run it. I will deconstruct and check all the results and see if it is able to show...
-
AHHA! It worked this time, I think I forgot to import system.linq the first time! Now to try on my tablet and see if it works correctly
-
AHHA now I see the link. My eyes aren't what they used to be and the font is small so I couldn't tell it was a link until I leaned way in. Yes, that was the article! I'll try it again and post the...
-
Sorry but I didn't see a link and still can't.
-
I've used Combos inside datagrids a lot and never had any problems but for some reason on this one page it doesn't. When I try to change the entry I get a cellendedit event but the cell stays...
-
Like I said the objectsearcher in system.management was the only method I found that actually exists on my system (the references don't exist so neither did the methods). I tried the method they...
-
I've been searching all morning but I can't seem to find a method that will tell me if my tablet has the keyboard attached or not.
I did find one method that I can actually access using management...
-
Nothing like that on my system. Its in system.windows.forms but I'm using WPF so I don't have access to it
-
Yes sorry, wpf. I could have sworn I experimented with me.cursor and it worked fine a couple of weeks ago but not now.
-
I tried F1 and google and the only answer I can find for displaying a wait cursor is
Mouse.OverrideCursor = Cursors.Wait
But that doesn't seem to work in VB2017... Any ideas what else I...
-
Well the click word and hit is helping in a lot of ways. I think that was the best answer to almost every question I have!
-
I never knew that. I've learned a heck of a lot about VS and VB.NET in the last month. I was still thinking VB6 wise. Thanks I will try that - I hope it's better than google results!
-
I have an observablecollection of classes that I would like to sort by two fields "Name" and "ID"
I figured out how to sort by one field with
ProductCollection.OrderBy(Function(n) n.Name)
But...
-
Well I removed the call to that from a combobox textchanged event and it works fine. I guess loading the combobox triggers it too early. I don't really need the combobox event so I will just leave it...
-
There isn't much to explain. I have this button
<Button x:Name="btnAdd" Content="Add" Grid.Row="1" Grid.Column="2" IsEnabled="False"/>
Then in a combobox event I call this sub and I try to set...
-
I try to set .isenabled and end up with a WPF page showing with a null reference exception. If the button existed it would simple enable or disable it
|
Click Here to Expand Forum to Full Width
|