debasisdas

If using ADO then try this [CODE]conn.begintrans 'conn-----adodb connection object conn.execute "delete from table_name" conn.committtrans[/CODE]

please post your code here for reference.

Welcome to Daniweb.

Welcome aboard.

C # .NET with SqlServer is good option. Also try php with mysql.

1. referring and referenced table columns should be matching. 2. DEFAULT is not a constraint.

Welcome to Daniweb.

What is not working ? Are you getting any error ? Check if your sub query returns any record.

What is Dwell Clicking ?

You need to manually rewrite the code.

Welcome aboard.

I think you need to use database to save the data not SaveSetting.

you need to select start and end dates from the control format it as per database format before using the values. Use BETWEEN operator in database side for date range.

No one here is going to supply you with the code without any effort from your side. You need to hire a professional develop to get it done your you, and you need to pay the professional.

Happy birthday. Three years passed only in 2 pages:S

You need to add Picturebox to panel or groupbox, it will be easy to manage. Once the controls are grouped, you can loop through all the content controls and enable or disable at a single go.

Show some effort to get any help here.

Ours is not a free code supply service. You need to read books for all that.

But i do not understand why you need to combine two SQL statements. If you want to fetch records from both the tables then you need to join both the tables.

Please specify how are you connecting ? I am not sure what exactly you mean by [B]The database is being detected but not the tables inside the database.[/B]

You filter the dates from database by using BETWEEN operator. You need to format the dates into your database format before passing the same into the DB for processing.

For a simple solution you have to create a shortcut to the Programs [your exe file] and drag & drop that shortcut into the Startup folder and reboot your system. for example [B]C:\Documents and Settings\Das\Start Menu\Programs\Startup[/B] Other methods [URL="http://www.techrepublic.com/article/tech-tip-put-applications-in-the-nt-system-tray-on-startup/5283952"]here[/URL] and [URL="http://oreilly.com/pub/a/oreilly/windows/ron/startup_0401.html"]here[/URL].

As suggested by smantscheff, you need not bother about STATUS column at all if you do not want to filter by that column and display all the records. So it really does not matter how many distinct values you have in that field.

Hi Avinash, Welcome to Daniweb.

What exactly you are trying to do , that raises this exception ?

Welcome aboard.

I don't think using command buttons is the best option for this.

You need to use GROUP BY clause in your SQL.

That should be designed as a browser plug in.

Modify what ?

[QUOTE=MeOnly;1617674] 4. How does it happen that people here misunderstand each other frequently? There.[/QUOTE]We do it frequently for some serious fun and to confuse others.

You need to use timer control for the same.

Welcome aboard.

You need to read [URL="http://support.microsoft.com/kb/821768"]this[/URL].

welcome aboard.

Welcome to Daniweb.

Welcome to Daniweb.

Welcome aboard.

Welcome aboard.

[QUOTE=folberlin;1639336]i did create my trigger and it works.[/QUOTE] lets see the code.

What buffer codes ? What exactly you are trying to do ?

Read [URL="http://www.daniweb.com/software-development/vbnet/threads/49338"]this[/URL].

You need to use VARCHAR2.

The first thing you need is a client and a server ?

You should not get any error with this SQL statement.

Lets see what you have so far.

Welcome to Daniweb.

Oracle is an ORDBMS and sql is a programming language to interact with database. Please read books for details.

Welcome aboard.

Welcome aboard.