Using SQL command to insert static values

OliverR

Member
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

New Member
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.
 
Top