Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why String from a DataSet was translated in Memo in Vfp
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00772573
Message ID:
00772614
Views:
8
Thank's very very mutch Cathi it's working well now!!!
Rock

>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
Previous
Reply
Map
View

Click here to load this message in the networking platform