Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JeffTullin

    C++ Dll????

    Is there some reason why you don't just call BitBlt from VB? Declare it from the GDI library and use it directly. (Check the API viewer for the definitions)
  2. JeffTullin

    PROPER (sentence Case) - Howto?

    IMOH, the database isnt the best place for string manipulation, especially from a performance point of view." Customer has a database where 24000 addresses have been loaded all in upper case, and wants them changing to Proper case. How would you personally go about this?
  3. JeffTullin

    PROPER (sentence Case) - Howto?

    I can't find a string function in TSQL to convert strings to Proper case. (Found UPPER and LOWER) In Access , I use STRCONV Does anyone have a ready rolled function, or a sloution I have missed?
  4. JeffTullin

    How to improve performance?

    >> i m displaying one record at a time, ... and can easily navigate through it, like grs.movenext, grs.moveprevious etc... Where as if i select one record only ..i will have to almost rewrite my code... << Almost. Write a class that has MoveNext, MovePrevious etc functionality, then you call...
  5. JeffTullin

    DataReader : No RowCount???

    Pretty straightforward. One painstakingly assembled query across a few tables, grouped and summed. Dont know in advance how many rows I'll get. Want to process the results row by row, with a progressbar. The math on the bar is basic: thisrow/totalrows * 100 But the totalrows thing is where I...
  6. JeffTullin

    Updating a single row to a database

    in general terms, if the controls are not data bound, then your 'insert' button clears the screen. the user types their info. then they either click SAVE or CANCEL Save does an insert into the database, then 'moves' to the saved record, so that subsequent on screen changes affect the record you...
  7. JeffTullin

    DataReader : No RowCount???

    Thanks all. I had those possible workarounds in my back pocket, but was hoping to avoid doing the 'double execute' method because of time overheads. Maybe the dataadaptor is the way to go, I just get wary about having a 'full table object in memory'. What a waste..
  8. JeffTullin

    DataReader : No RowCount???

    There is probably some simple answer to this, but as a newbie I was surprised to find that the SQLdatareader class presents a .HasRows property but does not tell you how many to expect. No .RowCount? As a no-brainer workaround, I imagined I could read through the records and then start again...
  9. JeffTullin

    auto run file error message

    My experience is that you should never attempt to have a VB program as the AUTORUN program on a CD. VB programs rely upon the VB/OLE runtimes, and sometimes the presence of specific OCXs. If the target machine has not had VB or a VB6 app installed, your START.EXE program will not run. Out of...
  10. JeffTullin

    Newbie: Anyone have small recordset-like example?

    Well that's exciting. DataReader is a new one on me. I assume the reader goes out of scope and closes/disposes of itself at the end of the function. "While (reader.Read())" is pretty cool.
  11. JeffTullin

    Newbie: Anyone have small recordset-like example?

    Hiyall.. I'm just getting started with c#, and as a get-me-running project I want to just open a database connection, select a field from an ad-hoc bit of SQL, and iterate through the results. Most examples I have seen are huge - does anyone have a 20 liner example of this sort of thing? I...
  12. JeffTullin

    Integer to Double Comparision

    >>>The result is -3.5527136788005E-15.<<< A very very small number. This is the different between storing things as integers and string them as doubles. -0.0000000000000035527136788005 is pretty close to zero, and that is how you should compare doubles. eg if abs(dblInches - intInches) <...
  13. JeffTullin

    Conversion between date formats for textual representation of dates

    I recently did some work in T-SQL It has a CONVERT function that allows you to pass string-y dates and convert them to real dates, and vice versa. The reason I mention this is that it allows you to specify what the format of the string you supply actually is. The beauty of this is that the...
  14. JeffTullin

    VB6 program hangs until action is taken

    Check that you dont have any explicit SetFocus commands in there. I have seen this kind of behaviour when validation code keeps playing 'focus tennis' between input controls.
  15. JeffTullin

    Access 2003- vba runtime error 429 activex componentcant create object

    You aren't using error trapping correctly. On the Set.... line, an error is raised because there is no Excel running. However, you are not 'handling' the error, which is why Access stops dead. Instead, you need an 'on error' construct, like this: On Error GoTo errtrap Set...
  16. JeffTullin

    Passing criteria from search form to results form

    A likely cause is that the instance of the class in the second situation is a completely new object. eg in Form1: dim x as new class1 x.property = 24 in Form2: dim x as new class1 msgbox x.property gets you 0, because it is a different object. Try making your object global, or a public...
  17. JeffTullin

    Is there a way to get the number of elements after using Split?

    Wont you just be using a for...next loop to handle this stuff? MyString = Split(Tmp$, ",") y = Ubound(MyString) + 1 for x = 0 to y 'do the first five fields if present if x <= 5 strValue(i, x) = Trim(MyString(x)) end if select case x case 12 'handle MEAS-VALUE case 14...
  18. JeffTullin

    Week Number

    I see this has moved away from 'week number' now, to 'what is actually required'. But in case anyone starts looking here to find a 'week number' solution, I'll contribute this now 'off topic' reply: (Assuming we ignore questions like: Does the year start on 1 Jan or the first Monday/Sunday of...
  19. JeffTullin

    file help plz

    No problem. Put the 30 file names into an array like so: Dim szFiles(30) as string szFiles(1) = "C:\bar1.txt" szFiles(2) = "C:\fred3.txt" ...etc Wrap the code you are using in a for...next loop Dim iLoop as integer For iLoop = 1 to 30 ...existing code Next Change the lines that...
  20. JeffTullin

    file help plz

    When it leaves the loop, what is the value of EOF(1)? It should stay in the loop until it reaches the last row. What is the value of the second header? have you in fact reached the end of the file and gotten a blank row? That would 'seem' to be a header by virtue of not beginning with a '1'...

Part and Inventory Search

Back
Top