Tuesday, March 6, 2012

"Failed to get schema!"

I have entered an sql demand in the wizard of a grid view for a table (on a form). But i cannot go any further because it gives me the message ... "Failed to get schema!"...

A frined came over by and with him, it worked...

the sql is correct, it calculates sums based on the dates of another table... let me show it:


INSERT INTO SumeU
(ID_var_u, s_x, s_y, s_xx, s_yy, s_xy)
SELECT ID_var_u, SUM(val_x) AS sx, SUM(val_y) AS sy, SUM(val_x * val_x) AS sxx, SUM(val_y * val_y) AS syy, SUM(val_x * val_y) AS sxy
FROM DateU
GROUP BY ID_var_u

"ID_var_u" connects the two tables to another one called "model" (where it is primary key)

Now... please help me... again!

Sounds like a security issue, I'll move your question to a SQL forum for a better answer...
|||

The message you mentioned does not resemble any SQL Server error message. Is that copied verbatim or from memory? Can you post the actual error message?

Thanks
Laurentiu

No comments:

Post a Comment