////////////////////////////////////////////////////////////////////
//
//  FGBseField.m
//  Commesse
//
//  Created by Francesco Germinara on Mon Jun 07 2004.
// 
//  Copyright (c) 2004 SofTech di F.Germinara - www.germinara.it. All rights reserved.
//
//  For information please contact me at info@germinara.it 
////////////////////////////////////////////////////////////////////
//  History:
//
//  Description:
//
////////////////////////////////////////////////////////////////////


#import "FGODBCFieldInfo.h"
#include <iODBC/sql.h>
#include <iODBC/sqlext.h>
#include <iODBC/sqlucode.h>


@implementation FGODBCFieldInfo

-(id)init{
 self=[super init];	
 strValue=[[NSString alloc]init];
 return self;
}

-(void)dealloc{
	[strValue release];
	[name release];
	[super dealloc];
}

//Set Object Values
-(void)SetValues:(NSString *) strName forType:(SWORD) nType  forPrecision:(UDWORD) nSQLPrecision forScale:(SWORD) nSQLScale  forNullability:(SWORD) nSQLNullability forCol:(int)nSQLcol{
	if(name!=nil)
	 [name release];
	name=[[NSString alloc] initWithString:strName];
	
	nSQLType=nType;   
	nPrecision=nSQLPrecision;   
	nScale=nSQLScale;       
	nNullability=nSQLNullability; 
	nCol=nSQLcol;
	
	//Calcolo la dimensione del campo in base al tipo di campo
	switch (nSQLType)
	 {
		case SQL_VARCHAR:
		case SQL_CHAR:
		case SQL_WCHAR:
		case SQL_WVARCHAR:
			nLenght = (short) nPrecision;
			break;
		case SQL_BIT:
			nLenght = 1;
			break;
		case SQL_TINYINT:
		case SQL_SMALLINT:
		case SQL_INTEGER:
		case SQL_BIGINT:
			nLenght = nPrecision + 1;	//Segno
			break;
		case SQL_DOUBLE:
		case SQL_DECIMAL:
		case SQL_NUMERIC:
		case SQL_FLOAT:
		case SQL_REAL:
			nLenght = nPrecision + 2;	//Segno e Virgola
			break;
		case SQL_DATE:
			nLenght = 10;
			break;
		case SQL_TIME:
			nLenght = 8;
			break;
		case SQL_TIMESTAMP:
			nLenght = 19;
			break;
		default:
			nLenght = nPrecision;     
	 }
}

//Return Field Name
-(NSString *) name{
 return name;
}

//Return Field Length
-(int) length{
 return nLenght;
}      

//Return Col
-(int) ColNum{
 return nCol;
}

//return Type
-(int) Type{
 return nSQLType;   
}

//Return precision
-(int) Precision{
	return nPrecision;   	
}

//Return Scale
-(int) Scale{
	return nScale;       	
}

//Return Nullability
-(int) Nullability{
	return nNullability; 	
}

//Set the new value
-(void) SetValue:(NSString *) strNewValore{
 if(strNewValore!=nil){
  [strValue release];
  strValue=[[NSString alloc] initWithString:strNewValore];
 }
}
//Get the value
-(NSString *) GetValue {
 NSString *strResult;	
	
 strResult=[strValue stringByTrimmingCharactersInSet:[NSCharacterSet whitespaceCharacterSet]];	//TOLGO GLI SPAZI SUPERFUI...
 return strResult;
}

@end