Re: Info on non-embedded SQL from C

In article <1mrif7INNgko_at_pad-thai.aktis.com> bjaspan_at_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_at_dejavu.spk.wa.us
  Amiga 1000, WB 1.3    |  Work: mfgsys!salnick_at_kaiser.spk.wa.us
      WA9BVE            |