I have a memo field in an ACCES database (up to 650000 characters).
I have set up an adapter and a dataset for the database. I have a datagrid
bound to the dataset. There are 4 fields in the datatable. The "Codetext"
field which should be the memo only gets the first 50 characters from the
database.
Is it the schema generated by Visual Basic ? Here is the schema:
<?xml version="1.0" standalone="yes" ?>
- <xs:schema id="DsCodeKeeper"
targetNamespace="http://www.tempuri.org/DsCodeKeeper.xsd"
xmlns:mstns="http://www.tempuri.org/DsCodeKeeper.xsd"
xmlns="http://www.tempuri.org/DsCodeKeeper.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
attributeFormDefault="qualified" elementFormDefault="qualified">
- <xs:element name="DsCodeKeeper" msdata:IsDataSet="true">
- <xs:complexType>
- <xs:choice maxOccurs="unbounded">
- <xs:element name="SourceCode">
- <xs:complexType>
- <xs:sequence>
<xs:element name="Category" type="xs:string" minOccurs="0" />
<xs:element name="CodeText" type="xs:string" minOccurs="0" />
<xs:element name="Creation" type="xs:dateTime" minOccurs="0" />
<xs:element name="Description" type="xs:string" minOccurs="0" />
<xs:element name="ID" msdata:AutoIncrement="true" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
- <xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:SourceCode" />
<xs:field xpath="mstns:ID" />
</xs:unique>
</xs:element>
</xs:schema>