• 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:
  • Error: method or datamember not found

    i want to get data (liftno,model)etc in a subform by selecting a combo in main form .the subform data is from another table and in the main form cc field is from other table LiftNo.RecordSource = "SELECT Proj_d.LiftNo, Proj_d.Model, Proj_d.Capacity, Proj_d.Capacity, Proj_d.Speed, Proj_d.Stops FROM...

    1234a10 pointsBadges:
  • Insert superscript text into Oracle database

    how can i insert superscript or subscript text to the data base i have colomn called measuments Units and i want to insert quadratic meter M2 or Cubing meter M3 am using oracle 9i pleeez help

    Rosealzubi115 pointsBadges:
  • Webpage and SQL interaction

    The problem I need to figure out is that I need to have client information stored on an SQL server database and I need something to be able to use this information to get quotes from several insurance companies. All these companies require different info in a different order. So my questions are as...

    Katy20 pointsBadges:
  • Trend Micro ScanMail for Exchange 2007 – Virtual Lab

    Need to eval. TrendMicro's Scanmail but do not have a lab environment setup that matches our prod. environment of Exchange 2007. Are there any virtual labs out there that may help or any other suggestions for getting the feel for Scanmail?

    DewIT20 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:
  • Galelio

    can you tell what steps to take when installing galelio.

    Tshwarelo35 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:
  • Application using VB6 & SQL

    Dear sir, I am computer data entry operator, i would like to make one simple application reg Payroll using VB6 and SQL. I know only some basic commands in both but i dont know what are the steps taken first what we have to do (crating forms in vb or creating tables in sql or other i dont know...

    Lahari5 pointsBadges:
  • SQL Server 2008

    How to format crlf inside a field text

    2601515 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:
  • Efficient way of testing multiple character set support in your application

    If we need to test the localization/ internationalization support of an application (i.e, supporting ascii, german, japanese characters etc) then how to perform this testing efficiently?

    Saimadhu455 pointsBadges:
  • ABT database backup from SQL Server 2000

    hi please tell me that, if i am using vb as front end and sql server 2000 as backend then for giving the facility of implicit periodical data backup at project, how can i go......through vb coding...

    Nileshmahadik5 pointsBadges:
  • SQL help

    hiow to pick only alphbets in a string or a column using sql

    Ecsbc35 pointsBadges:
  • Visual FoxPro Help

    I have a large scale desktop application written in VFP 9 and I want to enable it to run on the web. I've looked everywhere to find info on how to do this and I can't find any. Can anyone point me in the right direction or provide any info? Thanks! Angel McCollum

    Oransoft5 pointsBadges:
  • Invalid Format Error when Opening/Saving in Visual Studio 2008.

    Hi I'm creating a professional Text Editor with usage of RichTextBox control, and I have inserted some common controls such as SaveFileDialog and Load File Dialolg, and I basically want to be able to load files of all types (i.e Word Documents) the only documents I can open are RTF. I tried to...

    Ppp5 pointsBadges:
  • Not allowed to edit Microsoft Access forms

    A previous employee built a very usable db, and has gone on to greener pastures. It isn't password protected. When we try to edit the db with new fields or change wording in fields, it asks if we want to exit the app. if Yes is clicked, it exits the app and Access. We use Office Pro 2003. Any help...

    Donnerblue5 pointsBadges:
  • Ignoring fields in SQL Where Statement

    Can fields in a where statment be ingnored. Such as Where name = :name and date = :date, but if I just pass in a name I'd like the where to select only on the name and ignore the date.

    Charrdzc5 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