object BriefcaseModelService: TBriefcaseModelService OldCreateOrder = True SessionManager = BriefcaseModelServerDataModule.SessionManager ServiceSchema = Schema ServiceDataStreamer = DataStreamer ExportedDataTables = <> Left = 196 Top = 147 Height = 164 Width = 174 object Schema: TDASchema ConnectionManager = BriefcaseModelServerDataModule.ConnectionManager DataDictionary = BriefcaseModelServerDataModule.DataDictionary Datasets = < item Params = <> Statements = < item Connection = 'Northwind' Default = True TargetTable = 'Customers' SQL = 'SELECT '#10' CustomerID, CompanyName, ContactName, ContactTitle, ' + #10' Address, City, Region, PostalCode, Country, Phone, '#10' Fax' + #10' FROM'#10' Customers' StatementType = stSQL ColumnMappings = < item DatasetField = 'CustomerID' TableField = 'CustomerID' end item DatasetField = 'CompanyName' TableField = 'CompanyName' end item DatasetField = 'ContactName' TableField = 'ContactName' end item DatasetField = 'ContactTitle' TableField = 'ContactTitle' end item DatasetField = 'Address' TableField = 'Address' end item DatasetField = 'City' TableField = 'City' end item DatasetField = 'Region' TableField = 'Region' end item DatasetField = 'PostalCode' TableField = 'PostalCode' end item DatasetField = 'Country' TableField = 'Country' end item DatasetField = 'Phone' TableField = 'Phone' end item DatasetField = 'Fax' TableField = 'Fax' end> end> Name = 'Customers' Fields = < item Name = 'CustomerID' DataType = datWideString Size = 5 BlobType = dabtUnknown Required = True DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = True Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'CompanyName' DataType = datWideString Size = 40 BlobType = dabtUnknown Required = True DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'ContactName' DataType = datWideString Size = 30 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'ContactTitle' DataType = datWideString Size = 30 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'Address' DataType = datWideString Size = 60 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'City' DataType = datWideString Size = 15 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'Region' DataType = datWideString Size = 15 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'PostalCode' DataType = datWideString Size = 10 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'Country' DataType = datWideString Size = 15 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'Phone' DataType = datWideString Size = 24 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'Fax' DataType = datWideString Size = 24 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end> BusinessRulesClient.ScriptLanguage = rslPascalScript BusinessRulesServer.ScriptLanguage = rslPascalScript end item Params = <> Statements = < item Connection = 'Northwind' Default = True TargetTable = 'Orders' SQL = 'SELECT '#10' OrderID, CustomerID, EmployeeID, OrderDate, Required' + 'Date, '#10' ShippedDate, ShipVia, Freight, ShipName, ShipAddress,' + ' '#10' ShipCity, ShipRegion, ShipPostalCode, ShipCountry'#10' FROM'#10' ' + ' Orders'#10#10 StatementType = stSQL ColumnMappings = < item DatasetField = 'OrderID' TableField = 'OrderID' end item DatasetField = 'CustomerID' TableField = 'CustomerID' end item DatasetField = 'EmployeeID' TableField = 'EmployeeID' end item DatasetField = 'OrderDate' TableField = 'OrderDate' end item DatasetField = 'RequiredDate' TableField = 'RequiredDate' end item DatasetField = 'ShippedDate' TableField = 'ShippedDate' end item DatasetField = 'ShipVia' TableField = 'ShipVia' end item DatasetField = 'Freight' TableField = 'Freight' end item DatasetField = 'ShipName' TableField = 'ShipName' end item DatasetField = 'ShipAddress' TableField = 'ShipAddress' end item DatasetField = 'ShipCity' TableField = 'ShipCity' end item DatasetField = 'ShipRegion' TableField = 'ShipRegion' end item DatasetField = 'ShipPostalCode' TableField = 'ShipPostalCode' end item DatasetField = 'ShipCountry' TableField = 'ShipCountry' end> end> Name = 'Orders' Fields = < item Name = 'OrderID' DataType = datInteger BlobType = dabtUnknown LogChanges = False Required = True DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = True Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'CustomerID' DataType = datWideString Size = 5 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'EmployeeID' DataType = datInteger BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'OrderDate' DataType = datDateTime BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'RequiredDate' DataType = datDateTime BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'ShippedDate' DataType = datDateTime BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'ShipVia' DataType = datInteger BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'Freight' DataType = datFloat BlobType = dabtUnknown DefaultValue = '0' DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'ShipName' DataType = datWideString Size = 40 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'ShipAddress' DataType = datWideString Size = 60 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'ShipCity' DataType = datWideString Size = 15 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'ShipRegion' DataType = datWideString Size = 15 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'ShipPostalCode' DataType = datWideString Size = 10 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end item Name = 'ShipCountry' DataType = datWideString Size = 15 BlobType = dabtUnknown DisplayWidth = 0 Alignment = taLeftJustify InPrimaryKey = False Calculated = False ServerCalculated = False Lookup = False LookupCache = False end> BusinessRulesClient.ScriptLanguage = rslPascalScript BusinessRulesServer.ScriptLanguage = rslPascalScript end> JoinDataTables = <> UnionDataTables = <> Commands = <> RelationShips = < item Name = 'FK_Orders_Customers' MasterDatasetName = 'Customers' MasterFields = 'CustomerID' DetailDatasetName = 'Orders' DetailFields = 'CustomerID' RelationshipType = rtForeignKey end> UpdateRules = <> Version = 0 Left = 32 Top = 56 end object DataStreamer: TDABinDataStreamer BufferSize = 262144 IsCompatibleV4 = True Left = 32 Top = 8 end end