[RICK L. PRITCHETT]

So Jim the only way to pass a variable would be to use a stored procedure

[RICK L. PRITCHETT]

The last line of the Query has a like.

[RICK L. PRITCHETT]

The setup in the screenshot gets me the desired results.  Is there no way to pass a value to the like statement?

Attachments:

You must be logged in to view attached files.

[RICK L. PRITCHETT]

Using Advanced Database Lookup

[RICK L. PRITCHETT]

Thanks for your assistance once again Jim.

Tcl code calling look up.

set values [dblookup “sofhirSearchTable.tbl” “SOF”]
echo “values $values”

Attached screenshot of the DB table setup.

 

Attachments:

You must be logged in to view attached files.

[RICK L. PRITCHETT]

Can the db lookup handle multiple values returned?

[RICK L. PRITCHETT]

I know a DB table lookup would normally return one value.  Could a db table lookup be used to return multiple lines if needed

[RICK L. PRITCHETT]

Hi  Jim,

Reading the file for information such as the password and username might work. I see the PW is encrypted in the file. Is there a way to decrypt it, or can it be used as is?

[RICK L. PRITCHETT]

I wanted to use a tcl script to query my external DB and return the results to compare against a lookup table. I know we can do that but wanted not to use the pw in the script.

[RICK L. PRITCHETT]

Would the sqliterc be used by a tcl script?

[RICK L. PRITCHETT]

Can you share the contents of that file?

[RICK L. PRITCHETT]

If on Linux and using “load sqlite3-regex.so” do we still need to enable the load option?

[RICK L. PRITCHETT]

On another note, I was trying to access a smat file, not the error db in this case.

In the documentation, I found the  Smat API.  Does anyone have an example where the call is in a standalone TCL proc?  I keep getting an error that the directory or file does not exist.

And in the example below I used -e ASCII in place of user_defined to open my file. I used this since that is what is in my netconfig.  Is this the correct usage?

set smatdbTest [smatdbopen test.smatdb user_defined]

[RICK L. PRITCHETT]

Thanks, guys. I got it working. Jim K. Let us know how the PostgreSQL project goes.

[RICK L. PRITCHETT]

Using SQL. I thought we could use a join in the newer versions.

[Author]

Replies