syntax error

[Soroosh Sanayee]

Hi all
when I want to write all arc-swat i faced to this error:
Syntax Error in INSERT INTO statement: IN, mWriteInputFiles.sol
what the problem is?
thanks a lot

[Jana]

Hi,

I am facing the same problem with the ArcSWAT2012 Version. Till last week I used the 2009 Version and changed now. Unfortunetly my old usersoil table does not work and I have no idea why I always have this error. I filled all fields I do not use with zero and the rest is still the same as for the 2009 version of SWAT.
I would appreciate some help, too and I am sorry I cannot help you :-(

[Liem, Nguyen Duy]

Dear Jana,

Please check table "usersoil" in SWAT2012.mdb carefully.

There are a few new added columns.

Liem

2013/11/7 Jana <frau.jan...@gmail.com>

--
You received this message because you are subscribed to the Google Groups "ArcSWAT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to arcswat+u...@googlegroups.com.
To post to this group, send email to arc...@googlegroups.com.
Visit this group at http://groups.google.com/group/arcswat.
For more options, visit https://groups.google.com/groups/opt_out.

--

Nguyễn Duy Liêm

Bộ môn Tài nguyên & GIS,

Khoa Môi trường & Tài nguyên,

Trường Đại học Nông Lâm TP. HCM.
Địa chỉ: phường Linh Trung, quận Thủ Đức, Tp. HCM, Việt Nam

Website:  http://gis.hcmuaf.edu.vn/ 
Email: nguyen...@gmail.com

          nguyen...@yahoo.com

Mobile: (+84) 0983-613-551

Nguyen Duy Liem

Department of Natural Resources and GIS, 

Faculty of Environment and Natural Resources

Nong Lam University- Ho Chi Minh City.
Address: Linh Trung Ward, Thu Duc District, Ho Chi Minh City, Vietnam.

Website:  http://gis.hcmuaf.edu.vn/  
Email: nguyen...@gmail.com

          nguyen...@yahoo.com

Mobile: (+84) 0983-613-551

[Jana]

Thanks for your answere. I already did that. But that is not the problem. While searching for the problem I tried to run my model with one usersoil that was alredy provided in the table and that also causes me problems. Then SWAT says it is not existent in the database. What can I say. I know it is...

Am Mittwoch, 6. November 2013 21:13:50 UTC+1 schrieb Soroosh Sanayee:

[Madusanka Thilakarathne]

Dear Jana,

Did you find a solution for the problem ?

Please let me know

Thanks

[Jana]

Dear Thilakarathne,

yes, I could solve the problem. First, I Had to fill the new added columns at the end of the table. I remember the data refers to ph values for the usersoils.
Second, I filled the column SEQN with the value 1 and CMPPCT with the value 100. Afterwards it worked without problems. I hope this can help you...

Am Mittwoch, 6. November 2013 21:13:50 UTC+1 schrieb Soroosh Sanayee:

[Madusanka Thilakarathne]

Thank you very much Jana.

[sssun...@gmail.com]

Hello Jana,

 

Did you make any changes to the usersoildefault table?

 

Thanks 

 

[matjaz...@bf.uni-lj.si]

You have empty cells in your soil database. Even if it is just one it will not work. You have to populate all cells with values, even if it is just 0.

[Jiajia Liu]

I have encountered similar problems but with mgt. I have checked and there are no empty cells.I'm wondering what could have been the problem.

Thanks!