Search results for query: *

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

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

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

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?

Hi, I have a file which is the output from a directory. i need to select the file name from the second line in the file. I know how to get it if it is on the first ie first_file=`head -1 $listfile` but not the second. Help Gratefully Appreciated

Hi, I am trying to query an oracle database using ODBC. I am passing an input variable from an input box to the sql and it fails when I reaches the refresh background query line. Any Ideas? The code I am using is Dim Message, Title, Default, MyValue Message = "Enter the Table to...

Hi, I have a table that contains current week info and that works just fine. We are going to amend the table so that each row contains summary data from the previous 12 weeks. This is fine when I am doing an insert where the previous 12 weeks are in the same year. What do I do if some or...

Hi, I have a table that contains current week info and that works just fine. We are going to amend the table so that each row contains summary data from the previous 12 weeks. This is fine when I am doing an insert where the previous 12 weeks are in the same year. What do I do if some or...

Hi, I need to show the current directories in the remote dir. I have tried the dir and ls commands and can't seem to get them to work. Does anyone have any ideas? Help gratefully appreciated James

Hi, I have tried to run a report using a URL but to no avail. I get prompted for the database username and password and then the report works. Is there any way to skip to database userid and password? I am using the follwoing url...

I have an sql that i am trying to improve the performance of. I am running sqlplus and have set autotrace on to show me the explain plan and statistics. In the statistics i get the following (worrying) error message: Statistics ----------------------------------------------------------...

Hi, We require to be able to print our reports from the viewer, and not the browser. The DHTML viewer that can be used is great for viewing the report but is not so good at printing as you can only use the browser print function, which doesn't give you any options. So we have started using...

I have created a combobox and want to fill it with data from more than one range. I know how to select data from one rane ie [sheet!$A$1:$A$2], but how would i add another range? Any help would be appreciated!!!