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/
>
>
--
View this message in context:
http://www.nabble.com/Join-Table-for-Query---Then-Sort-tp14605276s22836p14605918.html
Sent from the Active4D mailing list archive at Nabble.com.
_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
