Hello listers, ARS 6.0.3 Windows XP SP2 SQL 2000 SP4
When I try to create a View form, based on a table defined in the same Database used by the ARSystem, and click on the load button, I getting the following error : Requested database table not found. Please check the spelling (table name is case-sensitive).(ARERR 481) I can´t see the column of the table selected to create the Form. This table used is not part of the ARSystem structure, but resides in the same database. When I repeat the process to create a View Form and select form example the arschema table, when I press the load botton I get the columns of the mentioned table and I able to create the View Form. Turning on the sql log, I can see that in the first scenario the ARSystem run a sql statement like this: */ SELECT id from sysobjects where name = 'Tabla1' but nothing else happens However when is used the arschema or any other table or view that is part of the arsystem I obtain somtehig like this: */SELECT id from sysobjects where name = 'arschema' */SELECT count(*) from syscolumns where id = 1397580017 */SELECT name,xtype,length,xprec,xscale from syscolumns where id = 1397580017 If I run the firts sql statement (*/ SELECT id from sysobjects where name = 'Tabla1') with the sql client I can see too the expected result. I´ve already check all the requirements for the table in order to be used to create a View form (Dev_basic Document). What else I need to check to crate the View Form properly? Any hints will be really appreciate. Antonio Acosta Consultant Caracas - Venezuela _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
