• SQL related tables

    I have 2 tables one with all my products and their accociated details and another with comments on the products. Product table 1 prodID, title, description, price Comments table 2 commID, prodID, comment I would like to export this to a single XML file, thus an XML element for each product from...

    Geeko5 pointsBadges:
  • Different database & server collation

    Hi, We have a database that is sitting on a SQL Server 2005 with different collation setting, the application connect to the database is running with out any issue. Have anyone had this same issue, if so how long has your application run with different database and server collation without running...

    Db23290 pointsBadges:
  • VBA Looping In Access

    I have a report in Access which pulls from one table in an Access databse.  In the table there is one record for each "Region" and when I run my Access report it then creates one big pdf file containing a one page report for each region.  How can I write a peice of VBA code that will loop the...

    Keithman5 pointsBadges:
  • Triggers

    Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks

    Xixones0 pointsBadges:
  • ms sql query problem with a case statement

    [strong]This code works: SELECT     passengers.*, passship.passship_name AS name, passship.passship_speed AS speed, passship.passship_size AS cargo, hyperjump.hops AS hops, ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) AS ptprofit...

    Rinkratt20 pointsBadges:
  • Most popular blog posts this week

    10. Removing old hardware after a P2V conversion Eric Siebert shares a long-held best practice regarding old server management. 9. The challenge of managing risk when IT budgets tighten Linda Tucci explains the challenges of a down economy -- and offers some tips on coming out ahead. 8. Ellison...

    ITKE344,995 pointsBadges:
  • database

    How to make an offline database that can be access through network

    Fritzeeker5 pointsBadges:
  • Dropping a DB2 Stored Procedure

    In my DB2 stored procs I always first drop the procedure and then do a create statement.  Is there any way I could say something like...if exists (select * from sysroutines where routine_name = 'procname') then drop procedure procname;  ?   I tried this, but the proc doesn't like the IF...

    MIkeyDee5 pointsBadges:
  • Transfer Data from one database to other.

    Hi all, How to transfer datas from one database which has completelly different structure to other datebase with different structure? How to map these database? Is there any tool which does this? If so please suggest some free tool. Please help. Thank you all in advance.

    4knowledgexchng20 pointsBadges:
  • The most-watched IT questions this week: Oct. 13, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussions going on ranging from going green to how to create a new network. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1. Going green: Are you feeling...

    Michael Morisy8,323 pointsBadges:
  • Using SQL with MS Access and the AS400.

    Each of the numbers in the column [New PART] is linked to the column [OLD PART]. The [New Part] column may have multiple rows of the same number in the same column but is it due to the association to the [OLISTd part] column, which are out dated numbers. Both the [OLISTd part] and the [new part]...

    CompEng1,185 pointsBadges:
  • Updating a View

    I have a view that's missing data and needs to be updated. I'm not sure how to update a view - any help would be greatly appreciated. The database name is: ABCD_Dbase The view that needs to be updated is: dbo.vGoLPgcfos Thanks in advance. ~DJ  

    DCDJ45 pointsBadges:
  • Plans and Guidelines for a Web Application Project

    Hello there fellow users, I have been entrusted with the task of designing and implementing a financial system for a charity foundation where I live. The charity foundation requires its work (addition and retrieval of records, for example) to be done online, using a web app. The app connects to a...

    Voulnet5 pointsBadges:
  • abt the server

    is it possible to make my personal computer to act both as client and server for the purpous of doing project like php-mysql-apache and for deployinf j2ee also

    Chansanle20 pointsBadges:
  • Serialization: Mutexes vs. Semaphores

    I am looking for a way to serialize access to a RPG program across multiple jobs. I have been doing some research on mutexes and semaphores and I am wondering what the advantages/disadvantages of each are. Also if there are any other ways to accomplish this. Thanks in advance for your reply

    Joy Stalnecker170 pointsBadges:
  • Master/Child Link problem in Subform

    Hi, I needed to add a new table to my database, so I added it and created a one-to-many relationship with the parent table. I then created a form and used the subform wizard to make it into a subform. The Master and Child links are the primary key in the parent table and the foreign key in the...

    Dataempress115 pointsBadges:
  • Diff. between PF and a sql table

    can anybody say what is the most basic diff. between making pf by writing DDS and sql table by create table command because both can having index.....

    Anky10 pointsBadges:
  • Would someone please give me a short description about EAC (electronic access control?

    in terms of functionality and purpose are they related to biometrics and other physical control methods....

    Latin10 pointsBadges:
  • not a valid Query Management variable.

    Hi, can someone please help me, I am trying to use the QMQRY function to run an update statement. I pass it a variable from the program. Get the following error. is not a valid Query Management variable. Error found on STRQMQRY command. Function check. CPF0001 unmonitored by PGMFCTSEC at statement...

    Pmh5 pointsBadges:
  • Closing Open Databases

    I've been doing access for years, but only really developing one mdb at a time. My new job has me working on this product called UA, which does some pretty slick stuff that I haven't seen before.. Always fun to learn. Anyway, this product has multiple mde's that all are "called" from a main System...

    Jagoodie60 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