How to write the information in an SQL database table?

[jiaj]

Hi, I have a probelm on IPCC using DB WRITE command when trying to write the some information of caller into an SQL table. For example, I have two fields on the TEST table, SessionID and CallerID. After I use DB Write command on scripting, I found there was no any information inserted into the table.

Here is my SQL command used:

INSERT TEST (SessionID,CallerID) Values ('12345','AAAAA')

What's wrong with the DB Write command?

[aslam]

Hi,

I think you forgot to put in the INTO key word, the SQL insert statement should look like

INSERT INTO table-1 [(column-list)] VALUES (value-list)

so in your case it would be

INSERT INTO TEST [SessionID,CallerID] VALUES ('12345','AAAAA')

Moreover, you can test if it works from this step itself. Click the Test tab, in the 'SQL Command entered' field enter the sql command and click execute.

Check the result in the no. of Rows altered. This will confirm whether your SQL statements are working ot not.

Hope that helps.

[jiaj]

Thanks for your reply. The keyword of INTO is not an issue. I finally figured out. It is because of the SQL-2000 and SQL 6.0 /6.5's compatibility level issue. I used SQL-2000 SERVER