jan@grebyn.COM (Jan Baron) (01/04/89)
Hello, out there. This is my first attempt to post any kind of article, so bear with me... Problem #1: Attempting to DELETE a record using embedded SQL in a C program returns a 1403 (data not found) even though a SELECT statement performed just previous using the same select criteria finds the record. Problem #2: Updating records using SQL directly does not always work. I've tried performing 6 updates, then going back and SELECTing to see if the changes are OK. The changes are not reflected. The only way I can get it to work is by doing 3 updates, exiting SQL to commit them, and then going back in and doing three more. This has happened to others here as well, so it's probably not user error. Anyone run into similar problems? Input would be greatly appreciated! Have a good one... ********************************************************************** * * Jan A. Baron * * ...another day, another quarter... * American Mgmt. Systems * * (inflation, y'know) * 1525 Wilson Blvd, 4th fl. * * * Arlington, VA 22091 * * jan@grebyn.com * (703)841-7077 * **********************************************************************