>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.
Mark McCasland
Midlothian, TX USA