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

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

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

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

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

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

i want to transfer the type names into cloumn headers with the count info under each one counts Type ----------- -------- 2 upnew 4 csxnew 24 upavg 38 csxavg 76 csxcount 86 upcount upnew csxnew etc. 2 4 23

I want to Format a date to return YYYY-MM-DD with out the hours minutes or seconds. i have looked through all of the help text and cannot find an appropriate way to format a date. HELP!!!!!! dan0

I am creating a formula to return a value based on a bitwise comparrison listed here ({AssetCoordinate.AssetCoordinateFlags} ?????? 65536) >0 the ????? is the 'bitwise and' that i can't find in crystal in T-sql it is "&" This statement is evaluated in an if statement with the...

i am running this query SELECT Asset.Identifier, Asset.Status, Asset.Notes, Count(*) AS NumberO FROM Asset INNER JOIN AssetCoordinate ON Asset.dwKey = AssetCoordinate.AssetKey WHERE (((Int([AssetCoordinate].[AssetCoordinateFlags]/16)-2*Int([AssetCoordinate].[AssetCoordinateFlags]/32))=1) AND...

THE PAGE IS ASP AND USES A CONNECTIONLESS DSN (INCLUDE.FILE) Set rsNew=Cn.Execute (&quot;SELECT MAX(loco_data.ID) AS Max FROM loco_data&quot;) <td width=&quot;50%&quot;><strong><%=rsNew(&quot;Max&quot;)%></strong></td> THE FIELD ON THE PAGE IS BLANK BUT THE OTHER FILEDS WORK FINE