Search results for query: *

Sorry. Forgot to mention that both tables contain a timestamp columns.

Hi I have two table: header and history. The header record contains Primary Key, PNum and a Status column that can be either 'Open', 'In Progress' or 'Closed'. The header record can only move statuses in that order, ie. from 'Open' to 'In Progress' to finally 'Closed'. In the History table...

Cool, Malcolm. You are absolutely right. It is so much easier to do this sort of thing with report writers. Unfortunately, I can not use a report write and have to rely on SQL only. The main reason for using SQL only is because I need to SQL to plug into an Oracle Alert I am designing. With...

I am bit surprised that this would not be possible. There should be a method to substitute a variable in SQL with the value and then the SQL can fetch that value as a column name in a table. If I have to resort to programming logic then it would look something like this (this is simplified...

Hi. I have two predefined tables: Errors and Transactions. Columns in Errors table are Transaction ID, Error Code, Error Column, Error Message. Columns in Transactions table are Transaction ID, Quantity, Unit Price, Approval, etc. I would like (one) SQL statement that will look up all the...

Hi octopus! thanks fo your time...:D<br><br>I realise my question wasn't clearly asked lasttime around, and i apologize... <br><br>Basically, my question was: How do i put a Jframe in a JTabbedPane?

In my project,I have four Jframe in wich the pricipal one is JtabbedPane with 4 pages. what should I do for my 4 pages contain the 4 Jframes? What is the method I should use to put a Jframe in a page?<br><br>Thank you for your time in advance, and I would appreciate a quick reply...<br><br>In...