Re: ESQL/C question

wche@ucs.att.com (wche@ucs.att.com) wrote: : The call : rgetmsg((short) -206, errmsg, (short) sizeof(errmsg)); : returns the folling in errmsg: : The specified table (%s) is not in the database. : Why is %s, instead of the table name, showing up ?? : Any help will be greatly appreciated. : wche@ucs.att.com This information (e.g. table name) can found as part of the sqlca structure. The 'char sqlerrm[72]' field contains the error message parameters. This can be used to fill in the '%s' in the errmsg. One has to write something like : if (!rgetmsg(nr, errmsg, (short) sizeof(errmsg))) printf(errmsg, sqlca.sqlerrm); Hope this helps. -- ----------------------------------------------------------- Bart Van der Cruyssen Bart.VanderCruyssen@rug.ac.be UNIVERSITY OF GHENT (BELGIUM) - Computer Science Laboratory Technologiepark-Zwijnaarde 9, B-9052 ZWIJNAARDE, BELGIUM tel: +32/9/264.55.09 fax: +32/9/264.58.42