>>Is there a VarChar field type in VFP7? I know there is not one in 6 although it would be nice to have.
>>
>>Tommy
>
>No.
varchar(2) is a datatype in Oracle. An sql query in VFP will return a VARCHAR(2) field as a memo field in your resulting cursor.
this because the field length of a VARCHAR(2) in Oracle can be up to 2000 Characters. When VFP does the tableupdate() it will automatically translate the memo field back to the VARCHAR(2) that Oracle requires. If you use Oracle's SQL syntax, then you will need to convert the memo field in the SQL script. Incidently, I am having a lot better performance with Oracle's version of its SQL driver, over that supplied by Microsoft.
The default settings in tools>options is that VFP will create a memo fields for character strings longer than 255 characters.
MSCE, MCSP, Microsoft Channel Partner
Relax, Boss. We will meet the deadline! What? You want to add MORE? What do you mean, Over Budget?
Opinions and comments are the sole responsibility of the sender, and accuracy, correctness, or pertinence is considered coincidental.