Can't Access clusResource.OwnerNode Property

I cannot get any values from the OwnerNode property from the clusResource
class. An error appears: Object doesn't support this property or method
I can successfully obtain the Name, State and other properties from the
clusResource class.
How do i determine the owner of a given resource programatically using MS
Cluster Service Automation Classes? Using VB6...
Thanks in advance.
Chris
Found it. The OwnerNode property returns a clusNode object.
Set clusNode = clusResource.OwnerNode
debug.print clusNode.Name
Chris
"Chris" wrote:

> I cannot get any values from the OwnerNode property from the clusResource
> class. An error appears: Object doesn't support this property or method
> I can successfully obtain the Name, State and other properties from the
> clusResource class.
> How do i determine the owner of a given resource programatically using MS
> Cluster Service Automation Classes? Using VB6...
> Thanks in advance.
> Chris

cannot update table

I have an msde database connected to a microsoft project front end.
I am trying to update a table with values. When I use a stored procedure
everything works fine but when I try and edit the table directly I am warned
that the 'the recordset is not updatable'
Is this 'by design'? or are there permission issues?
I am logged into the database as a user almx who has database creation
rights.
I tried logging into the database as sa but I it makes no difference.
Are there any specific permissions I need to set to allow users to update
the table values directly or is this not possible in a MS Access Project?
June
Access won't allow you to update records unless there's a primary key
or unique index defined on the tables.
--Mary
On Wed, 16 Jun 2004 12:24:34 +0100, "June Macleod"
<junework@.hotmail.com> wrote:

>I have an msde database connected to a microsoft project front end.
>I am trying to update a table with values. When I use a stored procedure
>everything works fine but when I try and edit the table directly I am warned
>that the 'the recordset is not updatable'
>Is this 'by design'? or are there permission issues?
>I am logged into the database as a user almx who has database creation
>rights.
>I tried logging into the database as sa but I it makes no difference.
>Are there any specific permissions I need to set to allow users to update
>the table values directly or is this not possible in a MS Access Project?
>June
>

Cannot Update Records that contain NULL Values!

Hi,

I am trying to use a formView with an update button to update individual records in an sql database. (when i click update it doesnt perform the update and just refreshes the page. ) One of the fields in my records is a NULL - this is also one of the fields that i need to update. When i manually go into the database and enter some data, and then go back to my form, it updates fine, but as soon as i delete the data from the field, it returns to NULL and im back to square one.

Any Ideas on how to get around this problem?

THanks

Then what's wrong? Since you delete the data from the field, it should be set to NULL. What do you expect to get after deleting the data? And what's meaing of "im back to square one"|||Fix your update statement. If you've used the wizard with "Check Original Values", then you are correct, it fails with nulls. You have to manually modify the update to handle nulls.|||

yep.. i got it now... i had to change "compare all values" to "overwrite changes". That makes sense. you cant compare null values to each other.

Thanks

cannot update all the values of Query

I have faced a situation that when i try to update a page. Some values can be updated while some cannot. I try to print the executed SQL query and get the following

1"UPDATE orders SET2cust_id=15,po_code='PO20060610',3po_amt=10000.0000,4add_charges=0,5commission='eeeeeee',6lab_charges=0,7fty_dis=0,8pay_trm='adasds',9cust_dis=0,10trade_trm_desc='',11curr_rate=1,12ship_expense=0,13shipmark='eng ship mard new2',14sidemark='Eng Side Mark new333'15,inner_box='Eng Inner Box new333',16confirmation='rend confirmation2',17contract='end contact23',18internal_remark='testing testing 26/6/2007 333',19rec_curr_rate=0,rec_amt=0,shipmark_attach='',20sidemark_attach='',inner_box_attach='',21ord_type=1,status=2,ord_confirm_code='',22commission_type=1,sidemark_lang='English',23curr_code='HKD',unit_code='PCS',24trade_trm='FOB Hong Kong',rec_curr='USD',25ord_date='2006/06/10', po_date='01/01/2007',exp_delivery_date='01/01/2007',26act_delivery_date='01/01/2007', pay_start_date='10/10/06',pay_end_date='10/10/06',upd_time='2007/03/15 15:41:14' WHERE ord_id=292;Set @.ord_id=292;"

The fields sidemark, inner_box, internal_remark cannot update, while others can.

I think it's really strange... since i have no idea why some can be updated while some others and the SQL seems to me is correct.

Please give me some advices on solving this.

Thank you.

If I run this query against the table (definition below) it all works and all of those fields are updated.

Perhaps there is a problem with the definition of the table - you can post the definition if you like and I'll test again with the same definition. I had to call my table orders2 as I tested in Northwind, which already has an orders table...

UPDATE orders2 SET
cust_id=15,po_code='PO20060610',
po_amt=10000.0000,
add_charges=0,
commission='eeeeeee',
lab_charges=0,
fty_dis=0,
pay_trm='adasds',
cust_dis=0,
trade_trm_desc='',
curr_rate=1,
ship_expense=0,
shipmark='eng ship mard new2',
sidemark='Eng Side Mark new333'
,inner_box='Eng Inner Box new333',
confirmation='rend confirmation2',
contract='end contact23',
internal_remark='testing testing 26/6/2007 333',
rec_curr_rate=0,rec_amt=0,shipmark_attach='',
sidemark_attach='',inner_box_attach='',
ord_type=1,status=2,ord_confirm_code='',
commission_type=1,sidemark_lang='English',
curr_code='HKD',unit_code='PCS',
trade_trm='FOB Hong Kong',rec_curr='USD',
ord_date='2006/06/10', po_date='01/01/2007',exp_delivery_date='01/01/2007',
act_delivery_date='01/01/2007', pay_start_date='10/10/06',pay_end_date='10/10/06',upd_time='2007/03/15 15:41:14' WHERE ord_id=1

CREATE TABLE [orders2] (
[ord_id] [int] IDENTITY (1, 1) NOT NULL ,
[cust_id] [int] NULL ,
[po_code] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[po_amt] [decimal](18, 2) NULL ,
[add_charges] [decimal](18, 2) NULL ,
[commission] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[lab_charges] [decimal](18, 2) NULL ,
[fty_dis] [decimal](18, 2) NULL ,
[pay_trm] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[cust_dis] [decimal](18, 2) NULL ,
[trade_trm_desc] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[curr_rate] [decimal](18, 2) NULL ,
[ship_expense] [decimal](18, 2) NULL ,
[shipmark] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[sidemark] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[inner_box] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[confirmation] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[contract] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[internal_remark] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[rec_curr_rate] [decimal](18, 2) NULL ,
[rec_amt] [decimal](18, 2) NULL ,
[shipmark_attach] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[sidemark_attach] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[inner_box_attach] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[ord_type] [int] NULL ,
[status] [int] NULL ,
[ord_confirm_code] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[commission_type] [int] NULL ,
[sidemark_lang] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[curr_code] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[unit_code] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[trade_trm] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[rec_curr] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[ord_date] [datetime] NULL ,
[po_date] [datetime] NULL ,
[exp_delivery_date] [datetime] NULL ,
[act_delivery_date] [datetime] NULL ,
[pay_start_date] [datetime] NULL ,
[pay_end_date] [datetime] NULL ,
[upd_time] [datetime] NULL ,
CONSTRAINT [PK_orders2] PRIMARY KEY CLUSTERED
(
[ord_id]
) ON [PRIMARY]
) ON [PRIMARY]
GO

|||

Your orders is a table or View? Do you receive any specific error?

Thanks

|||

orders2 is a table.

I didn't get any errors and the update was sucessful.

|||

I see that yours is tableSohnee ,but the object orders with whichthtang has a problem is a table or view?

Cannot sort a row of size 8095, which is greater than the allowable maximum of 8094

Hello,
I receive an error "Cannot sort a row of size 8095, which is greater than
the allowable maximum of 8094." when selecting values from a table in the
database. If I delete the existing data and try it, I'm not able to
reproduce it again. I wonder how could this error have possibly occured in
the first place. Any ideas?
Thanks,
Felix.JHi, Felix
Try running your query with "OPTION (ROBUST PLAN)".
Razvan|||Felix,
I also encountered this problem.
Have you tried the OPTION (ROBUST PLAN)? Does it work?
Julius