Jason,
If you have access to the actual 4D structure you can look at the
relation properties by double-clicking on the relation line and
examining how the "definition" is configured.
WRT what they are, etc., I'd recommend reading the docs.
A good place to start is www.4d.com. Type "Automatic Relations" in the
search box and check out some of the results.
http://www.4d.com/4ddoc2004/CMU/CMU10059.HTM
hth,
Brad
Jason Tupeck wrote:
I have absolutely no idea. I know next to nothing about 4D itself, but am
piecing together a web app based on a client server application that was
built years ago.
How would I find out about automatic relations, how can I turn them 'on' and
what would the potential impact of this be?
Mike Erickson-2 wrote:
Jason
Do you have AUTOMATIC RELATIONS turned on?
Mike Erickson
Automated Solutions Group
On Jan 3, 2008, at 12:59 PM, Jason Tupeck wrote:
I am having issues with joining two tables in a query and then
sorting the
results based on the second table. I want to query both the
[SubCatergory2Products] and [Sub Categories] tables, joined by the
SubCategory ID and ID fields respectively. The only info provided
is the
CategoryID number (as seen below).
Here is the code:
query([SubCategory2Products];[SubCategory2Products]CategoryID =
$addCatID;*)
query([Sub Categories];&;[Sub Categories]ID =
[SubCategory2Products]SubCategoryID)
order by([Sub Categories];[Sub Categories]Code;>)
distinct values([SubCategory2Products]SubCategoryID;$arrSubCatID)
for ($i;1;size of array ($arrSubCatID))
query([Sub Categories];[Sub Categories]ID =
$arrSubCatID{$i};*)
query([Sub Categories];&;[Sub Categories]Inactive #
True)
$old_char := char(39)
$addSubCatCode := replace string([Sub
Categories]Code;$old_char;"")
$addSubCatName := replace string([Sub
Categories]Name;$old_char;"")
write("obj.options[obj.options.length] = new
Option('"+$addSubCatCode + " - " +
$addSubCatName+"','"+$arrSubCatID{$i}+"');")
end for
It would seem that the problem is with the ORDER BY line...no matter
what I
do there, it changes nothing. I am confused as to how to get this
to work
and know I must be doing something wrong in here somewhere, but
there are no
errors given when the code runs, it just doesn't sort as I expect it
to. Am
I going about this the wrong way? Any help would be much appreciated.
Sincerely,
Jason Tupeck
InterTech USA, Inc.
6070 Industrial Road
Missoula, MT 59808-8412
Phone: 406.549.8998 x231
Toll-Free: 800.291.6517 x231
Fax: 406.721.7991
Web: http://www.intertech-usa.com
Confidentiality Note: The information contained in this email and
document(s) attached are for the exclusive use of the addressee and
may contain confidential, privileged and non-disclosable information
and is covered by the Electronic Communications Privacy Act, 18
U.S.C. 2510-2521. If the recipient of this email is not the
addressee, such recipient is strictly prohibited from reading,
photocopying, distributing or otherwise using this email or its
contents in any way.
_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
