Search results for query: *

Hi LB, I have tried what you suggested but the 'Group sort expert' button is greyed out. Any ideas? Thanks

Hi Mike, That's what I thought, but I need the sort to place the lowest value first which is 10, then place all the other values for the same parent in the same group, then the next lowest value (if not selected previously) which is 10.5 grouped by parent etc. I know this is none standard, but...

Hi, Using Crystal 9 developer edition. I have a list of animals, with their parents name and a value that I need to sort on within a group. Data looks like: Animal Parent Value Lamb1 Ewe1 10 Lamb2 Ewe1 11 Lamb3 Ewe2 10.5 Lamb4 Ewe3 12 I would like it...

Hi, We have a situation with an 8173 database and a 9204 database on the same Sun machine. What we need to do is take the data from the 8173 database and load it into the 9204 database. I presume it is as easy as a full export followed by a full impoirt into 9204. Is this the correct way to...

Hi, I am using one oracle view to generate the report. There are no subreports and I am using ODBC..

Hi, I have a crystal report version 8.5 which works fine on my pc. I have inserted it into VB6, following instructions from the Crystal Reports Developers Guide(8.5). I get the error "Server has not yet been opened". I have read a few posts from this forum and realised that you have...

Right, The external ERP package that we have will not accept any null values. The database that it uses has every column declared as NOT NULL. They must have a routine that checks the definition of a column for the NOT NULL clause. What I am tyring to do is make the view fit into the...

Hi, I have a problem creating a view. I have a table, lets call it table A, where all the columns are declared as not null. I want to create a view on this table. In the view I need to do a calculation againist 2 numeric columns (A - B). Remember the columns are defined as not null. The...

Hi, I am having a problem passing a variable to the sed command. For example: $filename=13017105.ack #I then want to count how many lines there are in the file, #but need the output to be a number. #The output looks something like: #19 13017105.ack #command to try and just retrieve...

Hi, Is there any way in VBA to export all the modules automatically? I have several modules that I want to transfer to another workbook. I can only seem to export one module at a time. Any help gratefully appreciated James

Hi DJS2, I have put the code as you suggested into a asp file but it doesn't work. I just get the heading Request Server Variables List on the screen. Do I have to add anything else to the file? Thanks James

The code is as follows: <SCRIPT TYPE=&quot;text/VBScript&quot;> <!-- Dim objNet On Error Resume Next Set objNet = CreateObject(&quot;WScript.NetWork&quot;) Dim strInfo strInfo = &quot;UserName is &quot; & objNet.UserName & vbCRLF & _ &quot;ComputerName is &quot; &...

Right, I have created some code to get username, computername and domain. The only problem is that it comes up with a message box from internet explorer saying that activex controls are unsafe and do i want to continue. Is there any way that I can auto accept this message as i always want...

my current code looks like this <SCRIPT TYPE=&quot;text/VBScript&quot;> <!-- Declare Function GetUserName Lib &quot;advapi32.dll&quot; Alias &quot;GetUserNameA&quot; (ByVal lpBuffer As String, nsize As Long) As Long 'function to retrieve username Public Function getcurrentusername() As String...

Hi, I would like to display the current operating system username in Internet explorer. Is this possible using Vbscript? I have managed this using an API call to advapi32.dll in VBA code but it doesn't seem to work in a web page. Any help appreciated.

This seems to be a package for use with oracle version 7. Here are the comments from sync.sql Copyright (c) 1991 by Oracle Corporation NAME sync.sql - synchronization primitives to help write multi-user tests DESCRIPTION Call these routines to synchronize multiple test...

Hi I am wondering if this is possible. We send e-mails via a third party software, through the smtp gateway of our exchange 2000 server. This works fine except for the fact that there are no records of the emails being sent. Is it possible for a copy of the sent email to be kept in the users...

Frameuser, are there any more links? Thanks

Hi, I need to create a pdf file from a word doc using the command line. I do not have adobe acrobat writer. I ave seen lots of free packages that I could use but they require user interaction(ie print to pdf) Help appreciated James

Hi, Is it possible to run an application, say FTP from within Oracle?