This example uses the NumericScale and Precision properties to display the numeric scale and precision of fields in the Discounts table of the Pubs database.
import com.ms.wfc.data.*;
import java.io.* ;
public class NumericScaleX
{
// The main entry point for the application.
public static void main (String[] args)
{
NumericScaleX();
System.exit(0);
}
// NumericScaleX function
static void NumericScaleX()
{
// Define ADO Objects.
Recordset rstDiscounts = null;
Field fldTemp = null;
// Declarations.
BufferedReader in =
new BufferedReader (new InputStreamReader(System.in));
String strCnn = "Provider=sqloledb;Data Source=srv;"
+ "Initial Catalog=Pubs;User Id=sa;Password=;";
int intLoop;
try
{
rstDiscounts = new Recordset();
// Open recordset.
rstDiscounts.open("Discounts", strCnn,
AdoEnums.CursorType.FORWARDONLY,
AdoEnums.LockType.READONLY,
AdoEnums.CommandType.TABLE);
// Display numeric scale and precision of
// numeric and small integer fields.
for ( intLoop=0; intLoop <
rstDiscounts.getFields().getCount();intLoop++)
{
fldTemp = rstDiscounts.getFields().getItem(intLoop);
if((fldTemp.getType()== AdoEnums.DataType.NUMERIC) |
(fldTemp.getType()== AdoEnums.DataType.SMALLINT))
{
System.out.println("\nField: "
+ fldTemp.getName());
System.out.println("\nNumeric scale: "
+ fldTemp.getNumericScale());
System.out.println("\nPrecision: "
+ fldTemp.getPrecision());
System.out.println("\n\nPress <Enter> to continue..");
in.readLine();
}
}
// Cleanup objects before exit.
rstDiscounts.close();
}
catch( AdoException ae )
{
// Notify user of any errors that result from ADO.
// As passing a Recordset, check for null pointer first.
if (rstDiscounts != null)
{
PrintProviderError(rstDiscounts.getActiveConnection());
}
else
{
System.out.println("Exception: " + ae.getMessage());
}
}
// System read requires this catch.
catch( java.io.IOException je)
{
PrintIOError(je);
}
}
// PrintProviderError Function
static void PrintProviderError( Connection Cnn1 )
{
// Print Provider errors from Connection object.
// ErrItem is an item object in the Connection’s Errors collection.
com.ms.wfc.data.Error ErrItem = null;
long nCount = 0;
int i = 0;
nCount = Cnn1.getErrors().getCount();
// If there are any errors in the collection, print them.
if( nCount > 0);
{
// Collection ranges from 0 to nCount - 1
for (i = 0; i< nCount; i++)
{
ErrItem = Cnn1.getErrors().getItem(i);
System.out.println("\t Error number: " + ErrItem.getNumber()
+ "\t" + ErrItem.getDescription() );
}
}
}
// PrintIOError Function
static void PrintIOError( java.io.IOException je)
{
System.out.println("Error \n");
System.out.println("\tSource = " + je.getClass() + "\n");
System.out.println("\tDescription = " + je.getMessage() + "\n");
}
}