Re: Info on non-embedded SQL from C

In article <1mrif7INNgko@pad-thai.aktis.com> bjaspan@Aktis.COM (Barry Jaspan) writes: >I have a C program that generates standard SQL (**) at run time based on user >input and executes against a preexisting database. It is currently >implemented to use Sybase, although I designed it (hopefully) to allow other >SQL engines to be used easily. All I need from the RDBMS is the ability to >execute a single SQL SELECT statement and read the resuling rows back. In >Sybase, I can do this by building a null-terminated C string with the SQL >statement, calling dbcmd(), dbexec(), and dbresults(). I cannot use an >embedded SQL system because I do not know the SQL statements to be used at >compile time. This is what dynamic SQL was invented for. Ingres does this just fine - we use it a lot. bob -- Like Entropy, bugs can only be created, not destroyed. RW Salnick, Spokane,WA | Home: salnick@dejavu.spk.wa.us Amiga 1000, WB 1.3 | Work: mfgsys!salnick@kaiser.spk.wa.us WA9BVE |