Can someone please please answer the question, does
sqlite3_column_decltype NOT return the column type for Views? I don't
see how this wouldn't considered as a major bug.
EzTools Support wrote:
I found out why Views were returning all NULLs. I have made a
modified version of sqlite3_exec. Mine checks for NULL returned from
sqlite3_column_decltype, for which Sqlite3 now returns NULL. Am I
right that this is so? My COM wrapper depends on having the column
data types returned for Views. Can you please make it work again, as
this is vital.
thanks
-brett
EzTools Support wrote:
Hello. Can someone please help with this issue. It may turn out to
be a bug in Sqlite 3.
I have the following fairly basic SQL View that works fine with
Sqlite 2.x:
CREATE VIEW Invoices AS
SELECT Customers.CustomerID, Customers.CompanyName,Orders.OrderID,
OrderDetails.ProductID, OrderDetails.Quantity FROM Customers INNER
JOIN Orders ON Customers.CustomerID = Orders.CustomerID INNER JOIN
OrderDetails ON Orders.OrderID = OrderDetails.OrderID
When I create and run this view in 3.x, I get all of the rows back,
but all values are NULL!
If I run the SELECT statement apart from the view, it I get the data
back fine. But if I select * FROM Invoices, I get all of the rows
back, but all values are NULL.
Another interesting thing is that when selecting from the View, the
column names are without the table prefix. That is, CustomerID,
CompanyName, OrderID, et. But if I select from the tables directly,
the column names have the table prefix, Customers.CustomerID,
Customers.CompanyName, Orders.OrderID
I have put the database up on my website here (Zip file):
www.eztools-software.com/downloads/northwind.zip
This is happening in all version 3.0.5-3.0.7. Can someone please
download this DB and investigate.
If you want to test the same view and data with a v2.x database, you
can get the SqlitePlus28 download from here:
www.eztools-software.com/downloads/sqliteplus.exe
TIA
-Brett Goodman
