INSERT INTO Local_EPM_RETAIL
('AK',2001,1,23128.65,206108.43,11.22,20214.1,208499.68,9.7,6260.39,88762.7,7.05,2360.91,17664.85,13.36,51964.04,521035.66,9.97,'F');
I'm converting a VB.NET program into C#. The problem is it deals with SQL and Databases, and I have never really worked with them before. I'm haphazardly stepping through this shoddily written VB program with no documentation while trying to find C# equivalents of commands in VB.NET That I've never seen before.
I've gotten through most of it, however; but one problem still plagues me. Whenever the program issues the
ADODB.Connection.Execute(SQL, out objout, -1)
command, (SQL Being the string "INSERT INTO Local_EPM_RETAIL
('AK',2001,1,23128.65,206108.43,11.22,20214.1,208499.68,9.7,6260.39,88762.7,7.05,2360.91,17664.85,13.36,51964.04,521035.66,9.97,'F');"), it gives me a Syntax error.
I honestly don't know anything about what it's outputting, where it goes, what the table structure is, or anything at all really. All I know is, I was given this code, and I'm trying my best to fix it. If you could please help me, I would really appreciate it.