Search results for query: *

I'm using a macro developed on Excel 2002 but being run on Excel 2000. On the 2002 machine the macro runs find, however, on the 2000 machine I get a "Runtime Error 5: Invalid Argument or Procedure" when I try to access a querytable import from a user specified textfile.

I am running a program on a informix database with multiple servers. depending on when I log on I will get onto one of three servers. is there a way to specify what system resources, (which server and how much of that server), is commited to running this program...Depending on the number of...

Have you tried concatenating the variables, delimiting them with a unique character (|,*), and then passing one variable between the function and main program?

Thanks Ed, I appreciate all the help. I am a web guy and this project has got me working OT.

>I'm not certain we're on the same page as far as what constitutes a "temp table". I'm asking if you've considered using a temp table within the 4GL program instead of an array.... I am loading a textfile into a temp table, that is where the 10,000+ values are located then i am using an SQL...

this is the code I have that doesn't work... create temp table t_data (dat varchar(255)) with no log load from 'input.txt' insert into t_data each rec. has 11 lines in the txt file that should appear in different columns, then a blank line, then another 11 line rec. any help would be...

What is the cost of multiple temp tables? I already have a temp table with the 10,000+ values in it on a system that is used concurrently with about 35 other users.

I have an array in Informix 4GL nbarray[100] that is populated with values. I want to check to see if a selected value is contained in that array...this will be performed for about 10,000 values so I'd like to stay away from a simple loop search through the entire array for each value.

Thanks man, that is exactly what I needed to read-in from the file. Now all I need to do is figure out how to modify each line based on a conditional statement else skip/print what was read in.

I want to read-in a textfile (input) line by line, and if any line matches a value contained in a seperate textfile (reference) that line in the input is changed to the value that occurs 5 lines after it in the input.