• How to add and / or delete files to modify a program’s installation?

    Hello all, this is my first post and to be honest, it doesn't really seem like this is the ideal forum to ask such a question, however I can't find a more relevent forum. Therefore if this is deemed inappropriate for this forum please accept my apologies in advance. Can anyone help me on how to: 1)...

    Dougg70215 pointsBadges:
  • MySQL brain teaser

    This has been driving me crazy. I’m trying to come up with an UPDATE query in MySQL that will remove the second blank space in a name and close the gap.   Example: O Brien, John E should become OBrien, John E   A simple REPLACE (name, ‘ ‘,’’) where SUBSTRING (name,2,1) like “ “...

    Michael Morisy8,323 pointsBadges:
  • help me create trigger update column

    CREATE  TRIGGER Trigger_UPDATE_BIENLAI_TIENNOP ON BIENLAI FOR UPDATE,INSERT,DELETE AS IF (@@ROWCOUNT = 0) BEGIN PRINT ' TABLE is null' RETURN END IF UPDATE(TIENNOP) BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP FROM BIENLAI BL1,DELETED BL2,INSERTED BL3  WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP...

    2110805 pointsBadges:
  • DATABASES TECHNIQUES

    A COMPARISON OF DATA WAREHOUSE SCHEMA DESIGN VERSUS CONVENTIONAL RELATIONAL DATABASE DESIGN. (2000 NEEDED)

    DATABASESTECHNIQUES5 pointsBadges:
  • Adding Leading Zeros to a string

    I have a field with a mixture of 9 and 8 character strings... I need to make them all 9 characters in length..so how do I add a leading zero to those records with only 8 characters while leaving those records with 9 characters alone?

    Yahudee5 pointsBadges:
  • How to get mutiple client lines to appear on a single line

    I have a table in Access with mutiple rows of client information that I would like to see on a single line. Ex: Henry Ford in Q1 had 17 orders in Q2 he had 22 in Q3 had 11 orders in Q4 he had 35. Right now there are separate lines for Q1, Q2, Q3, Q4. A single line with Q1, Q2, Q3, Q4 headers is...

    Lsaucier5 pointsBadges:
  • Powerbuilder .net

    when it going to release, i would like to know the cost.

    BINOY19735 pointsBadges:
  • Oracle 10g Database Housekeeping

    i've been asked to work on database housekeeping, i don't know what i should do? please advice

    DB10g15 pointsBadges:
  • List all file members from a multi member AS400 File

    I need to be able to retrieve a list of the members of a multi member file  so that I can process the members that meet certain criteria.  I need to be able to do this from a PC application. If there is anyone with any ideas I would be grateful.   Thanks

    AndrewPage5 pointsBadges:
  • AP MAC filter as ACL from database

    We have 14 CISCO AIR AP 1242 APs around campus. We would like to do : Have a ACL with MAC address allow from our database or XLS sheet and deny others. I already create all the wireless devices MAC address in xls sheet in place. We are trying to do is: Setup ACL for every APs not locally but...

    CHENS265 pointsBadges:
  • Using a .csv to create an ODBC connection.

    I am using an ODBC drive to read a .cvs.dsn file and establish to folders where other .csv files are located and converted into .phb file. The software is WFHC Halifax version 1.2. . CSV file.  [ODBC]DRIVER=Microsoft Text Driver (*.txt; *.csv)UID=admin...

    Jefallon5 pointsBadges:
  • How to eliminate double-entry in Access

    I'm using Access as a scheduler to schedule clients for my business. Each client has a unique and customized schedule. How can I eliminate extra work for myself everytime I schedule/cancel a client. Is there an easier way to do this? Also, clients sign up online and then I enter into Access. Is...

    Sonsie5 pointsBadges:
  • How to clustering Lotus Domino 6.5?

    How to clustering Lotus Domino 6.5?

    Raise20105 pointsBadges:
  • Prompting login information when accessing system files

    If I want to share a file XP to XP, I type the IP address of the other XP system and am then asked for the username and password to access the system files. If I try to access the files again, it will not ask for the username and password. How do I configure this so that I am prompted for the...

    WindowsServerATE335 pointsBadges:
  • sending e-mail attachememt from mianframe – CSV format

    Hi, Can you plesae let me know hos to do a semicolon seperator while doing this?

    Uddaraju195 pointsBadges:
  • using if in access 2007

    i have 2 schedule on we call it patient and it have in side it gender (male or female), and the author schedule we call it patient problem and it have (pregnant,not pregnant,not female), i wont wen we chose male automatically in author schedule chose not female. thanks for you help

    Samref15 pointsBadges:
  • Access Calculations

    Recently made database table in acces. Then made a form from the fields in this table. Data entered into from appears in database table. Added calculations to form, calculated results appear in access form but not in related fields in access database table.

    Greenenergy5 pointsBadges:
  • embedding sql to rpgle

    couldd someone pls help me wid generating week number of a year in rpgle. i guess its done thru embedding sql into rpgle pls help

    Atti123135 pointsBadges:
  • Create a querry to select certain records from a Acess Table

    I am creating an Access database that contains a lists of tasks. MY QUESTION IS is there a way to create a query to pull a subset of those tasks to be included in a job? As new jobs are created, I need a way to include a new subset of tasks in a report without have to input all of the tasks...

    Stevek4910 pointsBadges:
  • find min/max date in access which also return their value for each record

    I have a table with more date per record (ID1 thru ID10) and the each date have a score, I want to select from each record of their min date and max date with their score (the score is not the min/max score), the data set is: ID    Date              Score 1     12/03/2003    ...

    Find5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following