Search results for query: *

It has been a while since i have used jet sql (mostly use pl/sql). I need to replace specific chars in a string but can't find a method available in jet sql. Example "TASK: "IB732B" FROM QUALITY" I want to replace the &QUOT with a space. I can do this in pl/sql but the...

Thanks for the reply, I was hoping that there way but i see now that there is not. Dan0

Is it possible to read a file on a local machine c:\temp.txt and extract a line from the file into a varible? If it is possible what is the method to use? Thanks Dan0

I am looking for a method to return the local system windows version and enter it in to a variable that will be used by a function. Thanks Dan0

I have a textbox which can hold a Road No. Range in the given format [10-15,17,20-25,28] And I have two or three other textboxes in which I need to enter the subset of the range I entered in the Header Road No. Range. The first subset textbox might look like this [10-13], the second might be...

I am trying to move away from using the batch file.

I have a problem. I have looked at all of the articles i can find about FTPing from a VB program, but I am still unclear on how to implement it in the code. The steps I want to accomplish are: connect to a server (username, password) go to a directory put a file in that directory from the...

I have a problem. I have looked at all of the articles i can find about FTPing from a VB program, but I am still unclear on how to implement it in the code. The steps I want to accomplish are: connect to a server (username, password) go to a directory put a file in that directory from the...

All of these post have helped me come up with a solution to my problem. Thank you Dan0

I have to find duplicate records in a table where only two of the fields are the same between records. EX sequence F1 F2 F3 F4 1 05943 Service 2920 Tre 2 05943 Customer 2920 Hye I would want to return only...

THis example : sample cycle idtype sample_date res1 res2 ------- --- ------ ----------- --- 6861 1 M 05/17/1999 D 6080 1 M 11/17/2000 A P 6140 1 C 01/06/2000 D P 6806 1...

What i want to do is Update a field in a table with new information without deleting the old info. i retrive a record set from a query and set variables for each selected field then pass through the RS and inserts those values into another table. i want to update a field in a second table with...

that is exactlty what i needed thanks dan0

don' i need a looping structure to go through the produced recordset? this is the query in its entirety CREATE PROCEDURE SP_Problem_Query_Run AS declare @identifier as varchar(20), @Occurrances as numeric, @Status as int, @Notes as varchar(30), @Type as varchar(10), @DTLMR as datetime...

i am running a large query that produces a recordset. what i want to do is put those records into a table but i don't know the syntax to do it this is what i have so far declare @identifier as varchar(50), @Occurrances as numeric, @Status as int, @Notes as varchar(30), @Type as varchar(10)...

when you validate the user and extract the record from the user table set a variable to the username, id etc.. and then insert that info + the date into you log table INSERT INTO Log_table ( Field_User, Field_date) VALUES ('" & strUser & "', '" & strDate & "')

you select the max id from the table and display it set rsMax = cn.execute "Select Max(id) AS MaxID from Table" response.write rsMax("MaxID") dan0

thanks got it

i tried this and i can't get it to work CREATE PROCEDURE sp_ac6000_metric_load AS @uptotal int SELECT @uptotal = count(diffdays)as counts FROM (SELECT ID, Initial_Date, getdate() AS Today, DateDiff(day,Initial_Date,getdate()) AS diffDays, left(Active,1) as active...

i am new to SPs and i need some basic answers i wrote the below querie which returns a number but i want to store that number in a variable. CREATE PROCEDURE sp_ac6000_metric_load AS SELECT count(diffdays)as counts FROM (SELECT ID, Initial_Date, getdate() AS Today...