Hi Community,
in one table (PriceTable) I have the fields "VehicleTyp" & "VehicleCategorie" .
Depending on the two fields "VehicleTyp" & "VehicleCategorie" and on their entries... I want to say that for each "VehicleTyp" (Car & Truck) it is for both only once possible to have the VehicleCategorie "not specified".
How is that possible via Code? & what is the best practise of handling a Situation like that ?
Thanks in advance.
*This post is locked for comments
if (this.vehicletyp == 1 && this.VehicleCategorie == 1)
{
select VehicleTyp, VehicleCategorie from priceTable
where priceTable.VehicleTyp == this.VehicleTyp && priceTable.VehicleCategorie == this.VehicleCategorie;
if (priceTable.VehicleTyp == 1 && priceTable.VehicleCategorie == 1)
{
ret = checkFailed("Can't insert");
}
else
{
priceTable.VehicleTyp = this.VehicleTyp;
priceTable.VehicleCategorie = this.VehicleCategorie;
ret = true;
}
}
if (this.VehicleTyp == 2 && this.VehicleCategorie == 1)
{
select VehicleTyp, VehicleCategorie from priceTable
where priceTable.VehicleTyp == this.VehicleTyp && priceTable.VehicleCategorie == this.VehicleCategorie;
if (priceTable.VehicleTyp == 2 && priceTable.VehicleCategorie == 1)
{
ret = checkFailed("Can't insert");
}
else
{
priceTable.VehicleTyp = this.VehicleTyp;
priceTable.VehicleCategorie = this.VehicleCategorie;
ret = true;
}
}
it works so far.
Only Problem is that, when I click on the same record after I saved it, and want to save it again... it says "Can't insert"
Which I can understand... but are there any recommendations that You can give me to solve it ?
And do you have any other tips ?
Like do I Need a try catch Statement, Exception handling etc ??
Thanks in advance.
It worked. Thanks a lot.
I will do that.
Thanks.
How about going into the validateWrite() of my Price Table ?
Saying that it is only allowed for VehicleTypes "Car" and "Truck" to have a VehicleCategorie "NotSpecified" (0) only once in the Table ?
Yeah but that wouldn't be perfect, because You could have many vehicletypes which can have for example "midrange" as vehicleCategorie.
Like
Car | midrange | 4er | 150
Car | midrange | c-class | 175
this should be possible.
Only Thing which should not be possible is that for one ´vehicleTyp there be twice "not specified" as categorie.
Seems like you want to create a primary index using both fields. This would mean no duplicates for any VehicleType and VehicleCategory pair.
Hi Sukrut,
I put in a Screenshot.
Do You see my first record and third ? (Highlighted)
I already (3rd Record) have "Car" as VehicleTyp and "Not specified" as Categorie.
One more record with the exact same entries for both fields, should not be possible.
I want to mention that both fields are BaseEnums.
Thanks in advance
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (