• Using the SQL IN clause in SQLRPGLE

    Can I use a variable with the IN clause in an iSeries SQLRPGLE program? Can I use: WHERE CUSTID IN(:CUSTNUMS) Instead of: WHERE CUSTID IN(145,1600,352)

    PWMASI5 pointsBadges:
  • Visual Basic

    What would be the code (using regular expression) to match the page , whos title changes during runtime, but we know that it will contain the string "Welcome" in the begining of the title?

    Gaby15 pointsBadges:
  • Query 400 – SSN

    Hi all, I need to strip all but the last 4 digits of employees SSN in a file...I cannot remember what the string is!!! Can someone help? BTW, the current field has NO dashes in the SSN. Thanks in advance!! Rick

    Rmason345 pointsBadges:
  • Update a field in one table after the change on a field in another table using a trigger in SQL

    I have a WODet table and after the field "Complete" is changed to "True" I need to update my SODet table field "UD3" to "True" using a trigger in SQL where dbo.SalesOrderDetails.SalesOrderDetailID = dbo.WorkOrderDetails.SalesOrderDetailID Thank you in advance

    Tanjaatbrenlo40 pointsBadges:
  • PL/SQL: How to check that parameter is case-sensitive?

    Hi Experts how can i check the email id shud take only lower case in PL/SQL block i tried using vpos := REGEXP_LIKE(p_email_address,'[:lower:]','C'); as well vpos ;= REGEXP_LIKE(p_email_address,'[^[:lower:]]','C') But both says wrong type as error and p_email_address is a parameter of procedure and...

    Inprise610 pointsBadges:
  • Using WildCards in IIF Statement

    Hi, I have a query that uses a field on a form to filter what information gets displayed. This is simple I know but what I need it to do is display all records if I don't enter anything in the field on the form. I tried putting the following IIF statement in the Criteria:...

    RoadDust390 pointsBadges:
  • Specific content migration in Microsoft Office SharePoint Server

    I m trying to migrate specific contents such as "ImageList" picture library from one site to another, but i m unable to do so. can anybody help me?. i have tried content deployment option but it migrate all contents.

    Praj095 pointsBadges:
  • ALTER INDEX statement

    'ALTER INDEX ' || C_Indices.INDEX_NAME ||' REBUILD '; 'ALTER INDEX ' || C_Indices.INDEX_NAME || ' REBUILD ONLINE COMPUTE STATISTICS'; In my stored procedure , i am reconstructing or you can say re-building the tables and table name is the input parameter to the procedure. In middle of the code , i...

    Shaksing5 pointsBadges:
  • PL/SQL: How to handle OUT Parameter during INSERT

    HI Experts, I have a OUT parameter in my procedure(whihc performs INSERT data into a table),how to handle this OUT parameter (primary key of table) -- Will Insert statement inside the PL/SQL block should include this parameter or we should use SELECT stm after Insert to add this attribute ,i am...

    Inprise610 pointsBadges:
  • Creating form with combo box to enter data

    I trying to create a form in an inventory database that uses a combo box to select size and depending on the size, use a text box with the quantity and have it populate the correct size field. If I am way off base, please suggest alternative.

    Cecee5 pointsBadges:
  • Create Alias In Rexx

    I am trying to execute the sql create alias in a rexx source however it fails with sql error 901, have tried command manually & works fine

    Markpg155 pointsBadges:
  • Microsoft Access database too large – Can I divide my Access file?

    Im new to access and have been given a task to compile a data base, which i have very nearly completed, Im in the military and using a PC networked into a military system. However i found out whilst compiling the Database the system has many limitations, the Document has got to 1.99 GB now and will...

    Ukmale5 pointsBadges:
  • photoshop in cpp

    what is the code to impiement photoshop software in c++ language?

    13195 pointsBadges:
  • The rundll.exe file is missing

    rundll.exe file missing errors prompts while login into windows, if i repair windows also it is no accepting the specific file from it

    Sbc12325 pointsBadges:
  • Executing DTSX from VB.NET 2003

    We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we...

    BClawson10 pointsBadges:
  • How do I find the file path to write my file to?

    Here is my code and then my question. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim objfile As New System.IO.StreamWriter("C:\Documents and Settings\JOHNDOE\My Documents\THETARGETFOLDER\MYFILE.TXT") objfile.WriteLine("just a test")...

    TryingHard125 pointsBadges:
  • Loading signature into a PictureBox control

    I'm trying to load a signature into a pictureBox but its giving the "Parameter not valid" error message when it tries to convert into bitmap from the MemoryStream store. Refer code below. code: public Bitmap getSignature() { MemoryStream ms1 = new MemoryStream(Signature); Bitmap signature = new...

    Twlp123165 pointsBadges:
  • Writing vertical data to a flat (unfortunately!) table

    I have an application that I need to update (written by someone else) that requires that I take data from a nice, vertical table and write them into a pre-exisiting flat table. Column 1 of the vertical table is the PK for the flat table, while there are up to 35 entries that must be written into...

    Kingle15 pointsBadges:
  • Inserting rows and multiple rows in SQL Server 2005 Express

    Anyone there who can help me solve my problem? I can’t continue my program because of this problem which I know someone can solve or can suggest the best possible solution. I have a project in my study doing simple accounting program. To facilitate the discussion, I will just show you the three...

    Ariell5 pointsBadges:
  • Porting an application from Linux to Windows via C++ — books or manuals?

    I want to port an application that is compiled and executed on Linux, to Windows via c++. There are no Linux specific OS system calls, but yes there are lots of header files. Is there a paper or book, that I can refer to for more instructions?

    Linux - Ask the Expert270 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.

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

Following