Search:

Type: Posts; User: techgnome

Page 1 of 13 1 2 3 4

Search: Search took 4.62 seconds.

  1. Re: Integration web application with local database

    I think you've gone about it all wrong... there shouldn't be a cron job, there shouldn't be a local database... there should only be the remote database. You get your data from it, you manipulate it,...
  2. Replies
    5
    Views
    159

    Re: MVC Core Lessons

    Subscribing/following because at some point, I'd like to figure this out too.


    My guess is if it is expiring that early, it's not for .NET Core.


    -tg
  3. Replies
    6
    Views
    300

    Re: Handles Clause on WithEvent

    Try the tutorial section of this site, as well as www.homeandlearn.co.uk --- never used it, but I've heard others around here swear by it as being pretty good.

    -tg
  4. Re: difference between ! and . character in the syntax of the VBA identifieer

    Say wha?


    Me!TextBox4 = Me!TextBox3

    Works in VB6?
    I know it does when dealing with ADO and recordsets...
    RS!FieldName...
    But this is the first I'm hearing that form!control works too...
  5. Re: difference between ! and . character in the syntax of the VBA identifieer

    This belongs in the VBA section of the forums... the use of the bang operator is a VBA "trick" not a VB one...
    I'll ask the mods to move it.

    -tg
  6. Re: SQL - Query to return sum and 0 if no match is found

    As I said:


    -tg
  7. Re: SQL - Query to return sum and 0 if no match is found

    If it's still not working, then you may want to post some sample SQL that will create the tables and sample data in the tbles that we can use to replicate hte problem... w/o knowing what your data...
  8. Re: SQL - Query to return sum and 0 if no match is found

    Follow:
    You have the following:
    Table A
    1 -- Item 1
    2 -- Item 2
    3 -- Item 3

    Table B
    2 -- Item 2
    3 -- Item 3
  9. Re: vb.net Use a different WebBrowser1 base than IE-11 ?

    Sigh.... by default the browser is set to a compatibility mode equivalent to IE7 ... there's a way to change the compatibility level to something else by updating the registry... search the forums...
  10. Re: SQL - Query to return sum and 0 if no match is found

    Like I said... you need to test for the null-ness of the dates:


    Select HOC.ListItemName,
    Sum(Case When DA.Hierarchy IS not null then 1 else 0 End) As Total
    From DV_ListItems as HOC
    Left...
  11. Re: SQL - Query to return sum and 0 if no match is found

    Well for starters, stop formatting them... formatting implies you care about what they look, which you shouldn't... they're dates... as you have it now, you're treating them like strings. Secondly if...
  12. Re: SQL - Query to return sum and 0 if no match is found

    IT would have been... but then you inner joined here:


    Join [DV_Data_NEW] As NG
    ON NG.DEVIATION_NUMBER = DA.CaseID

    If there is no row in DA, then joining to NG negates the left join......
  13. Replies
    9
    Views
    177

    Re: eliminate multiple zeros

    Why using a sum at all, if you're grouping by all of the fields?



    Wait... are you after a RUNNING TOTAL?

    -tg
  14. Replies
    9
    Views
    177

    Re: eliminate multiple zeros

    And then to eliminate the zeros ...
    use a HAVING:



    HAVING V > 0 and C > 0

    Having works like a WHERE but for aggregate fields.

    -tg
  15. Replies
    9
    Views
    177

    Re: eliminate multiple zeros

    You get that because of this:


    CASE WHEN gross < 0 THEN sum(gross) ELSE sum(0) END AS C

    The use of gross in the case statement is outside of an aggregate...

    It probably should have been...
  16. Replies
    13
    Views
    264

    Re: Jet SQL: Insert Null FK?

    Which is exactly what I did... :D

    hmmm.... I see your point...

    -tg
  17. Replies
    13
    Views
    264

    Re: Jet SQL: Insert Null FK?

    Don't use MAX() ... there's no reason to. Fillings is unique... so you're not going to get more than one... you will get one or nothing...

    -tg
  18. Re: WebBrowser not loading the page correctly

    The WebBrowser control uses IE7 compatibility ... odds are the website is relying on newer capabilities.... Search the forums for IE Compatibility registry setting - it's a matter of changing a...
  19. Replies
    27
    Views
    500

    VS 2015 Re: Calculations not calculating? VBS 2015

    Ummm..... I was using the aggregate, collective "we" ??? :D
    That's my story and I'm sticking to it.


    -tg
  20. Replies
    27
    Views
    500

    VS 2015 Re: Calculations not calculating? VBS 2015

    No, nearly all of us here are either professional developers, owners, or hobbyists in one form or another... development is what we do for a living or fun... I don't think any of us are instructors...
  21. Re: Using public type as input parameter for function

    What you can do:
    Declare variables in a module and use them.
    Declare variables in a sub an use them.
    Declare variables in a module and sub and use them.

    What you CAN'T do:
    Declare variables in...
  22. Re: Delete the last item in listview

    Of course it didn't work... because that's not right... and if you debugged it, you'd see why.

    What do you think this does:


    lvw.ListItems(idx).Checked

    Because I know what it does. It...
  23. Replies
    33
    Views
    816

    Re: Notorius R.B.G ... RIP

    I caught a news report that gave a run down of the potential candidates - all women ... At first I thought maybe it was an attempt to fix the "Grab 'em" problem... then I realized it's an end run...
  24. Replies
    17
    Views
    366

    VS 2017 Re: Importing CSV Strings as numbers

    Yeah,I had issues a few years back is Student IDs where ' solved the issue... at this point, I'm inclined to think about dumping ADO and using TextFieldParser at this point... I've had greater...
  25. Replies
    17
    Views
    366

    VS 2017 Re: Importing CSV Strings as numbers

    I didn't miss it, I just also know Excel does weird things... which is why I wondered what the raw CSV looked like...



    And it looks like this... OK great... Just for fun... And I know that you...
  26. Replies
    17
    Views
    366

    VS 2017 Re: Importing CSV Strings as numbers

    Look at the CSV directly... what's in it? Don't guess what's in it... know what's in it.

    -tg
  27. Replies
    33
    Views
    816

    Notorius R.B.G ... RIP

    It's like someone said, "Well, it can't get any worse."
    And the universe said "Challenge accepted! Death... find a soul to take and make its loss a deep and dark bottomless source of suck."
    And...
  28. Thread: Thanks....

    by techgnome
    Replies
    19
    Views
    652

    Re: Thanks....

    Also some of us have been on the forums long enough to remember parksie ... ::duck:

    We've all had our dark days... and in these strange times, we need to make sure we're taking care of ourselves...
  29. Replies
    7
    Views
    353

    Re: Parameter Issues

    It's using a different style... it's the same as recordset!fieldname... which works well enough, but can have some limitations.

    But... that does make me think of something. Are all the parameters...
  30. Re: Find value that is not included in a group of rows.

    I think you were close with that last one... but here's why it didn't work:
    your CTE is sourced by the table for all records with 'BankResponseRaw' ... So that includes row 1.
    You're then selecting...
  31. Replies
    7
    Views
    353

    Re: Parameter Issues

    To be fair, until we know what the errors are, we can't rule anything out. We also can't rule out the nature of the queries... like you mentioned. SharePoint is horrible to work at times and only...
  32. Re: Running code against Sqlserver worked fine first time but now 'Access denied'

    Couple things:
    1) Why would you have a user folder on the server?
    2) Even if you did, you're not the "user" on the server, the service is... it doesn't have the same context, so your user folder...
  33. Re: 2 projects in solution vut can't debug one of them

    I always forget... and then I'll have to add it twice more (because I'll screw it up the first time and re-add the DLL) ... you do that enough times, you remember these little things.

    -tg
  34. Re: [RESOLVED] SQL - Query to list all year-to-date weeks and sum up occurrences of t

    1) He's already got the week number in the database, so it doesn't need to be recalculating it in the code.
    2) Jeezes... what's wrong with a table with the numbers in it like that, especially for...
  35. Thread: ADO on Lan

    by techgnome
    Replies
    17
    Views
    554

    Re: ADO on Lan

    Through the connection... you establish a connection to the server and issue commands through it, the results come back through that connection.
    Same as how a web browser connects to a web server,...
  36. Re: 2 projects in solution vut can't debug one of them

    Remove the reference.... then Add Reference.... BUT... switch to the projects tab... and select it from there ...
    What's happening is that you're addding the reference to the DLL, but there's no...
  37. Replies
    5
    Views
    262

    VS 2017 Re: Issue with JSON POST using WebClient

    It's possible it's solely a problem on their end....you're getting a 500 internal Server Error... not a bad request... so your request is being accepted, but then something fails on their end. ...
  38. Re: Running code against Sqlserver worked fine first time but now 'Access denied'

    OK, writing files to anywhere in the Program Files is a bad idea... MS has increasingly locked down that folder over the years to prevent users & apps from shooting themselves in the foot. Ideally,...
  39. Thread: ADO on Lan

    by techgnome
    Replies
    17
    Views
    554

    Re: ADO on Lan

    IP addresses change... server names tend to be more static. Plus also if one machine physically needs to be swapped out, using a named server is the way to go.
    As for deleting the mdb file ... 1)...
  40. Thread: ADO on Lan

    by techgnome
    Replies
    17
    Views
    554

    Re: ADO on Lan

    Not to mention good old fashioned proofs of concept - make sample projects and try them out.

    -tg
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width