Syntax Error in INSERT INTO Statement.:IN,mWriteInputFiles.
This feature is not available yet! Please check again in the near future.
Substantial progress has been made in filtration technologies in recent years. New filter media materials, designs and processes have led to filters that are more efficient, reliable, compact and longer lasting.
It is not the neatest or best DB access class I've seen, the NonQuery sub does not return a value, you can read the results from the .Record which will contain a count of records in the table returned by the query string which is quite probably 1 row with 1 column that is an integer and it contains either 1 for row inserted or 0 nothing inserted so you'll have to use that to test success or not.
Close, I solved the (one) problem with using the correct bracketing (((in place of (().The other problem (I only figured out that I had another problem after I changed the bracketing) was that I was trying to subtract from a negative number, the notation would be: 5--18, which bc doesn't handle, so I put the second variable in it's own brackets making the notation 5-(-18) which it does handle.
It is a bad idea to put spaces in table and column names. If you do that, you have to enclose the names in square brackets to make sure the name is considered with the spaces.
As Richard pointed out, don't do it this way. Not only does it lead to syntax issues but it is very easy to hack your db when you write code this way.
I have this error and my code is just below, can someone help me?