Search results for query: *

And, yes...I could do it through extended stored procs...but from what I can find out, that's not something that someone can just pick up in an hour or two, and safely run on a SQL Server. Thanks again!

That may be an option...although I don't know if it will work. The objects that would be running on the other servers run a variety of processes, and I would only see the process I'm looking for when it was running...I wouldn't be able to tell if the main process was running and just hadn't...

Hi. I am writing a stored procedure that will run through a cleanup algorithm, cleaning up records in the tables and whatnot. We have a network of servers that could be making calls against the SQL database at any time, and we don't want some of these processes to make database calls while the...

Is there any way to use the TMPFILES command from inside my class object? I hand a working folder path to my object to create temporary tables and such. If the TMP files Foxpro is creating were in different locations for each instance of the class object, then maybe they wouldn't be fighting...

That seemed to help quite a bit Before when I tried it, 4 tasks were created simultaneously, and only one would run. The other three would error out, wait 60 seconds, and try again, and still error out. After I made the change, 4 tasks were created simultaneously, and only one errored out...

I should have mentioned in the last post that I tried the similar approach, "and it didn't work" Also, the error messages give me the name of the file it is having the conflict with, and those files don't even exist. I even try waiting a few minutes, letting the first one run for a while...

Well, I tried something similar...Remember I said each object was supposed to operate on different sets of data? I thought maybe it was because my cursors all had the same name, so I changed from "select .... into cursor hold" to "select . . . . into cursor (this.JobNumber + 'hold')" Now...

I like the Pegasus logo. Does that mean I can use my Mobil Speedpass to login?

I have created a Foxpro COM dll that I am calling from a Visual Basic 6.0 COM object. The VB object is created multiple times, each instance running in its own thread, managed by an in-house task manager. Each object is supposed to perform its task on different sets of data. When two or more...

This one has me stumped. I am using Visual Studio 6.0 and I am trying to pass a SQL Select statement thru ADO to the Visual Foxpro Driver. The statement is a simple "select * from MyTable into table NewTable" If I paste the SQL into the Foxpro Command window, it creates the NewTable.dbf, with...

I did a search for CLOBs in this forum and found nothing, which isn't very encouraging, but I'll ask anyway. I am trying to figure out how to send a CLOB to a stored procedure. The Stored procedure is in IBM DB2 on a mainframe, written in COBOL, and we are using DB2Connect as our driver, and...

Hopefully this is a simple question that most of you have run across, and therefore can help me easily or point me to an existing thread with the answer. The company I work for does not give users admin priviledges to their desktops, which also means they do not have the right to modify their...

I guess I shouldn't have used numbers in my example...this is what I want: Table1 = FieldA FieldB FieldC A B C X Y Z and Table2 = FieldA FieldX FieldY FieldZ A L M N A O P Q X R S T X U V W...

Good point...you're exactly right....it won't let you open the second in my approach. That's what I get for offering advise without making sure I'm right first. So, in the words of the late Gilda Radner: "Never mind"

Actually, most VB'ers will create a single form, and then create instances of that form over and over, rather than having the same form as different names in different places. I understand the reason you are probably doing this is to save time....both forms are similar, so let's copy one and...

Probably need more to go on, but a 3134 is an Application or Object defined error. The line of code that generates the error would be great. Are you creating an instance of the Access 2000 application in your code? Let's then state the obvious - Is Access 2000 installed on the server?

The best I can come up with is use vbYesNoCancel instead of vbYesNo. That way, Esc is the same as Cancel, but you'll still have Yes and No on the message. Not a great solution, but I'm afraid that's all you'll get unless you make your own MsgBox function that does what you want. BTW, VB...

This is more of a SQL question than VB, but most of us are well-versed in both, so I thought I would try here first. Our VB app is tied to a mainframe DB2 database, and the data modelers have of course normalized this to within an inch of it's life. What I would like to do is create a single...

Just in case someone finds this, looking for the answer I found....I was attempting to connect to a DB2 database on a mainframe through DB2Connect. I wanted my app to allow users to reset their password when it expired instead of forcing users to go out to the mainframe to do it. I found out...

Here's a little news that suprised the heck out of me. Did you know you can create Enumerations using reserved words in VB6? Neither did I. Imagine my suprise when all of a sudden my tested code stopped working, and I tracked it down to my Date function, which is supposed to return the date...