Function msMSSQL2008LayerGetShapeRandom

mapmssql2008.c:1241–1440

Used by NextShape() to access a shape in the query set */

/* Used by NextShape() to access a shape in the query set */
int msMSSQL2008LayerGetShapeRandom(layerObj *layer, shapeObj *shape, long *record)
{
    msMSSQL2008LayerInfo  *layerinfo;
    int                 result;
	SQLINTEGER needLen = 0;
    SQLINTEGER retLen = 0;
	char dummyBuffer[1];
	char *wkbBuffer;
	char *valueBuffer;
	char oidBuffer[ 16 ];		/* assuming the OID will always be a long this should be enough */
    long record_oid;
	int t;

    /* for coercing single types into geometry collections */
    char *wkbTemp;
    int geomType;

    layerinfo = getMSSQL2008LayerInfo(layer);

    if(!layerinfo)
	{
        msSetError(MS_QUERYERR, "GetShape called with layerinfo = NULL", "msMSSQL2008LayerGetShape()");
        return MS_FAILURE;
    }

    if(!layerinfo->conn)
	{
        msSetError(MS_QUERYERR, "NextShape called on MSSQL2008 layer with no connection to DB.", "msMSSQL2008LayerGetShape()");
        return MS_FAILURE;
    }

    shape->type = MS_SHAPE_NULL;

    while(shape->type == MS_SHAPE_NULL) 
    {
        /* SQLRETURN rc = SQLFetchScroll(layerinfo->conn->hstmt, SQL_FETCH_ABSOLUTE, (SQLINTEGER) (*record) + 1); */

        /* We only do forward fetches. the parameter 'record' is ignored, but is incremented */
        SQLRETURN rc = SQLFetch(layerinfo->conn->hstmt);

        /* Any error assume out of recordset bounds */
        if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO)
        {
            handleSQLError(layer);
            return MS_DONE;
        }

        /* retreive an item */

        {
            /* have to retrieve shape attributes */
            shape->values = (char **) msSmallMalloc(sizeof(char *) * layer->numitems);
            shape->numvalues = layer->numitems;

            for(t=0; t < layer->numitems; t++)
			{
				/* figure out how big the buffer needs to be */
                rc = SQLGetData(layerinfo->conn->hstmt, (SQLUSMALLINT)(t + 1), SQL_C_BINARY, dummyBuffer, 0, &needLen);