Re: NewEra Demo code bugs
Posted in 1995
Topics: Connectivity: ODBC / JDBC / .NET
Hi, On Sat, 19 Aug 1995, Peter Wiley wrote: > Now, a question. I can add a row to orders and hit the apply button. All > appears OK; the serial number is incremented properly, I can fetch another > customer's details, come back and my new data row is still present. > However, once I exit the window then re-run it, my inserted row(s) have > vanished. The thing that you want to keep in mind is that you are working with the result set, not the physical row. Two topics to research here are applyRowSQL and ixSQLConnect.transact(). The latter will have your data be applied to the database. There are several things that need to be considered in your explorations. The first is the requirement that the ixSQLxxxx classes are designed to: 1. Be portable across different operating systems 2. Be ODBC compatible These, in the long run, help to ensure that your application is source compatible across multiple platforms with few/no source changes. I would suggest that while you learn about super tables and super fields that you thouroughly investigate the database connection objects and understand how they *really* work. Code a few up by hand. Then, when you start working on super tables again, you will understand what is going on underneath the covers. Best of luck to you. Ken /*----------------------------------------------------------------------- | Ken Gonzalez | Informix Software | Voice: 714-251-6578 Professional Services Division | Fax: 714-251-6579 18101 Von Karman, Suite 350 | e-mail: kengon@informix.com Irvine, CA 92715 | | -----------------------------------------------------------------------*/ #include <std_disclaimer.h>