pditallo@uswat.uswest.com (Paula Ditallo) (01/15/91)
Hello C Pros.... ....I've gotten myself into a fine kettle of fish.... ...and thought someone out there may have the answer... I am trying to do row processing through embedded SQL...from the first row in the table through the last....and while each row is being processed...i need to parse 2 strings on the fly based on the character length of the original strings.... ..which are actually the returned values from 2 columns -- i then need to concatenate these 2 strings with a third string (which will always be the same) and insert the result string into another table. ...so far i've created 2 function calls - 1 to handle the integer values of the string lengths and the other to handle concatenating the final string. ...but i have no idea how to incorporate what i need to do in C into the middle of an SQL loop.......any ideas??? - Thanks /*paula*/ BTW, the db i'm working with is Ingres-- version 6.3/01 for a Sun Server/4.1C ********************************************************* Paula L. DiTallo Delta Research & Development 11994 Bear Park Rd. 999 18th Street, Suite #1000 Conifer, CO 80433 Denver, CO 80202 303-838-4889 303-291-9525 "76176.1634@compuserv.com" "pditallo@uswest.com" ---------------------------------------------------------