02. How to create a Main Table, EDT, relationship, indexes, and methods

[@mostaphasaid7250]

Thank you very much for your valuable videos 🤩🤩

[@NeerajKumar-gq9fq]

Your great work is always appriciated. This series will help us to understand the basics. Your every session is very useful.

[@PirKhurramRashdi]

Glad to hear that

[@umamaheswarkasthuri236]

Good explanation sir ,
Learning from your videos
Thank you ❤️

[@bechir9296]

Thanks a lot brother 🥰

[@sifrk]

Thank you. Very informative. Would love to see this example extended to a form.

[@PirKhurramRashdi]

Thanks, more videos are coming soon

[@ShabirAhmad-lw4yq]

Great work

[@PirKhurramRashdi]

Thank you so much 😀

[@ShabirAhmad-lw4yq]

@@PirKhurramRashdi Welcome, a humble request is, as you completed these programming parts, make almost 4 or 5 videos on forms customization and reports customization. Make videos in which At least 3 customized forms in same manner customize 3 or 4 reports, using of event handlers as well as COC.(existing forms and reports)

[@uzairkhan-hj3bv]

@@ShabirAhmad-lw4yq excatly

[@mithunkumarchaupal1065]

good idea

[@uzairkhan-hj3bv]

sir aik edt Id(integer ) type ka mei ne banaya to mei agr is edt ko diffrent table mei use karta hw to phr edt ka table refrence konsi table ka dengy
jestrha ap ne edt aik table mei use kia is ka relation b banaya aor table refrence be deya to agr mei is edt ko dosri table mei use karo to phr kestrha hum relation banayen gy

[@PirKhurramRashdi]

For that purpose use always foreign key relationship, instead of EDT.

[@uzairkhan-hj3bv]

one edt aik h table ke sath refrence banaye ga relation to phr agr zarort pari dosri table mei phr kia kary gy

[@PirKhurramRashdi]

This EDT like salesid and purchid will belong to only one table and the field extended will be alternate key. Multiple realtions can be defined on table relations node with each new foreign key field added.

[@NamNguyen-ln2gx]

Great work as always! Could you please explain more about the difference between two properties Database String Size and String Size. Thank you very much!

[@PirKhurramRashdi]

Thank you Nam for appreciations. The videos are of some use. You've asked about Database String Size and String Size properties. I'm not sure about actual difference, might be if you can find and put some light on it. The StringSize definitely cannot be changed in child EDTs, however, when you create extensions to the existing root String EDTs, the property is changable (increase or decrease). In my opinion database size, is overall limit when you create extension to the root string EDT so that upto that length or size, you can change the extension string EDT size.

[@mdmostafa84]

Perfect

[@PirKhurramRashdi]

Thanks.

[@sunilgkurup1634]

Good

[@PirKhurramRashdi]

Thanks

[@bestgamers7923]

Hi I'm getting the error "Table 'resortGroup' is not found" on the exist method. The find and checkExists are fine. Have followed all the instructions and not sure where the error is. Please advise. Here is the code for the method exist. Thanks.
public static boolean exist(GK_ResortGroupID _resortGroup)
{
return (select firstonly RecId from resortGroup
where resortGroup.ResortGroupID == _resortGroup).RecId != 0;
}
//////////////////////////////
Entire code for the table:
public class GK_ResortGroup extends common
{
public static boolean checkExist(GK_ResortGroupID _resortGroup)
{
boolean ret = true;
if (!GK_ResortGroup::exist(_resortGroup))
{
ret = checkFailed(strfmt(GK_ResortGroup::txtNotExist(), _resortGroup));
}
return ret;
}
public static boolean exist(GK_ResortGroupID _resortGroup)
{
return (select firstonly RecId from resortGroup
where resortGroup.ResortGroupID == _resortGroup).RecId != 0;
}
public static GK_ResortGroup find(
GK_ResortGroupID _resortGroup ,
boolean _forupdate = false,
ConcurrencyModel _concurrencyModel = ConcurrencyModel::Auto)
{
GK_ResortGroup resortGroup;
resortGroup.selectForUpdate(_forupdate);
if (_forupdate && _concurrencyModel != ConcurrencyModel::Auto)
{
resortGroup.concurrencyModel(_concurrencyModel);
}
select firstonly resortGroup
where resortGroup.ResortGroupID == _resortGroup;
return resortGroup;
}
static TxtNotExist txtNotExist()
{
return "@SYS11764";
}
}

[@PirKhurramRashdi]

You have not declared the table resortGroup in existing method prior to the statement.