Joins are constrained by the keys available in the files. Click Here to join Tek-Tips and talk with other members! Best regards Cosmark RE: The most straightforward way of dealing with this reality without imposing some really stupid data model on the SQL user is to define a table for each record type. We have been working with big arrays and multiple record definitions and we are satisfied with the performance. By joining you are opting in to receive e-mail.

Uploader: Sharan
Date Added: 16 January 2010
File Size: 45.72 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 90834
Price: Free* [*Free Regsitration Required]

CFMX 7 Liant Relativity connection – Coldfusion Database Access

We have been using Relativity for a number of years, currently on version 3. We have been working with big arrays and multiple relaitvity definitions and we are satisfied with the performance.

As an example assume a very simple example: Please contact your system administrator for assistance. SELECT statements used in the application; it is unclear from your description whether your client has access to these.

Post Your Answer Relatifity By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

Client-Server is appropriate to reduce network traffic: In regards to the issues of arrays, redefinitions and multiple record definitions it is a matter of finding the best solution to meet your needs as the relational model does not support these structures.


Poorly constructed joins can cause any database to slow to a crawl.

Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. In my opinion, it is best to set this up as two columns in the table i.

liang I am very seriously considering recommending and going ahead with Relativity by Liant in order to use MS Access and other Microsoft programs but after reading previous comments in this forum about this product I am wondering whether there relativigy any other products in the market today to consider.

Cosmark, Unfortunately if the company’s approach is as you have described then Relativiy is your only hope. Liant support is an email away see above or our web site.

I hope this gives you the scope of work. Liant also has a CEO who takes customer feedback quite seriously.

Here is the Connection String you are looking for using your example. Can any one help me with this plz?

Liant Relativity v Data Manager | Slimware Utilities

Overall Relativity does the job that you want it to do, just do not push it, and do not expect implementing it to be the easiest thing you have ever done. Relativity is a forward-only driver. Joins are constrained by the keys available in the files. Thanks for your response Richard. Red Flag This Post Please let us know here why this post is inappropriate. I consider the micro redefinition to be where one field in a record is used for two purposes depending on a flag somewhere else in the record.


Client-Server does imply a bit more administrative work. What happens if you try: Jun 15 ’12 at The relational model does not have an analog multiple row types?! It’s easy to join and it’s free. I have been asked by a company which uses software developed in the early 80’s in RM Cobol and still uses the system in its original black-and-white form to “bring their system to the new century”.

Liant Relativity v12.04 Data Manager

What they want, if possible, is to maintain for as long as they can their present arrangement but with enhanced functionality as offered by new programs such as the MS suite Access, Excel, PowerPoint etc. Register now while it’s still free! Thanks again, Cosmark RE: They do not have in-house support for RM Cobol they rely on relativty Software houses for support, which is expensive but they have in-house knowledge in database design and development in Relativitu Access.

See 6 above multiple record types for large scale, multiple record type redefinition.