SWAT Input Table Error: Syntax Error?

[Chris Hickey]

I receive the error message while creating the input tables:


Syntax Error in INSERT INTO statement: IN, mWriteInputFiles.wgn

--------

So, I checked the databases under Edit Swat Inputs.  Under the weather files database I receive this error for every one of the 29 user-defined weather stations that I input into the SWAT2012 mdb file.

An error box with this message appears when I click on the weather station:

Conversions from type 'DBNull' to type 'String' is not valid

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.
   at Microsoft.VisualBasic.CompilerServices.Conversions.ToString(Object Value)
   at SWAT_InputFileEdit.frmUserWgnEdit.lstWeather_SelectedValueChanged(Object sender, EventArgs e)
   at System.Windows.Forms.ListControl.OnSelectedValueChanged(EventArgs e)
   at System.Windows.Forms.ListBox.OnSelectedValueChanged(EventArgs e)
   at System.Windows.Forms.ListBox.OnSelectedIndexChanged(EventArgs e)
   at System.Windows.Forms.ListBox.WmReflectCommand(Message& m)
   at System.Windows.Forms.ListBox.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


I do not have any values input for 1/2 hour rainfall rate.

Any ideas?

[Chris Hickey]

The .wgn table is still being 'built' as says in the dialogue box with the in/complete tables.  How long should this all take?

[Emad M]

Hi Chris

I'm having the same problem.

I'm stuck on this step.

Could I possibly ask you a favor to guide me through this issue?!

Emad

[hamish.p...@googlemail.com]

Chris, I had the "Syntax Error in INSERT INTO statement: IN, mWriteInputFiles.wgn" error and it turned out to be because I had blank fields in the WGN_user table in SWAT2012.mdb (I'd imported this table from the output created by WGNmaker4.1.xls). The solution was to replace the blank fields with -99.

[Neliswa Pretty]

I have the same problem were you able to solve it using the -99.0 because for me it still does not work

[ayfer ozdemir]

Hello,

I have the same problem, Could you solve this problem

16 Eylül 2013 Pazartesi tarihinde saat 17:33:02 UTC+3 itibarıyla ahokie...@gmail.com şunları yazdı:

[Aishu Abi]

Hai everyone!!! I did face the same issue. So I went and checked my database. There were no blank fields. But still, I face the same issue. Can someone help me?

[Zayd A Dagari]

Alhamdulillah! I had thesame problem and your solution worked perfectly. thnks

[IMUWAHEN AIGBEDION]

Please what is the solution for this error.

Please share.

Imuwahen

[IMUWAHEN AIGBEDION]

Yeah, solution to this error