0

good day!

I want to pass the value that contains tha table name and load its data.But my sql turns error.Below is my code.

Combo2.Text = "first_year"

sql = "select * from " & Combo2.Text & "'"
        rs.Open sql, conn, adOpenKeyset, adLockOptimistic, adCmdText

Im using mysql as backend database.

Pls help.God bless on this mother earth.

Thank you for your time.!

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by blocker
1
sql = "select * from " & Combo2.Text & "'"

You don't need tick on the end.

Good Luck

Votes + Comments
Very Helpful
0
sql = "select * from " & Combo2.Text & "'"

You don't need tick on the end.

Good Luck

thank you sir. This problem was solved.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.