• tell me why I’m getting the message “The multi-part identifier “134062-DB1.netFORUMSTaging.dbo.Individual.individualKey” could not be bound”

    I'm trying to process this SQL statement select cxa_cst_key, cxa_key, cxa_key from [134062-DB1].netFORUMSTaging.dbo.Individual LEFT JOIN dbo.co_customer_x_address ON [134062-DB1].netFORUMSTaging.dbo.Individual.individualKey = co_customer_x_address.cxa_cst_key where delete_flag = 0 and source not in...

    Calvin606165 pointsBadges:
  • Crystal Reports XI – Showing records when setting criteria

    Goal: To show all customer orders. Along with those orders, I want to show all related notes on the progress for filling those orders. Problem: Some orders have no notes. When I set the criteria to show all orders and to show the notes, only orders with notes now appear in the report. Question: Is...

    Hritguy5 pointsBadges:
  • New Web Service Project

    Hi, Currently an iSeries job runs every 10 minutes where, at the back end, a file is read (more than 400 fields), a pipe delimited file is created and FTP'd to an outside location. Volume would normally be low but intermittently there could be a spike. I need to replace the FTP process with a...

    AL04285 pointsBadges:
  • Finding the average of a data type on a SQL Server

    I am trying to figure how to find the average of the data type datetime on my SQL Server. This is my code: SELECT CONVERT(varchar, Tanggal_Produksi, 3) AS Tanggal_Produksi, Target, Actual, Balance, CONVERT(varchar, Waktu_Proses_Awal, 8) AS Waktu_Proses_Awal, CONVERT(varchar, Waktu_Proses_Akhir, 8)...

    SQL Server Ask the Experts2,585 pointsBadges:
  • double quotes with InStr method

    how to identify a string with double quotes using the InStr method in vb

    Jwohlbe5 pointsBadges:
  • Event fires for all collection members when one member triggers?

    I have a usercontrol that contains a collection as a list(of <custom class>). Within the collection class for this usercontrol I have a shared event that is raised when a collection member is added to the class. Within the usercontrol class I have an event that is triggered when the...

    Zybron5 pointsBadges:
  • Disable Form Controls in VB 2008 until selected

    Beginning prog. student here... I have a form with multiple controls, and i want everything to be disabled except the datetimepicker. Once a date is selected, it should make the whole form usable. I've searched the web, and can't find the right solutin. I found this sight, and hoping someone can...

    Jacobass5 pointsBadges:
  • Summer course for SAP or .NET?

    I m a 2nd yr MCA strudent from BBSR and want to do some summer course. i am looking for a good inistitution for any summer course. and this year i am planing for either .NET or SAP which will be adviseble for me? now i m learning JAVA. this year i m supposed to sit for campus, but unfourtunately no...

    Sinuthecoldfire20 pointsBadges:
  • How to convert VBA decimal DataTypes

    I need to figure out how (if possible) to remove decimals from numerical data, and add zeroes to the front/back end of data so that I can concatenate several cells into a single strain. Ex: Actual value = 14.37, needs to be converted to 14370 Actual Value = 4.3, needs to be converted to 04300...

    McNitro255 pointsBadges:
  • Excel 2002 Copy GetPivotDATA function

    I have a number of different items that I need to extract from a pivot table. Can I copy the GETPIVOTDATA function? it seems to get stuck and return only the value from the first cell

    Steve74745 pointsBadges:
  • Generate PRN file on AS/400

    I want to know, if there is any way to generated PRN file on AS/400 from a spool file, using Host Print Transform. I am thinking of storing rendered print jobs(PRN files) on IFS and print them later.

    Tenwang35 pointsBadges:
  • XML parsing in COBOL on iseries

    Can I get an example of how to parse XML document in ILE COBOL? I need both SAX and DOM parser examples.

    Sivan5 pointsBadges:
  • How do I display a clickable link from database in table using PHP?

    I have a table and when I pull a clients info up I would like the web address to be able to be clicked to view web site. How would I code this in? Here is some of my code. $num_rows = mysql_num_rows($query); print "<b>Here is my Information on you. <br><br>E-Mail me with any...

    BigAL095 pointsBadges:
  • Lotus Notes error “Cannot convert field – unsupported datatype”

    I created a NSF myjournal.nsf using [Personal Journal] template. In C when I rendered a document created by "JournalEntry" Form using its own Form (and also with default Form) with function [CompoundTextAddRenderedNote(params...)], I got the error code 1538->"Cannot convert field - unsupported...

    Sppradip70 pointsBadges:
  • DataGrid in Visual Basic 6

    I am developing an application in VB6 using a bound data grid with a data control, and am struggling with the following: 1. How do I force an update of the data grid to the data control by pressing the Enter Key, regardless of which cell of the data grid is current. 2. When updating the data grid,...

    Anthonyjcs5 pointsBadges:
  • Looping Queries in Oracle using data from SQL Server

    I have a table of entries from SQL server called PID. Each of this entry should follow the following select * from HR.TABLES a START WITH a.SID = '0' CONNECT BY PRIOR a.parentid = a.sid' Where I have '0' in the query above, should take all the values from PID. Is there a easy way to write this? or...

    Sreedhar775 pointsBadges:
  • Microsoft Access Drop Down List

    Hi, I have combo boxes in Microsoft Access where if the user starts typing the drop down list expands. Now if they use the keyboard to select the item, Access moves to the next control and the list is brought back up, but if they use the mouse then the list stays down. I was wondering if there was...

    RoadDust390 pointsBadges:
  • Embed date in SQLBase unload filename

    I have a scheduled task to runs a backup script each night using a program called SQL_Talk for Windows version 9.0.1. I am using this program to unload a SQLBase database each night for backup purposes. I have a separate script for each night of the week. Below is the Monday script: set server...

    Flame14,925 pointsBadges:
  • Error message: DLL undefined

    Please help me correct. Error message: DLL is undefined and BN is undefined.

    Srmatten5 pointsBadges:
  • vbscript email message lenght limits?

    Is there a "total message length" limitation for Excel Macro Emails? I'm new to vbscripting and thought I had successfully created code to email Excel data via a macro. I have written the macro to send up to 30 lines of information, but have discovered that the number of lines I can actually send...

    Crbsa5 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