Member Avatar for paulablanca

Hello! Can someone help me? I am trying to input value to AppSchedNumber into my AppInfo table which is the primary key of my AppExamSchedule (auto inrement). The problem is I can't insert on my AppInfo because my AppSchedNumber on my AppExamSchedule should be the same. Thanks! God Bless! :)

  • 2 Contributors
  • 1 Reply
  • 83 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by lolafuertes
Member Avatar for lolafuertes

As AppExamSchedule is autoincrement, you should create a transaction that, first inserts the values in the AppExamSchedule, then selects the highest Id in this table and uses the returned value to insert in the AppInfo table before commiting the transaction.

Hope this helps

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.