Archives of the TeradataForum
Message Posted: Tue, 19 Nov 2002 @ 18:16:26 GMT
Here's an example of how its done with Visual Basic 6.0. I imagine the same thing could be applied to .net, though I've never tried. The connection string properties can be adjusted to suit your needs. This code fills a listbox or combobox (must be below 32767 records) with data elements obtained from the line:
Set rs = adoConnectionTeradata.Execute ("SQL Code").
The "SQL Code" area is a nice place to execute macros on Teradata, rather than write all your SQL code in VB, especially if you have variables you want to pass from your Web page.
Dim adoConnectionTeradata As ADODB.Connection
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|