Writing data to external database SCCS 5

[mikeyb123]

Guys,

I need to be able to write info to a external database.

Now I know I can use HDX to do this, but I can't make head or tail of the manual.....

I've configured the conenctivity using the DB integration wizard. Do I need a TAPI Server?

As for the scripting I've included:

ASSIGN AGE OF CALL TO HDX_WAIT
SEND INFO HDX_App_ID CLID, HDX_WAIT

but the database doesn't update.....

It's not getting any smarter out there. You have to come to terms with stupidity, and make it work for you.

 

[mikeyb123]

I've almost cracked this now...

I can get a access database to update with a text string...

my script looks like :

ASSIGN 1 TO SQL_Statement_cv
ASSIGN CLID TO HDXCLID
ASSIGN AGE OF CALL TO HDXWAIT
SEND INFO HDX_App_ID SQL_Statement_cv, HDXCLID, HDXWAIT


the sql statement is as follows:

insert into hdx (clid, wait) values ('hdxclid', 'hdxwait')

from this teh databse gets updated with hdxclid and hdxwait but not with the values....

any clues????????

It's not getting any smarter out there. You have to come to terms with stupidity, and make it work for you.