>I'm working on an urgent job to interface a VFP application to an Oracle application.
>I've got a connection quite alright, but I'm having serious difficulty matching VFP data types to Oracle data types.
>Could anyone supply me what Oracle data type VFP data type match to.
>Thanks in advance

VFP        Oracle
---        ------
Memo       Long [only 1 long allowed per table]
Logical    Number(1)
Integer    Number(n)
Numeric    Number(n,d)
Character  Char or Varchar2
Date       Date [which will always be a datetime]
Datetime   Date [see above]
Time       Char or Date

For the logical add the following after the Number(1):

Default 0 constraint ck_tablename_fieldname check (fieldname between 0 and 1)

For a datetime stamp column, you can add DEFAULT SYSDATE after the column definition.