Dataflux Conditional Expression with ODBC connection

[Vinz867]

Hi all,

I am new in Dataflux and I am trying to figure out how to do a conditional logic with an ODBC connection using multiple columns from the external data source. There are multiple columns in the RULES table and I need to use them in a conditional logic. 

This is what I have so far. 

static dbconnection db1
static dbstatement stmt1
dbcursor curs1
boolean retval1

 if isnull(db1) then
   db1 =  dbconnect('DSN=MS Access Database;DFXTYPE=ODBC')
if isnull(stmt1) then
begin
   stmt1 = db1.prepare("SELECT * FROM "RULES" WHERE ISALPHA = ?")
   stmt1.setparaminfo(0, 'string', 5)
end

 
<<missing comparison>>

 
 
if retval1 == true then
return true
else
return false

[VincentRejany]

Hi

I could try to write the code for you, but I doubt it will work directly as I won't be able to test it with your RULES table.
As an example the following code lets you get a list of tables in a particular database.
// Set Expression node to "Generate row when no parent is specified" to true
//Pre Expression
string DSN
DSN="DataFlux Sample"
string connectStr
//Preparing the connection string
connectStr = "DSN=" & DSN
DBConnection dbConn
dbConn = dbConnect( connectStr )

string tablename
string datapath
string tcatalog
string tabletype
DBCursor cursTables

//Retrieve table information in a cursor
cursTables = dbConn.tablelist();
//Iterate through the cursor
while( cursTables.next() )
begin
datapath = cursTables.valuestring(0); tcatalog =
cursTables.valuestring(1); tablename = cursTables.valuestring(2);
tabletype = cursTables.valuestring(3)
pushrow()
end
cursTables.release();

//Expression
seteof()
return false