Change Visual Foxpro data type in VB

[Terabithia]

I have a need to change the data type on specific fields when i open a Visual Foxpro DB in Visual Basic. I am using the following as a test select string:

select distinct cast(numeric_field as Char(30)),another_field from database_table

This errors out as unrecognized Visual Foxpro, where am I going wrong please?

 

[vb5prgrmr]

I'm not sure that is recognized by VFP but to be sure, goto the VFP forum and ask. I'm sure the people over there will be able to help...



Good Luck

 

[Terabithia]

Thanks!