You are not logged in.

1

Friday, June 25th 2010, 4:43am

Example of QT Filter Query an Oracle DataBase

I am looking for someone to help me find a complete project that has the following:



1) connection to oracle database 10g

2) selects Number col, String Col, Date Col from an Oracle table

3) Allows you to apply a where clause to the sql based on text entered into a text box

4) data is displayed when a button is hit.



I have been looking and trying now for 8 days trying to follow code snippets here and there across the wenb but for what ever reason the code just does does not work from what I have copied.



If anyone has a working project could you attach the file, so I could down load it. I can make the changes to connect to my database, and selecte the coloums from the table i need and chnage the filter. but I just want at least one working example.



Maybe you could use the following as your sql and use scott/tiger as the datbase log into oracle. I dont need this to work on any other databases just oracle



select 1 as emp_no, 'DAVE' as emp_name, sysdate hiredate from dual where 1 = 1;



your help will be very appreciated

This post by "xuebao" (Saturday, June 26th 2010, 3:30am) has been deleted by user "Junior" (Wednesday, July 14th 2010, 4:17pm) with the following reason: spammer

Rate this thread