Database schema 1

[Shazza]

I have been asked to write some Crystal reports from our Action Request System. Problem is, the database tables are called T155, T155C536870922 etc, and the field names are just as bad ...

Does anybody have a database schema that I can look at, or give me any help.

Thanks

 

[chrisfo]

If you are using the Remedy ODBC driver to connect to your database, then you should not have a problem. Also, there are SQL views in your database which refer to the internal table/field names (T39 etc.) by the more sensible names you have given them.

I use crystal 7 with Remedy 4.03 and 4.52 servers and this works fine.

Chris

 

[RmdyJoe]

run this against the database:

select name, schemaId from arschema

and you will get the T-table name


name is the form name and schema id is the (T) name.

(EX.. User T1)
(EX.. Group T2)

then print that out and you will never be lost


feel free to let me know if you need help.