Varnam Aayiram wrote:
Varnam Aayiram wrote:Hi Pushakar..
Varnam Aayiram wrote:Hi guys...
Is one supposed to declare upfront if one has posted the same question/s in other forums? Well, the questions I have raised here I have also raised in a couple of other forums and someone from one of the other forums was not too happy about it. Anyway the reason I am doing this is to open up the questions to more people so that there will be a higher chance of getting an answer and others caught in a simillar situation as mine will also benefit. Once the problem has been finally solved on my end, I will share the solution with one and all. Thanks and sorry if I had caused any trouble.
Varnam Aayiram wrote:Is one supposed to declare upfront if one has posted the same question/s in other forums?
I believe I understand what the error message is saying, that I can't enter a value in the FK_iddate column that dosen't exist in the iddate column of the calendar table. I find this puzzling as the value I am trying to add for FK_iddate column already exists in the calendar table and the relationship between the calendar and booking table is '1(calendar) to many(booking)' However when I run the SQL query directly in MYSQL itself, I am not getting any error and a new row is sucessfully added in the booking table.
WHAT is your favorite color? Blue, no yellow, ahhhhhhh! Tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koophttps://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton