Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

SQL queries on table names containing dot(.) (AREV Specific)

At 06 AUG 2002 07:21:37AM Deepak Chandra wrote:

Hi, 

 We are unable to run SQL queries on certain tables containing period in their names(for eg AR.PINDATA).It gives an error message as

("" is missing from the dictionary of the "AR.PINDATA" table).Is there any workaround?Any comments?

Thanks & Regards,

Deepak Chandra.

At 06 AUG 2002 07:48AM Don Miller - C3 Inc. wrote:

SQL in AREV requires:

Table names should NOT contain Dots

Dictionary field names also should NOT contain Dots

HTH

Don Miller

C3 Inc.

At 06 AUG 2002 08:06AM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:

The SQL standard dictates that the period is used to separate elements within a fully qualifed column definition, for example owner.table.column so you cannot use periods in a table name with SQL. The fix is to alias the table and columns and report against these.

The Sprezzatura Group

World Leaders in all things RevSoft

View this thread on the forum...