[Date Prev][Date Next][Thread Prev][Thread Next]
- Subject: Re: luasql.odbc and SQL Server 2005
- From: Ralph Hempel <rhempel@...>
- Date: Fri, 11 Jan 2008 12:32:24 -0500
Robert Raschke wrote:
The sys.tables table in SQL Server contains fields with pretty
SQLServer specific types: datetime and bit. It also has nchar and
nvarchar, which I am unsure whether LuaSQL handles just now.
Thanks Robert. I should mention also (nice to see how there's
always one more piece to the puzzle) that even the standard
tablesin the database give the exception on line 163.
You could change your query to cast every field explicitly (slightly tedious).
I'll read up on doing that. I'm not too familiar with SQL
Or you could use ADO via LuaCOM directly:
And I was really hoping to avoid this, but if it's the only way....
Thanks for the pointers and help.