• iSeries Update Values in a Table Based on Values in Two Tables.

    I want to update a Client Category Code in the Client_Table where the Client has a specific Country Code AND and the Clients VAT No is Blank, Which is in The Client_Account Table in another Library. The Matched Records are [LIBRARY1]FILE1.CLLDRS and [LIBRARY2]FILE2.ADLDRS So Update...

    Sconna2325 pointsBadges:
  • Javascript code

    Hi, I'm looking for an IF function code,,, My condition is IF I TYPE THE WORD "MOD" in a CHAT BOX THEN I want this MOD WORD TO APPEAR IN GREEN COLOR. I would like to know the code which I can embed for this to happen? thanks!

    SaraKhan5 pointsBadges:
  • Change the size of a column and then reorganize the rows in SQL tables

    I think this one will be tricky. What I have is a table like: CREATE TABLE PHOTO_DETAIL   (     "PHOTO"        VARCHAR2(25 BYTE) NOT NULL ENABLE,     "NUM_LINE"   NUMBER(20,0) NOT NULL ENABLE,     "PHOTO_LINE"  VARCHAR2(180 BYTE)   )   what I am going to have is: CREATE TABLE...

    Hispi25 pointsBadges:
  • Create a view in DB2/400

    I need an example to create a view in DB2/400. I Need to create a view where the table name is greather than 8 characters and collumns names greather than 6 characters. please somebody can help me??

    ITKE351,965 pointsBadges:
  • Can’t change Navigation Button Caption for subform

    I'm following the instructions in the New Perspectives Comprehensive Access 2007 and can't seem to get the Navigation Button caption to appear in the window when I use the Form selector and select the subform. Any ideas?

    Bets5 pointsBadges:
  • Database Update database

    I will whole database all tables, procedures, triggers, functions defination in one file. i want to use that file to upgrade another database. is it possible ?

    Shrirama25 pointsBadges:
  • Error message stating that the value is too long for the field.

    I entered the last name of one of my students and received an error message. What is my next step(s)?

    C131315 pointsBadges:
  • How to create CL file from Java class

    i m creating a .sh file on the fly from my java code to perform db2 export operation in the code given below. Can I do the same in as/400 to create a cl file on the fly . path = new File(batchfilepath+".sh"); path.delete(); path.createNewFile(); String exitString = "No"; PrintWriter print = new...

    Hn25 pointsBadges:
  • Value too Long in Microsoft Access

    this is a hypethetical question.. Using MS Access you enter the last name of a student, and you recieve an error message stating that the value is too long for the field. What are your next steps?

    Jeffhill5 pointsBadges:
  • Access form to link to Google Maps

    I have like a form to put all the custome address I want like a bouttom to click then it opens a google maps with the customer address from the place I set prevoiusly for example A: My address (1901 Northwest Expressway Oklahoma City, OK 73118) B: customer Address which is from the Data base

    Agma1020 pointsBadges:
  • How do I create a database using C language?

    how to create database using c language

    Subject5 pointsBadges:
  • Moving Cursor Within That particular field?

    Ok Sir, Forget All that thing i will ask in simple way this same question? Dsplay File Field:    Roll No:-ooooooo mark= -BBBBBBBB-   1)So In that Case When We call Prog At first Roll No field Contains Roll No And marks field will be blank. 2) When Cursor Will Come at Mark field then at that...

    Sms121185 pointsBadges:
  • Moving Cursor Within That particular field?

    Thank you Sir its Working properly, But One more Question i want to ask u Display File Contains field Name=BBBBBBB Roll no=oooooo Marks=......... When I will Enter Name Cursor Will Go to Marks Field But Only Mark is Updated Field So Once I entered Name Cursor will go to Marks And After That It...

    Sms121185 pointsBadges:
  • How To get The Cursor position on particular field?

    My display File Contains three Fields as like name= ........  Roll =........  Marks=.......  But In that Case when Program Call, First Cursor Pos On name When Name Will Enter Roll No will Automaticalyy Disply. But I have To Modify Marks Field,,, So When I will Enter Name After That I want To...

    Sms121185 pointsBadges:
  • Access Tab Control Problem

    I had a form that was working fine. I was able to open a form by clicking on the ID in the subform using code "[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]" and it would open the form I wanted.  I have however changed the form to put my subforms into tabs. Now...

    Chazzster5 pointsBadges:
  • Alternative for LEFT OUTER JOIN

    HI all, select code.batchno, detailA.batchfee , detailB.batchfee from Code code left outer join Detail detailA on (detailA.id= code.id) left outer join Detail detailB (detailB.id= code.id) where code.category = categoryA order by code.id I want an alternative for left outer join.. I cannot use left...

    4knowledgexchng20 pointsBadges:
  • Changing Access form properties within your program.

    I have a form where I want to lock a control according to the selection made in a combo box. How do I go about doing this? Thanks.

    AOMCprog5 pointsBadges:
  • Hide print page that is blank in Access 2003

    I have a report that from a query displays multiple fields. In some cases a second page hold additional data. How do I suppress the second page when the main data section is blank?

    Richpax5 pointsBadges:
  • Access VBA Code stops at Midnight

    Why do all my Access VBA scipts stop at Midnight?

    Robert19735 pointsBadges:
  • How to delete a database – MS Access 2007

    I am using MS Access 2007 and I thought that I had managed to delete a database, but every time I open MS Access 2007 the database is still showing in the Recent Database list. Is there a way that I remove all traces of that database and stop it from showing in that list?

    NLC30 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