Database Wizard SQL INSERT statement

Architect & Flows
1

Is it possible to insert data into database using database wizardb in IRD?
I use database wizard type of query, and following sql script:

INSERT INTO dbo.IVR_steps 
Values(date1,time1,nodename1)

it works fine in query analyser, but in strategy it just do nothing. I can’t see any added rows or any sql activity in DBS log.
It’s MSSQL 2000.

2

What if you try insert with constants values (not variables) like
insert into customers values (“Customer”,22)

3

result of

INSERT INTO dbo.IVR_steps 
Values ("date","time","nodename")

still the same. no activity

4

When you say it works fine in Query Analyser, is that running on the same machine that is running URS ? or is it running directly on the database server?

Can you get the strategy to run a select query on the database?

1 Like
5
When you say it works fine in Query Analyser, is that running on the same machine that is running URS ?
Query analyser is on seperate machine from SQL and URS. But what is the point of this question? Isn't it dataserver (not URS) should be responsible for database operations? btw dataserver is on the same machine where I tried Query Analyser.
Can you get the strategy to run a select query on the database?
Damn, it also does not work. Return empty result...
6

Does URS has a connection to the DAP?

7
Query analyser is on seperate machine from SQL and URS. But what is the point of this question? Isn't it dataserver (not URS) should be responsible for database operations?
If query analyser is on the same server as the database, then there is no network involved, so client and server should be able to talk to each other. When you use a strategy, URS makes the request to the database via the dbserver (DAP). The DAP converts the URS request from T-Lib to the correct SQL for your database, in this case MSSQL.

Can you connect to the database using ODBC test from the client?

As Cav says “Does URS has a connection to the DAP?” What do the logs here say?

1 Like
8

Thanks a lot! This was what I loose sight of. Now it’s works perfectly.

1 Like
9

Oh, I’m was to fast to exult…
It works perfectly with constants, but variables are not working.
If al the three values are constatnts, insret occurs, if even one of values is variable, no insert occurs. Still digging.

10

Would it not be easier to use a stored procedure for the inserts?

That way you coud use your variables.

2 Likes
11

Yes, stored procedure did the job. But i’ts definetely not easier.