Re: Embedded SQL

Posted in 1995

Billy Wheeler — Tue, 24 Oct 1995 06:38:07 GMT — source: Informix-list mailing list archive (1991-1998)

dray@icsware.com wrote: > Is there a way to use variables in embedded sql commands in C/UNIX >environment? This is what I want to do > select :var_column_name from :var_table_name; > I know how to host variables but wanted to know if host variables >canbe used for the table and column names. >Thanks in advance You can build SQL statements up as strings, PREPARE them and DECLARE them as cursors. HTH. -- Cheers, Billy ----------------------------------------------------------------------------- INCLUDE "Disclaimer.4gh" -- my opinions are INCLUDE "FlamesToDevNull.4gh" -- flamers, eat my shorts! INCLUDE "CaveatEmptor.4gh" -- take my advice at your own risk INCLUDE "ThirtySomething.4gh" -- header file for this class -- Written by : Billy Wheeler, Date: today -- Copyright (c) 1995, The West Solutions Group