MOTOBIT.COM - ASP upload, IIS utility CurrencyDecimal Property of DBF class

Property | Member of  RSConvert.DBF | Changes | Purchase | Download

Description

Decimal places for Currency field type

Syntax

vCurrencyDecimal = DBF.CurrencyDecimal
DBF.CurrencyDecimal = vCurrencyDecimal

Returns

Byte

Examples

Export from ADO sample

<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>
  'Sets the content type
  Response.ContentType = "application/x-msdownload"
  'Specify filename for download
  Response.AddHeader "Content-Disposition", "attachment;filename=Orders.DBF"
  
  'Create Recordset and DBF objects
  Set ADORS = CreateObject("ADODB.Recordset")
  Set DBF = CreateObject("RSConvert.DBF")
  
  'Sets parameters for Integer and Currency fields
  DBF.IntegerWidth = 6
  DBF.CurrencyDecimal = 2
  DBF.CurrencyWidth = 6
  
  'Open table
  ADORS.Open "Payments", "DSN=ADOSamples"
  
  'Write DBF file to the client
  Response.BinaryWrite DBF.GetFile(ADORS)
  
  'Close recordset
  ADORS.Close
</SCRIPT>

Other links for CurrencyDecimal

Methods of DBF class

GetFile, SaveRS

Properties of DBF class

Compress, CurrencyDecimal, CurrencyWidth, DoubleDecimal, DoubleWidth, IntegerWidth, LongVarCharWidth, RowCount, SingleDecimal, SingleWidth, TempDirectory

RSConvert.DBF

Object for converting DAO or ADO recordset to the DBF file. It enables direct output of DBF files from the ASP page.

RSConvert

      Recordset converter is a library for converting DAO or ADO recordsets to MDB or DBF files. It enables direct binary output of MDB or DBF files from ASP pages with one row of code. The object also supports on-the-fly compression by zip/arj.

© 1996 - 2009 Antonin Foller, Motobit Software | About, Contacts | e-mail: info@pstruh.cz