Rock,

Prior to filling your DataSet with the DataAdapter, make sure you set the DataAdpater's MissingSchemaAction property to MissingSchemaAction.AddWithKey.

da_orders.MissingSchemaAction = MissingSchemaAction.AddWithKey;
da_orders.Fill(ds,"Orders");

This is required to write out all the length information in the schema.

>Hi Cathi,
>
>I use the XmlAdapter of Vfp 8.0 but when i check the Schema in the xml before created the Table. it was not specify at all the lenght of the string field in the dataset. I supposed that is the problem....
>
>Do you have a idea why or how can i Specify the lenght of the string directly in the schema of the dataset ?
>
>Rock
>
>
>>Rock,
>>
>>How are you converting the DataSet to a VFP Table? If you are using WriteXML, then be sure to use the XMLWriteMode.WriteSchema. If VFP can not determine the length of a string then it will make it an memo field. Make sure you use VFP 8 also.
>>
>>>Hi EveryBody,
>>>
>>>I Try to convert a .Net DataSet into a Table in Vfp but it Generate
>>>a Memo Field for all Caracter field.
>>>Do you know how i can specify the length of a string in the DataSet Schema to avoid this problem ?
>>>
>>>Thank's in Advance...
>>>Rock