Re: [GRASS-user] GRASS 7.2 v.in.ascii error

2017-01-20 Thread Thomas Adams
Martin, Yes; I pretty much figured that out -- 'datetime' worked. I'm slowly catching on... Tom On Fri, Jan 20, 2017 at 7:18 AM, Martin Landa wrote: > Hi, > > 2017-01-20 13:15 GMT+01:00 Thomas Adams : > > Thank you; I did try 'date' and got the same

Re: [GRASS-user] GRASS 7.2 v.in.ascii error

2017-01-20 Thread Martin Landa
Hi, 2017-01-20 13:15 GMT+01:00 Thomas Adams : > Thank you; I did try 'date' and got the same result using the exact dataset. well, 'date' is also SQL reserved word :-) [1] Ma [1] http://developer.mimer.se/validator/sql-reserved-words.tml -- Martin Landa

Re: [GRASS-user] GRASS 7.2 v.in.ascii error

2017-01-20 Thread Thomas Adams
Helmut, Thank you; I did try 'date' and got the same result using the exact dataset. After sending out the email (thinking GRASS *might* be choking on the number of columns), I reduced the number of columns and re-ordered them (thinking that maybe the ID ought to come first -- also recognizing

Re: [GRASS-user] GRASS 7.2 v.in.ascii error

2017-01-19 Thread Helmut Kudrnovsky
>SQL parser error (syntax error, unexpected TIME, expecting >NAME processing 'time') in statement: Could it be that time is a SQL reserved word/key? Try another word instead of 'time'. HTH Helmut - best regards Helmut -- View this message in context: