Search Results - VBForums

Search:

Type: Posts; User: techgnome

Page 1 of 13 1 2 3 4

Search: Search took 0.36 seconds.

  1. Re: Very strange time difference in 2 sprocs run through another sproc.

    Try also http://dbforums.com and http://www.mssqltips.com/ (in the Q & A section).

    -tg
  2. Replies
    9
    Views
    164

    VS 2013 Re: How to declare Button text

    Where and why are you doing this?

    -tg
  3. VS 2008 Re: Naming convention for files and folders in ASP.NET

    The actual used convention isn't important... you can camel case, sentence case, init case, or no case. The key is consistency. As a matter of habbit working on Unix/Linux based servers, which are...
  4. Replies
    6
    Views
    101

    MsOf07 Re: Wrong XL Date, Correct System Time

    There is a difference between "today" - an identifier that doesn't exist... and "Today()" which is a function.

    MONTH(TODAY())
    vs
    Month(today)

    -tg
  5. Replies
    9
    Views
    164

    VS 2013 Re: How to declare Button text

    It's set in the designer file. An instance is created, it's given a name, and the caption is set. Other properties are set as well, and then it's added to the Controls collection of the parent...
  6. Re: How to auto increment on only blanks fields

    so ...
    IF a certain condition is true THEN
    you want to do something
    ELSE
    you want something else



    -tg
  7. Replies
    56
    Views
    788

    Re: If you like your Ebola, you can keep it

    There is a difference between the incubation period and the contagious period. Normally with infections you're most dangerous during the incubation period. With Ebola though, the contagious period...
  8. Replies
    3
    Views
    129

    Re: reconnect to mysql how to

    That's the idea...

    open connection
    do database stuff
    close connection
    do more stuff in the app
    open connection
    do database stuff
    close connection
  9. Re: MySQL , Why this procedure not rolls back

    Ahh.... I wonder if your handler for sqlwarning is overwriting sqlexception.

    According to the documentation:

    http://dev.mysql.com/doc/refman/5.1/en/declare-handler.html

    So it would seem that...
  10. Replies
    6
    Views
    192

    Re: How to remove comma using StreamWriter

    You stuffed the quotes into the wrong spot...



    At first I thought that would just put the quotes around the whole thing... then it made sense...

    I'd keep the quotes closer to the field......
  11. Re: How to auto increment on only blanks fields

    IT sounds like a scoping issue... you shouldn't need to redeclare it, otherwise you lose the original value... but it's also been a while since I've done anything like this in crystal, so I might be...
  12. Replies
    3
    Views
    129

    Re: reconnect to mysql how to

    Only open the connection when you need it, the close it immediately after. Don't just leave it out there hanging.

    -tg
  13. Replies
    12
    Views
    199

    VS 2010 Re: Hostgator connection string ?

    Yeaaah... that's another issue all together. There's a wonderful "feature" in 64-bit windows that causes exceptions to be swallowed up in the FormLoad event...

    The WIndows group sees it as a...
  14. Replies
    12
    Views
    199

    VS 2010 Re: Hostgator connection string ?

    That's how you would do it... make the connection... if there is an error, let it be displayed, don't cover it up with your own message... at least for now... later if you want, add in the message...
  15. Replies
    12
    Views
    199

    VS 2010 Re: Hostgator connection string ?

    That's not the error - that's your error message, but that's not the error. You should be getting a legit error message. I also notice your connection is wrapped up in a Try Catch with an empty...
  16. Replies
    12
    Views
    199

    VS 2010 Re: Hostgator connection string ?

    you shouldn't be getting nothing. You should be getting something... either a connection, data, or an error message. But you will get something.


    -tg
  17. Replies
    56
    Views
    788

    Re: If you like your Ebola, you can keep it

    I remember seeing an algebraic equation once that showed that 2=1 ... not once did it break any algebra rules either. It started with the premise: A=B, B != 0... then it expanded it out, keeping both...
  18. Replies
    56
    Views
    788

    Re: If you like your Ebola, you can keep it

    http://en.wikipedia.org/wiki/Pentium_FDIV_bug


    We can agree that we think we exist... "I think, therefor I am." ??? But I guess it depends on if we take the blue pill or the red pill.

    -tg
  19. Replies
    56
    Views
    788

    Re: If you like your Ebola, you can keep it

    Seemed like a long-winded way of saying "I reject your reality and substitute my own."


    Any one who was around in the early Intel days will be very familiar with the fact that 2 + 2 may or may...
  20. Re: How to auto increment on only blanks fields

    well I don't think whileprintingrecords is supposed to be in the header... assuming for a moment that it's a copy paste error... couldn't tell you. Now, if you want to post what the error message is,...
  21. Replies
    12
    Views
    199

    VS 2010 Re: Hostgator connection string ?

    You'll need to get the connection information from them. A couple things to keep in mind:
    * Server isn't likely to be hostgator.com, it's likely to be something else.
    * you'll need to know if the...
  22. Re: How to auto increment on only blanks fields

    This
    numbervar var;

    var := 6082;

    needs to be done outside of whileprintingrecordsrecords... that's why you're getting 6083 on the reocrds... you're resetting it. it needs to be initialized and...
  23. Re: How do I make a constant string array

    HAving been there done that (albiet a number of years ago), you do not need the size-1 ... passing size is sufficient. At least that's been my experience. Even in cases where the entire buffer gets...
  24. Re: Dynamically Create Text Box With Links To SQL Fields

    That could be taken a number of ways... NSA addressed one...

    Assuming that you're already retrieving the data and now want to BIND the textbox to a field in your datatable... then you would add a...
  25. Replies
    1
    Views
    132

    Re: Windows 10 and VB6 Compatibility

    There are several threads on this already... if you search the forums for "Win10" you should find nearly all of them.
    This one is probably most relevant and current:...
  26. Replies
    6
    Views
    192

    Re: How to remove comma using StreamWriter

    Well the writer only writes out what you send it. It's not going to do anything special for you. So if you want quote marks around your values, you'll need to write them out as well, along with your...
  27. Re: Very strange time difference in 2 sprocs run through another sproc.

    Something else to keep in mind, that cached execution plan is based on that first run... which may be efficient for that run, but could be inefficient for later runs. We found this out the hard...
  28. Replies
    56
    Views
    788

    Re: If you like your Ebola, you can keep it

    Of course... that's why he now has an Ebola Czar... I kid you not.
    https://www.google.com/webhp?q=ebola%20czar

    -tg
  29. Replies
    3
    Views
    120

    Re: VB beginner question

    even easier would be to set the SelectedText property ... one line... nothing more. It'll insert the text where ever the cursor is.



    TextBox1.SelectedText="Gimmie some new text"


    -tg
  30. Replies
    56
    Views
    788

    Re: If you like your Ebola, you can keep it

    Who woulda thunk that Faux News would be the voice of reason... so far this is the best report I've seen on the issue....
  31. Replies
    6
    Views
    192

    Re: How to remove comma using StreamWriter

    Count2 will NEVER equal numCols:
    For count2 As Integer = 0 To numCols - 1

    So this will ALWAYS be true:
    If (count2 <> numCols) Then

    and is why you're getting a comma.

    -tg
  32. Replies
    56
    Views
    788

    Re: If you like your Ebola, you can keep it

    3998 of those 4000 were in W. Africa, where they've been battling it for years. There are a number of issues leading to the high numbers there. The biggest is a social one and a fear & distrust of...
  33. Re: Return specific row from DataRow collection

    XMLDataRows(11) ???? it's an array like any other... so I don't see why it should be any different from an array of integers.


    -tg
  34. Replies
    2
    Views
    113

    Re: ENROLLMENT System using VB6.0

    The codebank is for sharing code... not asking for it. I'll ask the mods to move it to a more appropriate forum.

    -tg
  35. Re: Add First Row to Read "--Please Select--"

    Union statement columns take on the names fgrom the FIRST select... so in your select there is no OrganisationName ... there's Expr1 and Expr2 ... also the order by will apply to the WHOLE statement,...
  36. Re: cant fix the errors in my battleships game

    1) no one's going to fix your code for you blindly. Put some effort. At least mark the line(s) where you're getting errors and what the errors are.
    2) No one like looking at a wall of code like...
  37. Re: Add First Row to Read "--Please Select--"

    I usually do it as part of the SQL ...



    select -1, '- Select one -'
    union all
    select ID, Description
    from LookupTable
  38. Replies
    4
    Views
    150

    VS 2010 Re: Adding SubItems to listview

    I agree... there's nothing in that code that wipes anything out. If that's the effect you're seeing though, then there's more to your code. If I had to guess which eel you're using in your...
  39. VS 2010 Re: Loading list of files into a pre-defined directory into a listbox, then loading t

    Getting the list of file has nothing to do with opening the file... period. end of story. There is NO correlation between the two.
    At any rate, GetallBytes works because it opens the file reads it,...
  40. VS 2010 Re: Loading list of files into a pre-defined directory into a listbox, then loading t

    You've got something that is currently an object... what does your code look like now? We can only guess what the changes you've made are.

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



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.