Hi,
how you have specified the database table name
i just tested the following and found this to be working absolutly fine
ARSystem.aradmin.arschema
it has to be in the following format in SQL Server.
<databasename>.<username>.<tablenmae>
Thanks
-Sam
On 5/5/06, Antonio Acosta <[EMAIL PROTECTED]> wrote:
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
__20060125_______________________This posting was submitted with HTML in it___
