Search results for query: *

I have a simple function used to export records from a table into a XML format. I can't seem to get the root node schema to print out....what I need is the "root xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" etc... Am I missing something...

I am very new to the XML classes and i'm having difficulty adding sections to the existing code I have below. This fuction parses a text file into a simple XML file. Say I wanted to add another CollectionName element to this file before the existing one, how can I do that? Also, if I wanted...

I have a simple text file (colon separated format) that looks like the following: User Class:User Name:OSSignon CAM:Jainarain, Mark:jainam2 CAM:Hui, Victor:HUIV2 CAM:Nayak, Anil:nayaka2 CAM:Lee, Shane:lees5 CAM:Hawara, Ed:haware I want to take this file and convert it to an XML format. Is...

We have just upgraded to 10g. I have a query that has been working fine until the upgrade, and I have narrowed down the problem to the combination of "AND" and "OR" in my WHERE clause. The problem is that one column (rate_mult) is returning the wrong rate multiple for all records and therefore...

I have a command to stop a service on a remote machine. I'm using netsvc below within a batch file. netsvc "SERVICE NAME " \\tdsi-srv1 /stop I get the following message "Service is pending stop on \\tdsi-srv1". Is there a way to stop this service immediately and not have it pending to stop...

I have a text file that is read using the code below. What I need to do is populate one field from a line depending on the value in strValue then loop to the next line and populate the remaining fields in the table. Do While f.AtEndOfStream <> True strBuffer = f.readline...

Hi, I have a table with one field named RequestID. It is a text field. I would like a query to display only records in the table that are numeric values. I used the function IsNumeric(RequestID) as below: SELECT PPES.Date, Last(PPES.Time) AS LastOfTime, PPES.RequestID, PPES.UserName FROM...

Hi, I'm using the code below to kill a process on my local machine by passing it the PID. I would like to terminate a process on another machine using the computer name. Is there a way to specify computer name somewhere? (I do have administrative rights on the other machine) Thanks in...

I have the following code that is used to kill a process knowing the PID on my local machine. Would it be hard to change this code to kill processes on another machine, presuming they have administrative rights of course. Option Compare Database Option Explicit Private Declare Function...

Does anyone have a function to terminate a windows process if I pass it the PID #? I believe I can use the TerminateProcess function but I'm not exactly sure how to use it. Thanks in advance! TN

I'm trying to determine if the ppdsweb.exe process ID (PID) is stored within the ppes_audit log file. I have detail auditing enabled. Sometimes I notice several ppdsweb.exe processes on the server even though there are no user accessing any cubes. I'm trying to determine which users' process...

Does anyone have a function to terminate a windows process if I pass it the PID #? Thanks in advance!

Hi All, I have a program within Access that populates a table with the PID session number and program name for a specific process on the server. Is is possible to kill a process using code? For example I would like a simple form that would have a pop up or text box to enter the PID number and...

Here's code I have to import one line of text into an access table: strBuffer = f.readline strValue = Mid(strBuffer, 1, 6) Select Case strValue Case Is = "Source" rs.AddNew rs!Field1 = Mid(strBuffer, 10, 30) Datasource = rs!Field1...

Hi there, I'm very new to VBA. Here's sample from a text file that I'd like to import into an Access table I've created. I'm using a form with a text box with the path (txtFileName) and an import button (cmdImport). ----------------------- DataSource 429 "Map_company" Separator "," SourceType...

Hi there, Does anyone have a program (in MS Access preferably) that reads an .mdl file and spits out all the pertinent information within the model? Example, it would read the model and spit out the name of the data sources used, location of the data sources, dimensions and levels, measures...

I'm trying to get a list of users and their "last" or most recent login time which is stored in the field start_date_time from table ppes_request. Here's my query: select distinct(user_name) from ppes_session, ppes_request where ppes_request.session_id = ppes_session.session_id This shows a...

I have a scheduled package that is supposed to delete all data in 8 tables as below. DELETE FROM PPES_DIM_USAGE DELETE FROM PPES_DISPATCHER DELETE FROM PPES_LEVEL_USAGE DELETE FROM PPES_MEASURE_USAGE DELETE FROM PPES_REQUEST DELETE FROM PPES_SESSION DELETE FROM PPES_USER_SOURCE DELETE FROM...

Hi, I'm just trying to get an idea of how to best setup and use User Classes...ie. best practices. Is it a good idea to setup user classes based on department? The reason I ask this is because certain "power users" or managers will have broader access than others. One example I have is based...

I have a time dimension with Year-Period-Week as levels. I have 2 data sources, one for BUDGET data the other with FORECAST data. The forecast data is down to the week level but the budget data is only up to the Period level. I want to allocate the budget number to divide each value by 4 to get...