Versions Compared

Old Version 11

changes.mady.by.user Former user

Saved on

compared with

New Version 12

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You should get an XML schema similar to the following:

Code Block
 <<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema xmlns="http://www.frevvo.com/database/customers" xmlns:xsd=http://www.w3.org/2001/XMLSchema 
targetNamespace="http://www.frevvo.com/database/customers"> 
  <xsd:element name="customers"> 
    <xsd:complexType> 
      <xsd:sequence> 
        <xsd:element maxOccurs="unbounded" name="row"> 
          <xsd:complexType> 
            <xsd:sequence> 
<xsd:element name="customerId"> <xsd:simpleType> <xsd:restriction base="xsd:string"> <xsd:maxLength value="11"/> </xsd:restriction> </xsd:simpleType> </xsd:element>             <xsd:element minOccurs="0" name="firstnamecustomerId"> 
 <xsd:simpleType> <xsd:restriction base="xsd:string"> <xsd:maxLength value="50"/> </xsd:restriction>              <xsd:simpleType> 
                  <xsd:restriction base="xsd:string"> 
                    <xsd:maxLength value="11"/> 
                  </xsd:restriction> 
                </xsd:simpleType> 
              </xsd:element> 
              <xsd:element minOccurs="0" name="firstname"> 
                <xsd:simpleType> 
                  <xsd:restriction base="xsd:string"> 
                    <xsd:maxLength value="50"/> 
                  </xsd:restriction> 
               </xsd:simpleType> 
              </xsd:element> 
              <xsd:element minOccurs="0" name="lastname"> 
                <xsd:simpleType> 
                  <xsd:restriction base="xsd:string"> 
                    <xsd:maxLength value="50"/> 
                  </xsd:restriction> 
                </xsd:simpleType> </xsd:element> <xsd:element minOccurs="0" name="lastname"> <xsd:simpleType> <xsd:restriction base="xsd:string"> <xsd:maxLength value="50"/> </xsd:restriction> </xsd:simpleType>
              </xsd:element> 
            </xsd:sequence> 
          </xsd:complexType> 
        </xsd:element> 
      </xsd:sequence> 
    </xsd:complexType> 
  </xsd:element> 
</xsd:schema>

Save the schema as an .xsd file in your file system.  You can then [[V4_Data_Sources_and_Schemas#Uploading_a_Schema | upload the schema]] to Live Forms and generate controls from the schema elements that map to your database tables.  If you have multiple queries in your configuration file, you’ll need to generate a schema for each query.

...