• Showing all records

    DATA SET: Table1 XID YID WRKDATE --- --- ------- 1 NOR 2007-01 2 SOU 2007-03 Table2 XID ZID QTY --- --- --- 1 PEN 10 1 PAP 20 2 PAP 5 1 PEN 10 2 PAP 5 Result XID YID WRKDATE ZID QTY --- --- ------- --- --- 1 NOR 2007-01 PAP 20 1 NOR 2007-01 PEN 10 1 NOR 2007-01 PEN 10 2 SOU 2007-03 PAP 5 2 SOU...

    TeamJR315 pointsBadges:
  • how to define page lenth in foxpro 2.6 for win 95

    if in each run of the same prg the output to be sent to the printer is of different length how to define it

    Rajaji197890 pointsBadges:
  • Passwords

    Hi all, What do you recommend for initial password issue, that is, provided a new user with a password for the first time without compromising it. I find the entire help desk giving password initially or sysadmins doing that is not save enough even though the user will be prompted to change it at...

    Bangim0 pointsBadges:
  • Running Syantec Antivirus on a Windows Domain Controller

    I am currently in the process of deploying Symantec AntiVirus Corporate edition in my Windows-based network. In the manual it states, Do not install the primary management server on the following: Miscrosoft Exchange Server, Web server, or programs that prevent you from restarting the computer at...

    Skepticals0 pointsBadges:
  • R2

    does anyone know if windows server R2 is compatible with exchange 2003?

    Wolfden0 pointsBadges:
  • Cold Fusion and Data base application

    I am in the process of developing and internet web site, and do not know cold fusion. I have a database in access that I want customers to be able to search. There will be three levels of search and I am using dreamweaver 8 for designing my web page Instead of coding every link into my html, I want...

    Stevehm0 pointsBadges:
  • Question on JOIN Clause

    Folks, Is there any differences between selecting values from a table using JOIN clause, by using as JOIN or INNER JOIN. I mean, Will the result or performance changes when JOIN is used instead of INNER JOIN in MS SQL SERVER 2000/2005 Thanks in advance ! ash

    Ashok tak0 pointsBadges:
  • update single row error

    This query returns a single row error while attempting to update the mfr_name_id in the property table with the values in the eqp_mfr_names table where property.mfrcode = eqp_mfr_names.mfr_code why? UPDATE property p SET (mfr_name_id ) = ( SELECT (mfr_name_id) FROM eqp_mfr_names WHERE mfr_code =...

    Mandrews810 pointsBadges:
  • Select from table where data row missing

    I have a table with the main fields being BU, ASSET, BOOK for any BU and ASSET combination, there should be two to four rows of data, with just the BOOK value being different. Data corruption has caused us to find all BU-ASSET combinations missing the value 'AMT' for BOOK. I need to join the table...

    Jej12160 pointsBadges:
  • Open MSAccess database

    Hi there, Does anyone know how I can open an Access database with script without giving the path of the MSAccess.exe file. I would need the equivalent of Execute, @Command that does not require a path. @Command( [Execute] ; "msaccess.exe"; "C:\\MyApps\Test.mdb" ) currently I am using Shell that...

    Constantin0 pointsBadges:
  • what is VOW in terms of DB server

    what is VOW in terms of DB server

    Subha0 pointsBadges:
  • Data Sync in tow tables

    We are in the progress of restructing the old database. In this effort , we are joining data from 3 files files and creating a new schema. in the process of migration , we need to keep the new file and the old files in sync. How do we achive this? I was planning for triggers on Old file and the New...

    Uiiuo50 pointsBadges:
  • Backward compatibility on OS level V4R4 to V4R3

    Have a question on backward compatability. Currently we moved some historical JD Edwards data that was on an AS/400 running OS400 V4R5 to a machine running V4R4. Now, we want to move this to another AS/400 that is running V4R3. Now, from V4R5 to V4R4 we havd no problems. I'm not sure if we can take...

    Sysop0 pointsBadges:
  • Synchronizing Two Subforms in MS Access

    In my main form I have two tabs – Alumni Class and Placement – both of which tie to the AlumniClass and Placement tables respectively. My Alumni Class subform stores the year and term a person graduated. My Placement subform tracks if the person was offered a job (company name & position) for...

    FERREJE0 pointsBadges:
  • SQL joins on encrypted data

    Hi - we are in the process of encrypting various pieces of sensitive information in our SQL 2000 tables. For many fields we are using Blowfish 448 encryption and a concern has arisen about inline SQL statements that contain joins in our ASP scripts. Are there any scenarios that you have run across...

    Tombstone7770 pointsBadges:
  • I can update the dataset, but not the database

    Posted on behalf of BodjorB: I have been trying to update a database in a program i developed using Microsft Visual Basic 2005,SQL Express -- whenever I enter data and click on Update, this updates the dataset, but the database is not updated. What am I forgetting?

    Margaret Rouse1,280 pointsBadges:
  • ASE 12.5.4 disable printing of column headings

    How can I suppress the printing of column headings while using isql (command line utility provided by Sybase ASE)? without using and sed filter commands. I cannot use -b flag coz the isql utility that I have on my machine doesnot have -b flag.

    Dips0 pointsBadges:
  • Tracking Changes to Files

    Requirement:- To track any changes to Two files A and B and write fields of A and B to an output file C. A is related to B (A.Employee = B.Employee) Could you please suggest a good approach for this? I am currently using the approach of journalling. 1. Both A and B are journalled. 2. If Any changes...

    AyeYes4000 pointsBadges:
  • odbc access error…….

    Hi, a company send their information for us,it was a zip file that contains a ms access database file and a simple exe file,when I have administrative right on computer when I run exe file,a form was opend and I can see data,but when a power user open it an error was appear :...

    Aliyani265 pointsBadges:
  • Excel Data Transfer Add In

    I tried transferring data from a physical file (AS400) using the Excel Data Transfer Add In (Client Access) and am getting cells with unreadable syntax. It appears that a space is being populated with a 4040 string etc. Is there a way to get the information transferred without having to modify the...

    Joe9250610 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