• 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 Rouse2,585 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:
  • URGENT!!! file field decoder generated on AS/400

    REALLY URGENT!!!!!!!!!!!!!!!!!!!!! How can i view the contents of a packaged field? I send an example of the chain. I need to visualize the contents of the little squares: 5 1 91010 491997 9801011L 980101 1 1021023 102 103 100 DTO CARULLA DTO CARULLA DTO CARULLA 0 1 0 11 K 1TQ 15% Q TQ NAL T TQ NAL...

    Onasis0 pointsBadges:
  • computer protection with revert

    I am looking for a solution wich will allow me to revert computers setting back to original each time computer reboots. Basically on reboot computer will earse all files and configurations made in previous session.

    Dimchik0 pointsBadges:
  • outer join issue

    Following occurs in a cursor is plsql block: I have 3 tables: Source (name) Lookupmap (name, lookupname) Lookup (lookupname) I have to: 1)outer join Source and LookupMap based on NAME in order to validate that NAME actually exists in Lookupmap. If NAME in LookupMap is null then I have to provide a...

    Hosrow0 pointsBadges:
  • Error in a Group of Called Programs

    Hi, I have a CL program, it calls 10 other programs i.e. pgmA, pgmB, pgmC.......so on...10 programs. While running the CL program error occurred in pgmC. I rectified that error. After rectification once again I will run the CL Program. Now my execution must start from pgmC. How do i do this???...

    0 pointsBadges:
  • media recovery

    Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....

    Sukaina10 pointsBadges:
  • Question on Workfile

    Hi, Please could any one help me getting answers to these Questions.... What is the diff. between Workfile and PF? How do u create a WorkFile in RPG or CL. What are the advantages of WorkFile over PF? Thanks Rama

    0 pointsBadges:
  • Sorting out missing out

    I have 2 files. One having 1000 records and the other 1350. I need to sort out the missing records and place them in an excel sheet. Programmatically how to acgieve this???

    0 pointsBadges:
  • Updating one record with a field of another record where two other fields match

    I have the following Table: XREF Group Projid id1 id2 ----- -------- ----- ----------- AEEC SOCAL 71 442760 CAG AWPE 71 442780 CAG MONDPL 71 447585 CAG PLANDI 71 442780 CAG SMCECA 71 442780 CAG AWPE 84 442781 CAG MONDPL 84 447588 AEEC MONDP 84 447589 CAG PLANDI 98 288923 CAG SMCECA 98 288923 CAG...

    Donnewbee0 pointsBadges:
  • Sorting out missing records.

    Suppose i have 2 database files. one with 250 records and another with 350 records. There are some common records in both files. How to get the missing records?? Is this possible with CPYF command. If yes???Please explain me how to get this. or Is there any other to achieve this. Thanks and Regards...

    0 pointsBadges:
  • Schedule SQL on an I5

    Hi, Can anyone advise the best method of scheduling an ISQL statement to run on an I5. I need to run some update statements after hours etc. and I don't want to have to run the commands manaully each time. It has been suggested that a RUNSQL will do what I need but I am unable to find any reference...

    JezEling0 pointsBadges:
  • Assessing Security Appliances

    We have several appliances performing specialized tasks in our environment. I've been asked to perform an audit of these appliances. Since most of these appliances run a version of Linux/Unix I've decided to audit in a two phase process. First looking at the OS/Kernel and then the application. My...

    LeSure0 pointsBadges:
  • Lotus Domino Database Structure

    Hi I am trying to map a Lotus Domino Database into tables. Is is true that Views are like tables and documents are like rows in the view? Is this the right way to do it? If not, please could you explain how to do the mapping? Thank you in advance Mirkia Sadler

    Mirkia0 pointsBadges:
  • Correlated Subquery – NOT EXIST

    Hi - I'm trying to add a not exist subquery in my where statement and have several other joins ahead of it. I'm having difficulty determining where to put the NOT EXIST as the subquery is named as a column - ie blue.color in (select * from .....). Where would I put the NOT EXIST In this case?...

    Holl1230 pointsBadges:
  • how to interconnect sql server with remote oracle server

    I have sql server on my system and Oracle system on the remote system and I need to fetch the data from the remote oracle on my sql server. please send me the steps of the whole process.

    Saahil0 pointsBadges:
  • Email Delivery Errors

    Hello All, Someone is having problems sending emails to us which did not exist before. Our email server (Unix based) did not list his domain as spam according to our email technician. Also for troubleshooting purposes i've asked him to send to my hotmail account which resulted in the same manor not...

    Maryam82100 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