Specify remote URLs for Remote operations.
dbQP Abbr: ru
Version: Gold
Namespace:
TornadoVersion: Gold
Assembly: Tornado (in Tornado.dll) Version: 12.6.0.9 (1.0.0.0)
Syntax
| C# |
|---|
public string dbRemoteURL { get; set; } |
| Visual Basic (Declaration) |
|---|
Public Property dbRemoteURL As String |
Field Value
Obj.dbRemoteURL = "URL1;EncryptKey1| URL2;EncryptKey2|...|ID=True "| Keyword | Description |
|---|---|
| URL | RemoteURL |
| EncryptKey | Key used to Decrypt the file encrypted by ASPdbConvert. Key cannot have leading or trailing spaces and will be trimmed. |
| ID | True|False(Def). Add an ID Column to identify the source, you can then use a lookup to display the ID in your preferred format. |
Examples
<script language="VB" runat="server"> Sub Page_Load(Src As Object, E As EventArgs) Dim Rm As New Tornado.z With Rm .dbUnit = 1 .dbRemoteURL = "http://localhost/tornado/DB/sales1.txt | " & _ "http://localhost/tornado/DB/sales2.txt" .ASPdbRemoteDataCollection("Sales") '------- Process Consolidated Data - Plot a Cluster Chart -------- .dbUnit = "95" .dbSkin = 1 .dbType = "Text" .dbProvider = "OLEDB" .dbDSN = "/tornado/scratch" .dbPageSize = -1 .dbSQL = "Select * From [[RemoteTable]]" .dbTextHolder = "Title=Tornado Demo - Remote Data Collection|" & _ "sub=Consolidate the two URLs into a Csv table" .ASPdbNET() End With End Sub </script>