• Export from database to Excel and filter by DropDownList

    please provide me with all information on how to export my data to an excel sheet and how to filter the data using a dropdownlist (asp.net)

    Yaz5 pointsBadges:
  • Combo box date/alpa field

    Can it be done and how... I create a combo box and I want the field to have some alpha some numeric. the drop down will say "N/A". But if they want to put a date in that field, should be able to. My testing show it has to be either or. Also when I type in the year in that field, I will be typing...

    Slcart115 pointsBadges:
  • Configureing DTC in Windows 2008 64 bit clustering with SQL 2008 std 64 bit

    I have read some limited blogs and kb articles about this DTC setup in windows 2008 clustering with SQL 2008. I like to get some clarification about this DTC setup. Our shop doesn't use distributed transactions but we do use transactional replication. So our DTC is mostly used in SQL related...

    OceanDeep15 pointsBadges:
  • ODBC in AS/400, OS/400, System i, i5/OS

    Where can I find an ODBC Driver for AS/400? I asked this because I would like to setup an ODBC in AS/400 to connect Lotus Notes (in AS/400) to MySQL (in Windows).

    Yinphin15 pointsBadges:
  • Advice on buying new PC

    I have a Pentium 4 & need to upgrade. I teach Microsoft, use graphics in my manuals, & use CorelDraw a lot. I also design huge Excel spreadsheets with lots of formulas and design databases in Access - what would be a good PC processor, ram, etc? I have been quoted on a system with a Quadcor...

    Shazzie70 pointsBadges:
  • Access 2003 checkbox to perform calculations

    I have modified the ledger template database from MS to incorporate 4 columns containing yes/no checkboxes. The checkboxes refer to 4 phases of contruction for the line entry. Some line entries may have nore than one box checked. My problem is that when I need to run a report on an individual...

    Tm13005 pointsBadges:
  • FND_RESP_FUNCTIONS

    Is there an API or a script I could use to make massive inserts into FND_RESP_FUNCTIONS?

    Castedstone5 pointsBadges:
  • Haversine formula in RPG or SQL

    I need to put the haversine formula in an sql or rpg function on the as400 to calc the distance between to zip codes. I do not have much experience with sql. can anyone give me some help?

    Brenger170 pointsBadges:
  • Prevent Update in DB2 SQL External Trigger Program

    I have a 3rd party application that maintains a customer master file (update, insert, delete) and I cannot alter their programs. I would like to put a trigger on the database file to fire an external program on insert and determine if the insert should be performed. If not, I would like to send a...

    Djswtd25 pointsBadges:
  • Create table by comparising 2 tables

    I am new at Access but have some help with creating a db. I would like to know if it is possible to compare table 1: prior data and table 2: current data, and then create a table 3, with all the changes/deletions from the 1st table to the 2nd. All the data is workflow tasks that are dates. I need a...

    Gooies5 pointsBadges:
  • Access control list error: ‘The name is not in the list’

    When I try to remove a Notes user from my ACL, I get this error: "The name is not in the list." Does anyone have any ideas as to why I am receiving this error message?

    Domino Ask The Experts435 pointsBadges:
  • About UPDATE query

    hi friends , i am using VB 2008 . database access 2003 in my project , i include an update query,its below con.Open() Dim cmd As New OleDbCommand("update device set manu='" + mtxt.Text + "',desc='" + dtxt.Text + "',model='" + mdtxt.Text + "',pdate='" + prodate.Text + "',price='" + ptxt.Text +...

    Ashar5 pointsBadges:
  • Issue SQL Query with Localized String through PowerShell

    Hello, I am attempting to execute a an SQL query through PowerShell against an MS Access database. My query works 99% of the time, but occasionally a localized string will cause an error beacuse it contains a single quote (') somewhere within the localized string. You can look at the following...

    Bgsullivan15 pointsBadges:
  • Embedded SQL in RPG ILE

    I want to write a program that will retrieve any field(s)from any file on the iSeries. The only part I haven't figured out is how to code the fetch statement to populate variables that aren't known until execution time

    Jeffm125 pointsBadges:
  • Access 2007 Replace operation

    In Access 2007, can a replace operation be performed using wildcard to replace a variable string with a known string.

    Gmmdm5 pointsBadges:
  • Connecting to a remote DB on a UNIX server with SQL

    I am trying to connect to a remote DB on a UNIX server. I am using embedded SQL statements to achieve this task. I have a file that contains DB name, ID & PW that I pass to the connect statement, rather than hardcoding the info to the program (for security reasons). C EstConnect BegSr * C Eval...

    AS400 - Ask the Expert485 pointsBadges:
  • FORMAT keyword in non-join logical files — what and how?

    How do I use FORMAT keyword in a non-join logical file? What is the main purpose of that keyword?

    AS400 - Ask the Expert485 pointsBadges:
  • SQL proceedure to join header and detail file

    I want to know how to set up a SQL procedure that joins a header file and detail file where the status field in header = 'X' then updates this header record after selecting the detail records.

    AS400 - Ask the Expert485 pointsBadges:
  • Database design schema for Test Data Management?

    For test data analysis across the builds, platforms etc, we are thinking of storing the test execution results into the database. Please let me know if any one has already designed the db schema for test case & report management.

    Saimadhu455 pointsBadges:
  • Spool to Flat

    Can anyone please guide me on the following: 1) How can I convert Spool to Flat and vice cersa ? 2) If I already have a Flat file. Can I convert it back into spool ? using what utility ? 3) What are the archivers that convert Flat to Spool and vice versa ?

    SyedJR10 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