Tornado API Library - V12.30.08

z.dbRemoteURL Property

Specify remote URLs for Remote operations.

Product Version

Gold
[VisualBasic]
PublicPropertydbRemoteURLAsString
[C#]
publicstringdbRemoteURL{set;}

Property Value

Obj.dbRemoteURL = "URL1;EncryptKey1| URL2;EncryptKey2|...|ID=True "

KeywordDescription
URLRemoteURL
EncryptKeyKey used to Decrypt the file encrypted by ASPdbConvert. Key cannot have leading or trailing spaces and will be trimmed.
IDTrue|False(Def). Add an ID Column to identify the source, you can then use a lookup to display the ID in your preferred format.

QuickProp Keyword Abbreviation

ru

Example

<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>

See Also

z Class | Tornado Namespace | ASPdbRemote | ASPdbRemoteDataCollection | Special Topic - Remote Data