Question on datagrid columns

[Blasting Cap]

I'm writing an application where users will input data into a SQL table.
They'll be entering customer data and a purchase order number.
When they submit the PO, it shows a datagrid with the PO number showing.

I've since been asked to write something in SQL to match up the purchase
orders against another order table. That will be in a batch job
overnight. In my sql table, I plan to set bit switches that will note
if it automatically matches up on the nightly run. If it doesn't, there
is another bit switch I am putting in the table that I want to let them
check in order to allow them to say they've manually reconciled the issue.

What I want to do:

On the day an order is entered, I do NOT want the Manual Reconcile bit
switch (I guess a checkbox) to show. However, in this same datagrid, I
do want the ones that have gone thru a matchup over night which did not
automatically match out, to show up with the "Manual Reconcile" switch
where it can be selected/set by the user when they update the order.

If an order has been entered during the day, I do NOT want this
box/switch to be selectable, I want it to have to go thru the match out
over night. However, there are two other boxes on that datagrid that I
do want to be editable at any time. The Manual Reconcile switch I only
want to be enabled when the day of the order is not equal to today.

Is there a way to do this, and if so, how?

Thanks,

BC

[Cowboy \(Gregory A. Beamer\)]

Set up the code to not show the switch if it has not attempted to reconcile
yet. This could be accomplished in one of two ways.

1. Another bit field/boolean that tells if checked
2. Change the flag to an integral value, so there are multiple possible
states for a PO

Either way, you check the value prior to displaying the manual checkbox.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

********************************************
Think outside the box!
********************************************
"Blasting Cap" <go****@christian.netwrote in message
news:eI**************@TK2MSFTNGP04.phx.gbl...

I'm writing an application where users will input data into a SQL table.
They'll be entering customer data and a purchase order number. When they
submit the PO, it shows a datagrid with the PO number showing.

I've since been asked to write something in SQL to match up the purchase
orders against another order table. That will be in a batch job
overnight. In my sql table, I plan to set bit switches that will note if
it automatically matches up on the nightly run. If it doesn't, there is
another bit switch I am putting in the table that I want to let them check
in order to allow them to say they've manually reconciled the issue.

What I want to do:

On the day an order is entered, I do NOT want the Manual Reconcile bit
switch (I guess a checkbox) to show. However, in this same datagrid, I do
want the ones that have gone thru a matchup over night which did not
automatically match out, to show up with the "Manual Reconcile" switch
where it can be selected/set by the user when they update the order.

If an order has been entered during the day, I do NOT want this box/switch
to be selectable, I want it to have to go thru the match out over night.
However, there are two other boxes on that datagrid that I do want to be
editable at any time. The Manual Reconcile switch I only want to be
enabled when the day of the order is not equal to today.

Is there a way to do this, and if so, how?

Thanks,

BC