Using SQL command to insert static values

[OliverR]

Hi,

I'm trying to insert static values into a session by pressing a button. The idea is that the last line of the exported csv file will contain a line like for example:

*****END OF FILE*****
​

So I added a button to my form and used the form logic to have it execute the following SQL when it's clicked:

INSERT INTO Session1 (Field1) VALUES ("*****END OF FILE*****")
​

But that doesn't seem to be working. Is this not possible in TracerPlus, or am I doing something wrong?

Thanks!

 

[Fahim Ali]

Oliver,

I believe there is a syntax error with your statement. Instead of using double quotes, use single quotes. Your statement should look like the following:

INSERT INTO Session1 (Field1) VALUES ('*****END OF FILE*****')
​

You can see the changes as the red marks above.

 

[OliverR]

Thanks Fahim, that did the trick!