I’m having a little trouble mixing data types in my ODBC insert. I know the connection and the table names are set up correctly because I can add hard values in the code and it inserts just fine. When I try to add my variables in the Insert string I am having trouble with the syntax. How do I mix string and double variables in the same insert statement?
There will be people advocating using using the SQLPrepareStatement in 3 … 2 … 1 … but I do enjoy pasting in the value of the variable ‘sql’ into PGAdmin for PostgreSQL and testing my SQL statement.