Recent content by LlomaxX

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