Skip to content
Advertisement

Passing integer value from textbox in SQL select statement

I have an integer in a textbox(Integer retrieved from another form using TOstring) I want to use in an sql select statement.
For example, select * from table where column = textbox. The problem is, npgsql gives an error saying I’m trying to pass string into integer column. I try to cast(::int) but still got errors.

Any ideas!

Advertisement

Answer

I solved this issue. I called the SQL on tab click event and all worked fine. Datagridview properly filtered out the rows using textbox integer input. –

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement