Dynamic SQL problems

Posted in 1998

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Data Types & Schema Design

nezza@rocketmail.com — Wed, 23 Sep 1998 10:42:41 GMT — source: Informix-list mailing list archive (1991-1998)

INFORMIX Dynamic SQL problem in ESQL/C. Could someone tell me why this is returning enexpected results for Datetime: All the other data type conversions work fine, this doesn't why? It produces bad results. pCol->sqldata has been allocated enough memory for storage. dttoasc doesn't complain, but when i view the result, it's crap. case SQLDTIME: if ( *(pCol->sqlind) == 0 ) { nErrNo = dttoasc((dtime_t*)(pCol->sqldata), szColData); if ( nErrNo !=0 ) { fprintf(stderr, "SQLERROR %ld, Converting %s COLUMN, " "File: %s, Line: %d\\n", nErrNo, rtypname(pCol->sqltype), __FILE__, __LINE__); return TRUE; } /* ClipString( szColData ); */ fputs(szColData, pUnlFile); } fputs(pszDelimiter, pUnlFile); break; Any help would be great. -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

Glossary

ESQL/C