• Writing a hidden trigger against a SQL table

    How do I write a hidden trigger against a SQL table?

    SQL Server Ask the Experts2,585 pointsBadges:
  • mixed 2000 db and 2007 mixed datepicker results

    I had an old access database (2000) and ported it to access 2007 all well and good then created a new date field in my form, now i get the datepicker option for the new field but none of the old date fields. any ideas how to get access 2007 to give date picker to my old date fields, i have already...

    Jarcher1230 pointsBadges:
  • 1:1 Modeling Inheritance 1:1

    I am working on a database to store employment history. A person can be employed by an organization or another person. I created the following tables: Person Organization Employer Employment Person and Organization both have a 1:1 relationship with Employer. Employer has a 1:M relationship with...

    Wolfrvr5 pointsBadges:
  • VBA to print to specific printer with print button

    In Access 2007 how do I use VBA code in my print button to print to a "specific printer" for my report.

    RPJ5 pointsBadges:
  • How to manage allocated register problems in RPG?

    Hello. I'm having troubles with many allocated registers for update, when 2 users try to modify the same data. How is the correct way to prevent this situation in ILERPG ? Thanks!

    Mariodlg2,790 pointsBadges:
  • foxprox 2.6 for DOS

    when programs (small or large) runs in foxprox 2.6 for DOS the CPU usage showing 100%. how can i solve this problem. pls answer me

    Anjalimanoj25 pointsBadges:
  • SQL Server 2000 script

    Hi , How can we use SQL 2000 script to call 2nd maximum date? case : Item A has few price with different effective_date, Ihow can i call an item's price with second max(effective_date). Thanks in advance.

    Beginer200825 pointsBadges:
  • I need to permanently delete a re-generating job, but I can’t find its source

    I have used dbms_job.remove to remove all jobs from dba_jobs, but something is re-submitting a series of jobs every few minutes. I have disabled all triggers and all external cron jobs have been stopped... but more jobs keep getting submitted. I have a single transaction record in v$transaction...

    Jcmdba555 pointsBadges:
  • Microsoft Access 2007: Using an IF statement

    I want compare a field in one record to the same field but in the next record. For example I have this IIF statement: IIf(([MAILADDRESS]=[MAILADDRESS]),True,False) This will compare the MAILADDRESS in the same record but I want to compare that same field but in the following record. How do i do...

    Servent15 pointsBadges:
  • Finding which columns contain data in a table

    I have to establish which columns in a table have data present. Each row has up to 100 columns, and not all of the columns contain data relating to the row. So in Table 1, Col1 Col2 Col3 Col4 Row 1 abc Row 2 abc Row 3 abc Would give a report showing that Table 1 has Columns Col1, Col2, Col4 being...

    TedGiles5 pointsBadges:
  • Tuning DB2/400 queries on iSeries

    We are using lot of DB2/400 queries in our iSeries system. Are there any tools available on the market to tune them?

    AS400 - Ask the Expert485 pointsBadges:
  • Creating a Java database

    I want to create a database (not table) using java. Is it possible? If Yes then what should I do? Tell me detail procedure if possible.

    AS400 - Ask the Expert485 pointsBadges:
  • Excel to Access conversion

    When I import data from MS Excel v2003 into MS ACCESS v97, some of the data converts (numbers) converts to scientific form (4268411 converts to 4.26841e+006) even though I specify that the column format is text. How can I stop this from happening?

    QAMAN15 pointsBadges:
  • How to test whether the Database tables designed to avoid deadlock occurence?

    I heard from our dev team that our db tables are designed such that there is no chance of deadlock. How to test whether the Database tables design avoids deadlock? By reviewing the db scripts (table creation) can we find whether the db table design is deadlock proof or not? What else can we do?...

    Saimadhu455 pointsBadges:
  • MySQL capabilities

    Do you guys know where CanI find specific details for mysql like max number of records, max number of connections, max size of databse etc etc? my version is Ver 14.12 Distrib 5.0.51a

    Musoteflirt20 pointsBadges:
  • Migrating data from Microsoft Access to SQL Server 2000

    I want to transfer data from access to sql table and vice versa through windows service. so, plz help me.

    VBNET5 pointsBadges:
  • Referential integrity and AS/400

    Can anyone please explain what refrential integrity means and how does it relate to AS/400? Regards, Shaddy

    Shaddy20 pointsBadges:
  • CMake – Automatically regenerate a file using an external tool and custom target upon “make”

    Hi. I'm working on a project and I use cmake for generating "projects", that is, under Linux, a Makefile. I also use an external tool (re2c) to generate the scanner, and an included tool to generate the parser (lemon, part of sqlite). The problem is I need to "cmake" every time I change something...

    OriginalCopy30 pointsBadges:
  • How can I join 3 tables using JOIN keyword

    Hi Experts, Pls hlp me with my query How can i join 3 tables using JOIN Keyword inside PL/SQL block in SELECT ... WHERE clause Query 3 Tables namely Reg,ROOTS,ME and the select statement takes both parameter variable and local variable Thanks!!!!!

    Inprise610 pointsBadges:
  • Can’t manually enter data any more; get Error Message: String or binary data would be truncated.

    Three databases that were forced restored now do nor allow manual entry, even one single character, although using an update statement works. This is not a matter of changing the length of the datatype, but something else. For the life of me, I can't figure out why this mere attempt at manual data...

    Jimruddy5 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