Recent content by BlackDice

how about this: listBox1->Items->Add(row[i].ToString()); BlackDice www.stillwaterexpress.com

are you meaning you want the progress bar to step backwards? If so, just subtract an amount from your max value and put that amount in SetPos(). For example: if your max was 100 and you were stepping by 10's (with 10 iterations) int x = 0; while(whatever = that) { x++...

every time you insert an item, it's inserting it in the '0' row, so that's what it's returning. The way you're doing it, if you insert 1,2,3,4,5 your list will look like this: 5 4 3 2 1 BlackDice www.stillwaterexpress.com

there must be something else going on. I just copied and pasted that code and ran it in a button's click event and it created the combo just fine. BlackDice www.stillwaterexpress.com

I think you need to be a little clearer in what you're trying to do. BlackDice www.stillwaterexpress.com

what about Invalidate() or RedrawWindow() BlackDice www.stillwaterexpress.com

Make an overloaded constructor for the external class then when creating a new instance of it (from the dialog class), send in 'this' to the external class's constructor. Make sure the argument is of type 'CYourDialogClassNameHere'. Include the header file for the dialog. now you should be...

yeah, the person who wrote the sproc put values into most of the variables by using SELECT's. I'm changing that now by using SET's . Also a lot of the smaller sprocs ended with SELECT statements so that they would return a cursor. I'm modifying that so that a result set won't be returned if...

WAY in the hundreds. This sproc creates a cursor, that in turn calls 4 or five other sprocs and the cursor may have about 100-200 iterations. But I think result sets are being returned for all the sprocs it calls also which are simple select statements that are only returning 1 or 2 rows. I'm...

1. vfp9 2. didn't think about that. It does return a lot of result sets in the Query Analyzer window 3. No 4. Not Yet 5. No BlackDice www.stillwaterexpress.com

I'm using sqlexec in a number of places, but when I use it on a certain stored procedure, VFP just crashes. no messages, no nothing; just completely disappears. Anyone know what this is? I'm using a sql server backend. I call other stored procedures in the same app, and not a problem. I...

Yeah, I thought about that, but most of the time we're on the server anyway when we're updating a client's db. Plus, I could actually run it on my machine and connect to the remote server using an ip address instead of servername. BlackDice www.stillwaterexpress.com

thanks for all the advice guys, but I think I still like the shellexecute() method better. I've written a nice little .exe that takes care of it and it's all done in about 10 seconds (for 143 scripts, I think that's pretty good). I did think about parsing the 'GO' out of the scripts, but I...

Yeah, I thought about that. But I've found 2 ways that I think are better. 1. using the extended stored procedure 'xp_cmdshell' and using that like to shellexecute() to call the osql.exe utility and sending it the correct params. (using SQL server's query analyzer) 2.Calling shellexecute()...

I tried removing 'GO' from everywhere in the script, now I get an error saying 'CREATE PROCEDURE must be the first statement in a query batch.' In the script, there's a 'GO' before the call to CREATE PROCEDURE, so it sees it as if it's the first statement in the batch, which is as I feared...