Conference turris::c_plus_plus

3471.0. "use of String as output arg in SQLMOD" by CIM2NI::THORPE () Fri Feb 28 1997 16:01

Is it possible to use SQL to read into an object of type String?  Or do
I have to declare an array of char of the proper length and then load
that into the String?  Using a String in place of char* is fine for an
input argument but I can't get it to work for an output argument.

Thanks,
Bill

for example:

//t.cxx
#include <iostream.hxx>
#include <String.hxx>

#ifdef __cplusplus
extern "C" {
#endif

extern void get_name(int *sqlcode ,char *name);

#ifdef __cplusplus
}
#endif

main()
{
  String name;   // it is nice not to have to worry about string length
  int sqlcode;
  get_name(&sqlcode, name);
  cout << "name read from database is " << name << endl;
}

--------------------------------
//t_mod.sqlmod (pseudo code)

PROCEDURE get_name
    SQLCODE
    :name       char(20)
    ;

    SELECT name INTO :name FROM blah_table
    LIMIT TO 1 ROW
    ;