Search results for query: *

Hi, I have an to write an update query, based on dates, which I can't quite figure out. The details are: Table A: AccountID DateFrom DateTo Value Table B: AccountID DateFrom DateTo Value What I need to do is update Table A Value with the Value from Table B where the AccountID's match and the...

Hi, Im using Crystal 10 with a SQL Server 2000 Database. I have a table which contains one or more records for a given record ID field. Each record has address line columns, Address1 - Address4, and 3 boolean fields to indicate what type of address it is, Type1, Type2 or Type3. The address can...

Hi, I am trying to write an update query without much success! I have the following 2 tables: TABLE_A Account_ID Sub_Account_ID Sub_Account_Adj Issue_Flag TABLE_B Account_ID What I need to do is set the Issue_Required_Flag from 0 to 1 in TABLE_A where the Account_ID exists in TABLE_B, but...

Hi there, I was hoping somebody may have some advice on the following: I want a user to be able to run a batch of mail merge labels in MS Word 2000. The labels contain a sequential numeric code which increments by 1 on each label. I can achieve this easily emough using Excel as a data source...

Hi, In SQL server 2000 - I'm attempting to copy data from tables in database A to database B. Database B is an exact copy of database A and is on the same server. However, if I use the DTS Import/Export Wizard, choosing 'Copy objects and data..' and 'Copy data - replace existing data' the copy...

Hi, I have a problem with an insert, basically I've populated a table (say table_a) with records based on one criteria, and have to then insert records into table_a based on another criteria, but only if they don't already exist in table_a. E.g. insert into table_a (account_no, reference_no...

Hi, I have a requirement to produce some address cards using Crystal Reports 10 Professional, using data from a MS SQL Server 2000 database. The cards need to be printed 4 up on A4 in landscape, which I have set up with no problem, however they need to look someting like this (example using 12...

Hi, I have a comma separated file, whose contents look something like: 12,X 35,0 79,2 993,0 995,9 996,8 1007,1 1008,0 1010,6 I need to load an array with the contents of the second field, with the array index being the first field (e.g. so I can look up 12 to find X). I'm not sure how to do...

Hi, It's been a while since I did any RPG400 coding so please bear with me! I have a file which contains an alpha field of length 960 characaters. I need to be able to read this field, then split it into 12 sub-fields of 80 characters & output these to another file. I think I need to use a...

Hi, I have a file containing approx 4500 records & I want to append a character (the same character) at the end of each record. The records can vary in length, and look something like this: 06010230404503 784682874002 074802830467 793526492830 0547349477923B 76203129124B 012632847392...

Hi there, I've read a few posts about calculating an age with the 'datediff()' function, however I have a date of birth field which is an 'int' data type, with the date held in YYYYMMDD format, e.g.: 19450130 Can anybody suggest how I can calculate a persons current age, with data held in...

Hi, We have a backup job in our root crontab which is hashed out, the entry reads: #00 22 * * 1,2,3,4,5 /usr/local/backup However, the job still runs each night at 22:00! Anybody any idea why? Cheers!

Hi, Sorry if this has been covered before, but I have a column in my spreadsheet which is a list of values, e.g. 4999 1500 6500 6800 7020 e.t.c I need to sum the values based on range, e.g. < 5000 5001 - 6000 6001 - 7000 7001 - 8000 e.t.c Using the above examples: < 5000 = 6499 6001 - 7000...

Hi, We are running Solaris 9 on a Sun Sunfire V440 server. Is it possible to set up a 'virtual' printer, which is just a directory on the server, so that when a print job is sent using the lp command it lands in the directory? I'm sure wev'e done this in the past but cannot remeber how we set...

Hi, Apologies if this has been covered before! I need to query some data from a SQL Server 200 database from 3 tables, with data from the 3rd table being selected on a date field. Table structure is something like this: Table_a Property_ID Company Name Table_b Property_ID Property_Address1...

Hi, Sorry if this is a dumb question -I'm new to Notes programming!... Can you program a button in the navigator pane to run an agent when it's clicked? I'd have thought so, but haven'y managed to figure it out yet. Cheers!

Hi, Does anybody know if it's possible to create a simple VBScript to test whether a web page is on-line or not? I want to be able to check automatically through the day & be notified if the page is not working. Cheers!

Hi, I think this may have been asked before, but.... We have Lotus Notes R 6.01 & would like to set up a group calender that has a year planner view (similar to the one found in Lotus Organizer), so that we can see at a glance when members of the team are on holiday e.t.c. Does anybody know...

Hello, We have a Flash movie nav bar on our site, however if we use a SSL link using https the movie won't display. We've set the codebase URL to be https (as recommended by Macromedia) but this hasn't cured the problem. Does anybody have any ideas? Many thanks in advance.

Hi All, I was wondering whether anybody had an opinion on choosing Lotus Notes as a development tool. We have version 6.0 where I work, but just really use it as an email system. We currently use MS Access and SQL server to develop database applications. Are we missing out by not developing...