kejpa

Hi, have you tried to change the * to a % In my experience it has made a difference in some cases. % is the standardSQL wildcard token, M$ took what you use in DOS and used it within Access to "help" people. * is standardSQL token for "all fields" as in select * from Names HTH /Kejpa

Hi, From my point of view the only time it will be problem is if you insert/update the database using string concatenations. If you use parameters inserts/updates will be so much easier. IMHO /Kejpa

Maybe MySQL for VB will help you get started. HTH /Kejpa

Hi! Use the sleep function of the Thread object, Threading.Thread.Sleep, I think, I don't have VS up right now... HTH /Kejpa

As I told my old students who thought they were "A" students... "Merely asking why you didn't get an A is reason enough for not giving you one" ;)

Hey! Subselects are beautiful in their compexity, but most of the time not necessarry. This is AFAIK one of these times... # Psuedo code SELECT items.path FROM items, tags WHERE items.tags LIKE "%" + tags.id + "%" and tags.name='one' I might be wrong, it's easier if we get to see the actual code... HTH /Kejpa

Sorry, I was too quick in my assumptions :o The reason is in your code... Dc = New OleDbCommand("Select * from Groups where GroupName<>null order by name asc") when dealing with null you need to use is and is not like this Dc = New OleDbCommand("Select * from Groups where GroupName [i][u]is not[/u][/i] null order by name asc") HTH /Kejpa

Sounds like you're run into a common problem, the name of the table is a reserved word... Change the name of the table and try again. HTH /Kejpa

Isn't J++ and C++ enough?!??! ;) But you've got the short hand i += 10 that increments i with 10 /Kejpa

'tis the time of the year when you're eagerly looking forward to getting them from your bunny, but are there any known in .NET? /Kejpa

Command/Response -revisited... Hi, I was sooo happy yesterday when I got it tweaked into my existing CommPort class. But today I realize that I need the response in the statements following the call :( 'UI try sResponse=myCommPort.CmdResponse(sCommand) select case sResponse case "<" DoThis case "!" DoThat case "?" DoSomethingElse end select catch ex as TimeOutException console.writeline(ex.message) end try Asynchonous handling comes to mind, but I can't find any good samples. The UI calls once a second and the calls should pile up but if no respose has come within 1.5 sec it should timeout and process next message not that has not timed out. The message queue was pretty but I couldn't get the response back to the calling method :( TIA /Kejpa

Hi mskeel! I've got it working now, thanks to you. With some tweaking I got it into my existing Comm-wrapper too so now I'm really pleased. /Kejpa :D

Hi! The problem is that I probably will have a couple of different classes all with a couple of instances that will use the call. With event handlers I'd have the response in half a dozen places it shouldn't be. Is passing a delegate a way to ensure that only the calling object will receive the response? Many thanx! /Kejpa

Hi, I'm using a derived Serialports class for handling all talking/listening on a Serialport. This class is referenced from a number of other classes. What I basically want is that it handles each call separately, send a command, wait for a respose the given time and return the response or a timeout exception. If another object is trying to talk during this time it's put on hold, and if the second objects Write timeout time is reached while on hold it will get a TimeOutException too. One thing that complicates it is that the application have to move on as if no waiting is done. Another thing is I want it simple... try sResponse=myCommPort.CommandResponse(sCommand) catch ex as TimeOutException Debug.Print"Timed out" catch ex as Exception Stop end try Any help appreciated /Kejpa