Search results for query: *

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

MikeLewis, should ALL instances of the word 'GO' be removed? they're necessary in the script BlackDice www.stillwaterexpress.com

the problem comes through as "incorrect syntax near 'GO'". I open the file up in SQL Query Analyzer and it runs fine. This script actually creates a stored procedure on the server. I generated an sql script from the stored procedure so that it can be created on the server for my database...

I have a vfp app with a SQL Server backend. When updating a client's database, there's a lot of stored procedures to be added to the database. Instead of going through and doing them by hand, I'd like to know if there's a way to do this from vfp9. This is what I've done so far: Procedure...

I wondered about that, rgbean. thanks!! BlackDice www.stillwaterexpress.com

I found some more stuff on the site yesterday after posting my thread. I tried making the .msk files, but they didn't seem to work. Then I used the originals and turned all the gray stuff white (since I read VFP uses white as the transparent color by default). That didn't seem to work at...