Member Avatar for gingank

Hi can i use the if else statement to decide on the information go to specific tables that i create?? The form that have fill up will be send to the table 1 or table 2 that i created at ms sql 2000 base on the user write active or not active. So do it work like that ?

Something like

If data="no active" then send to table 1
ElseIF data="active" then send to table 2
End 
EndIf
  • 2 Contributors
  • 1 Reply
  • 85 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by vb5prgrmr
Member Avatar for vb5prgrmr 
If data="no active" then send to table 1
    strSQL = INSERT INTO Table1...
ElseIF data="active" then send to table 2
    strSQL = INSERT INTO Table2...
EndIf

BTW: You should never use the END statement to stop your program.


Good Luck

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.