Member Avatar for madao

Our prof gave us this code

Dim sql As String
sql = "INSERT INTO OrderDetails" _
& "(orderid,prodid,price,qtyordered,amount,status)VALUES(" _
& "'" & OrderDetail.Orderid & "','" & OrderDetail.Prodid & "'," _
& "'" & OrderDetail.Price & "','" & OrderDetail.Qtyordered & "'," _
& "'" & OrderDetail.Amount & "','open')"


I know this statement is for inserting/saving data from the database table whats confuses me is the 'open')" part. can anyone explain me what is this for

  • 2 Contributors
  • 1 Reply
  • 84 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by kingsonprisonic
Member Avatar for kingsonprisonic

I think this is a static field. I mean each record you insert the status field initially assigned 'open' . Understand!!!

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.