2. ASPRunnerPro General questions
  3. [SOLVED]  ERROR: Cannot use empty object or column names.
This topic is locked
[SOLVED]

 ERROR: Cannot use empty object or column names.

 		12/11/2004 5:51:18 AM
ASPRunnerPro General questions
D
 davorink author

Hi to everybody.

I have a problem with master-detail asp. When I exchanged between detail and master table, the system return error:
Error number -2147217900

Error description [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot

use empty object or column names. Use a single space if

necessary.

URL /Ales/test3/_MaterialAnalitikaKlasif_list.asp

SQL query select [leto], [klasif], [naziv], [nabaVrednost],

[prodVrednost] From [dbo].[_MaterialAnalitikaKlasif] where

[klasif] = '160 '
The version of the ASPRuner is the 3.1a and the database is MS SQL and SQL query works correctly in Query Analyzer.

What an idea?!
admin 12/11/2004

Davorin,
this SQL query looks good.
Please zip and send the whole content of ASPRunnerPro output folder with subfolders along with SQL script that creates tablesin SQL server to support@xlinesoft.com for investigation.
D
 		davorink author 12/11/2004

Ups, this master and detail table they are views!

It that reason for the error?
admin 12/14/2004

Davorin,
I sent you a link to ASPRunenrPro update that fixes the issue. Please check your personal email.
This error happened when Master table didn't have any key column defined.