Jan Dahlstrom
December 19th, 2000, 10:37 AM
Hi!
I got the error -2147217900 and an errormessage "No value given for one or more required parameters" when i run my SQL Query. MSN refers to it as "underlying OLE and OLEDB provider error"
The SQL query involves 3 tables from wich i want to select fields.
If i use "*" in my select statement the query runs ok, but if i select some fields in the select-statement from all tables is there one field i can't use. It is an ordinary textfield, not connected to any other field. For the moment i do not have any data in this field.
If i take away this field it will work.
Why can't i use this field in the select statement?
Thanks!
"SELECT " & _
"CatalogCateg.CatalogID, CatalogCateg.CategLev, CatalogCateg.ProdID AS ProduktID, " & _
"Category.Level, Category.CatName, Category.CatDesc, Category.Template, " & _
"Products.ProdID, Products.PName, Products.Model, " & _
"Products.PDesc, Products.PCode, Products.Price1, Products.Price2, Products.Price3, Products.Sizes, " & _
"Products.Unit, Products.Quantity, Products.OrdQuant, Products.Weight, " & _
"Products.Color, Products.Xtra1, Products.Xtra2, Products.Xtra3, Products.Xtra4, Products.Pic, " & _
"Products.Quantity, Products.OrdQuant, Products.Weight "
" From " & _
"( Products RIGHT JOIN CatalogCateg ON " & _
"Products.ProdID = CatalogCateg.ProdID) " & _
" LEFT JOIN Category ON CatalogCateg.CategLev = Category.Level "
I got the error -2147217900 and an errormessage "No value given for one or more required parameters" when i run my SQL Query. MSN refers to it as "underlying OLE and OLEDB provider error"
The SQL query involves 3 tables from wich i want to select fields.
If i use "*" in my select statement the query runs ok, but if i select some fields in the select-statement from all tables is there one field i can't use. It is an ordinary textfield, not connected to any other field. For the moment i do not have any data in this field.
If i take away this field it will work.
Why can't i use this field in the select statement?
Thanks!
"SELECT " & _
"CatalogCateg.CatalogID, CatalogCateg.CategLev, CatalogCateg.ProdID AS ProduktID, " & _
"Category.Level, Category.CatName, Category.CatDesc, Category.Template, " & _
"Products.ProdID, Products.PName, Products.Model, " & _
"Products.PDesc, Products.PCode, Products.Price1, Products.Price2, Products.Price3, Products.Sizes, " & _
"Products.Unit, Products.Quantity, Products.OrdQuant, Products.Weight, " & _
"Products.Color, Products.Xtra1, Products.Xtra2, Products.Xtra3, Products.Xtra4, Products.Pic, " & _
"Products.Quantity, Products.OrdQuant, Products.Weight "
" From " & _
"( Products RIGHT JOIN CatalogCateg ON " & _
"Products.ProdID = CatalogCateg.ProdID) " & _
" LEFT JOIN Category ON CatalogCateg.CategLev = Category.Level "