Search:

Type: Posts; User: pmeloy

Page 1 of 4 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    4
    Views
    979

    Re: When to denormalize?

    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...
  2. Replies
    6
    Views
    873

    Re: OledbDataAdapter insert error

    In this case it isn't counting. Its the number of items supplied by the user.
  3. Replies
    6
    Views
    873

    Re: OledbDataAdapter insert error

    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...
  4. Replies
    6
    Views
    873

    OledbDataAdapter insert error

    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...
  5. Replies
    4
    Views
    979

    When to denormalize?

    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...
  6. Replies
    1
    Views
    2,010

    WPF save colors to database

    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...
  7. Re: Can't quite figure out how to left join two other tables and get data from them

    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...
  8. Re: Can't quite figure out how to left join two other tables and get data from them

    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.
  9. Re: Can't quite figure out how to left join two other tables and get data from them

    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 =...
  10. Re: Can't quite figure out how to left join two other tables and get data from them

    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...
  11. Re: Can't quite figure out how to left join two other tables and get data from them

    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...
  12. Re: Can't quite figure out how to left join two other tables and get data from them

    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
  13. Re: Can't quite figure out how to left join two other tables and get data from them

    servings and servingparts are still the table names. Category passed though my brain but just didn't seem to fit.
  14. Re: Can't quite figure out how to left join two other tables and get data from them

    Not a reflection on you. I'm a newb basically in all of this so my terminology sucks bigtime
  15. Re: Can't quite figure out how to left join two other tables and get data from them

    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...
  16. Re: Can't quite figure out how to left join two other tables and get data from them

    Nope, close though-snack bar
  17. Re: Can't quite figure out how to left join two other tables and get data from them

    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...
  18. Can't quite figure out how to left join two other tables and get data from them

    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....
  19. Re: DATAGRIDCOMBOBOXCOLUM won't change itemssource

    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,...
  20. Re: DATAGRIDCOMBOBOXCOLUM won't change itemssource

    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...
  21. Re: DATAGRIDCOMBOBOXCOLUM won't change itemssource

    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...
  22. Replies
    11
    Views
    1,356

    Re: Detect keyboard present?

    Yes, it works! My function
    Private Function CheckKeyboard() As Boolean
    Dim present As Boolean = False
    Dim Sq = New SelectQuery("Win32_Keyboard")
    Dim objOSDetails = New...
  23. Replies
    11
    Views
    1,356

    Re: Detect keyboard present?

    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...
  24. Replies
    11
    Views
    1,356

    Re: Detect keyboard present?

    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...
  25. Replies
    11
    Views
    1,356

    Re: Detect keyboard present?

    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...
  26. Replies
    11
    Views
    1,356

    Re: Detect keyboard present?

    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
  27. Replies
    11
    Views
    1,356

    Re: Detect keyboard present?

    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...
  28. Replies
    11
    Views
    1,356

    Re: Detect keyboard present?

    Sorry but I didn't see a link and still can't.
  29. DATAGRIDCOMBOBOXCOLUM won't change itemssource

    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...
  30. Replies
    11
    Views
    1,356

    Re: Detect keyboard present?

    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...
  31. Replies
    11
    Views
    1,356

    Detect keyboard present?

    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...
  32. Replies
    7
    Views
    2,175

    Re: Displaying wait cursor in VS2017

    Nothing like that on my system. Its in system.windows.forms but I'm using WPF so I don't have access to it
  33. Replies
    7
    Views
    2,175

    Re: Displaying wait cursor in VS2017

    Yes sorry, wpf. I could have sworn I experimented with me.cursor and it worked fine a couple of weeks ago but not now.
  34. Replies
    7
    Views
    2,175

    Displaying wait cursor in VS2017

    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...
  35. Replies
    9
    Views
    1,985

    Re: Sort observablecollection by two fields?

    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!
  36. Replies
    9
    Views
    1,985

    Re: Sort observablecollection by two fields?

    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!
  37. Replies
    9
    Views
    1,985

    Sort observablecollection by two fields?

    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...
  38. Replies
    5
    Views
    2,610

    Re: vs2017 Wait for WPF to finish?

    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...
  39. Replies
    5
    Views
    2,610

    Re: vs2017 Wait for WPF to finish?

    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...
  40. Replies
    5
    Views
    2,610

    Re: vs2017 Wait for WPF to finish?

    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
Results 1 to 40 of 136
Page 1 of 4 1 2 3 4



Click Here to Expand Forum to Full Width