• SQL (QMQUERY) date conversion issue

    I inherited a QMQUERY program that my user came to me today indicating that the week number was not correct. This query puts data into a workfile and a second query is called that splits other data into fields. As far as the two relevant fields are concerned, the second program does not modify...

    azohawk1,835 pointsBadges:
  • VB6 with Oracle 10g as database: Using add, edit, delete and search button with following fields: title, author, publisher, year, category

    How can I set up a library system with add, edit delete, search button  with following fields: title, author, publisher, year, category using VB6 and Oracle as database? Thanks

    jeremy275 pointsBadges:
  • Create ER diagram in Oracle SQL Developer

    I'm fairly new to Oracle SQL Developer and I'm trying to create an ER diagram for my database tables. How can I go about this process? Any help would be appreciated.

    ITKE407,395 pointsBadges:
  • SQL average command for column IDs

    For SQL, does anyone happen to know if I can use the SQL avg() function for average by my column IDs? Basically, I have several different IDs and I'm trying to get the average of each through one query. How can I go about this?

    ITKE407,395 pointsBadges:
  • How to SQL update several records in a query

    In SQL Server, I have a table that's labeled this: config_name | config_value. I'm looking to update several records in one query. Here's what I have so far: UPDATE config SET t1.config_value = 'value' , t2.config_value = 'value2' WHERE t1.config_name = 'name1' AND t2.config_name = 'name2'; But...

    ITKE407,395 pointsBadges:
  • How can I stop the export process in SQL Developer

    I apologize in advance if this is a stupid question but does anyone know how to stop the export process in SQL Developer? Thanks!

    ITKE407,395 pointsBadges:
  • Will Visual Basic 6 still work under Windows 10?

    I retired 15 years ago, and write VB 6 programs for my own use to keep occupied. Will Windows 10 mean "forget it or learn C#"?

    jAubel5 pointsBadges:
  • Copying SQL Azure database to development machine

    I'm looking to copy my SQL Azure database to my local development machine. I already have a development database in the cloud but don't want to pay for it anymore. I have copied by production database to the new development database but I need that same one on the local machine. How can I go about...

    ITKE407,395 pointsBadges:
  • PowerBuilder 11 in SQL 2008

    We are seeing performance issues with our PB 11 app after SQL 2005 DB was migrated to SQL 2008. We did not change any code just the connection profile. From: [Profile APP] DBMS = SNC SQL Native Client(OLE DB) Database=database UserId= DatabasePassword= LogPassword= ServerName=SQLServerName LogId=...

    Lstadler5 pointsBadges:
  • Visual Basic Battleship game complications

    Hello! I am creating a battleship game on visual basic for my computer programming 2 final. In order to chose where you want to place the ship, I allow the user to click on a picturebox of the ship and it brings up another form that has the battleship grid with a checkbox on each square. I realize...

    HelpMeWithThisPlease5 pointsBadges:
  • Create first database in Oracle Database 11g Express

    Recently, I installed Oracle Database 11g Express on my Windows 7 machine. Also, I installed Oracle SQL Developer too. Now, I'm looking to create a database with two tables, followed by using SQL Developer to add / query data. But when I opened Developer, it's asking me to make a new connection (I...

    ITKE407,395 pointsBadges:
  • Three ways to login in to SQL database server?

    Does anyone know what are the three ways to login in to SQL database server?

    melbourne5 pointsBadges:
  • Installing Java on Windows 10

    How do I install Java on Windows 10?

    Chandrasekharan5 pointsBadges:
  • Data visualization

    I am working in a startup, I need to visualize my data using either a reporting tool or data visualization software (both open source). I need to integrate this tool with traffic data coming from Google Analytics, click-cost data from google adwords and the sales data from a CRM software, what...

    amansuri5 pointsBadges:
  • ASP.NET IKM Test

    Does any body have sample question of ASP.NET by IKM ?

    N2009A5 pointsBadges:
  • SQL7919 Data conversion error

    Hi, I have an embedded SQL program in which I generate an XML element as a VARCHAR(256). This is done via: select xmlserialize( xmlelement(NAME "Name", 'Something') as VARCHAR(256) ) as XmlResult from sysibm/sysdummy1 The SQL statement is run via sqlcursor and I fetch the result into a RPGLE...

    mathypaesen10 pointsBadges:
  • How to IBM Genius iSeries application connect to Excel VBA

    How to IBM iSeries Access for Windows connect to Excel VBA or can enter data using VBA code?

    Vijay19915 pointsBadges:
  • Issue with a IBM z/OS FTP MPUT execution in a batch job

    I am trying to MPUT multiple *.XML files from a vendor server to my local server. This process works for multiple files TEST.XML and TEST2.XML, but not for 20160518.XML. Are there filename restrictions. The first character has to be character or is it possible to transfer multiple filename that are...

    LeeAnnNunnery5 pointsBadges:
  • Run Webdynpro for SAP ABAP application as Java

    Is it possible to run webdynpro for ABAP application on SAP Portal Web as Java? In other words, may I develop a WD ABAP in SE80 and then run it SAP NetWeaver Web as Java?

    LiborB5 pointsBadges:
  • #1064 Database importing error

    I am getting this error when I import the database in phpMyAdmin. Only few tables is imported. SQL query: <!-- PMA-SQL-ERROR --> <div class="error"><h1>Error</h1> <p><strong>SQL query:</strong> <a...

    afaf915 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