Recent content by JeffTullin

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)

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?

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?

>> 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...

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...

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...

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..

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...

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...

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.

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...

>>>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) <...

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...

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.

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...