Group Update Datawindow by PB NVO Compoent Sometimes Error

When I Group Update Datawindow by PB NVO Compoent,Sometimes, Some of DWs 
Update to Database SUCCESSful��Some of DWs Update to Database Failed, 
It'looks Transaction Control is inValid!

Here is My Codes:

CONSTANT STRING METHOD_NAME="n_datastoreservice.of_updategroup()"

long       ll_rc
long       ll_Cnt
datastore  lds_dsServer[]
n_cst_compressionservice lnv_compression
blob       lblb_Temp[]
boolean    lb_DataChanged=false
n_cst_stringservice lnv_string
string     ls_DataObjects
datastore  lds_Empty[]

lnv_string=Create n_cst_stringservice
lnv_string.of_parsearraytostring(as_dataobject,";",ls_DataObjects)
destroy lnv_string

inv_log.of_debuglog(METHOD_NAME,"Function Entered! "+" 
CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)

if inv_baseservice.of_TransactionConnect(as_cachealias,as_Errtext)=-1 then
 //as_Errtext="Fail to Connect the Specify Database Cache 
Alias:'"+as_cachealias+"'!"
 inv_log.of_AddError(METHOD_NAME,as_Errtext+" CacheAlias="+as_CacheAlias+" 
DataObjects="+ls_DataObjects)
   return -1
End if

FOR ll_Cnt=1 to Upperbound(as_DataObject)
 If Isnull(as_DataObject[ll_cnt]) OR Trim(as_DataObject[ll_cnt])="" then
    as_Errtext="No."+string(ll_cnt)+" DataObject's Name is not Specified!"
    inv_log.of_AddError(METHOD_NAME,as_Errtext+" 
CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)
      return -1
 End if
Next

If UpperBound(as_DataObject)<>UpperBound(ablb_DataChanges) Then
   as_Errtext="DataObject's Sum and Data Changes Blob's Sum is not Match!"
   inv_log.of_AddError(METHOD_NAME,as_Errtext+" CacheAlias="+as_CacheAlias+" 
DataObjects="+ls_DataObjects)
   return -1
End If

If ab_Zipped Then
 lnv_compression=create n_cst_compressionservice
 FOR ll_cnt=1 to Upperbound(ablb_DataChanges)
   If Isnull(ablb_DataChanges[ll_cnt]) OR Len(ablb_DataChanges[ll_cnt])=0 
Then
    lblb_Temp[ll_cnt]=ablb_DataChanges[ll_cnt]
   Else
    ll_Rc=lnv_compression.of_UnCompress(ablb_DataChanges[ll_cnt],lblb_Temp[ll_cnt])
      If ll_Rc=-1 then
         as_Errtext="Fail to UnCompress the No."+string(ll_cnt)+" 
DataObject's  Data Changes Blob! "
         inv_Log.of_addError(METHOD_NAME, as_Errtext+" 
CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)
       destroy lnv_compression
         return -1
        End If
   End If
 Next
 Destroy lnv_compression
Else
 FOR ll_cnt=1 to Upperbound(ablb_DataChanges)
    lblb_Temp[ll_cnt]=ablb_DataChanges[ll_cnt]
 Next
End If

//Update Preparing....
FOR ll_Cnt=1 to Upperbound(as_DataObject)
   If Isnull(lblb_Temp[ll_cnt]) OR Len(lblb_Temp[ll_cnt])=0 Then
  Continue
 End If

 lds_dsServer[ll_cnt]=Create datastore

   lds_dsServer[ll_cnt].dataobject=as_DataObject[ll_cnt]
   //validate the actual assignment
   If Not isNumber(lds_dsServer[ll_cnt].describe("DataWindow.Processing")) 
Then
    as_errtext="No."+string(ll_Cnt)+" DataObject Assignment is Failed!"
      GOTO ERROR_RETURN
   End If

   ll_rc=lds_dsServer[ll_cnt].SetChanges(lblb_Temp[ll_cnt])
   If ll_Rc<0 then
    as_errtext="Fail to Set Changes To No."+string(ll_cnt)+" Datastore,Error 
Code:"+String(ll_rc)
      GOTO ERROR_RETURN
   End If

   lds_dsServer[ll_cnt].SetTransObject(itr_Trans)

Next

//Update Real Actions.....
FOR ll_Cnt=1 to Upperbound(as_DataObject)
   If Isnull(lblb_Temp[ll_cnt]) OR Len(lblb_Temp[ll_cnt])=0 Then
  Continue
 End If

   // Perform the actual datastore Update
 if Isvalid(lds_dsServer[ll_cnt]) then
   If lds_dsServer[ll_cnt].Update()=-1 then
    as_Errtext="Fail to Update the No."+string(ll_cnt)+" DataObject's 
Changes to Database,Operation Code="+string(-1)+",DBError 
Message:"+itr_Trans.sqlErrtext
      GOTO ERROR_RETURN
   End If

 lb_DataChanged=True
 End If
Next

Commit Using itr_trans;
its_jag.SetComplete()

FOR ll_cnt=Upperbound(lds_dsServer) to 1 Step -1
 If Isvalid (lds_dsServer[ll_cnt]) then
  lds_dsServer[ll_cnt].reset()
      destroy lds_dsServer[ll_cnt]
 End If
Next
lds_dsServer=lds_Empty  //Clear Array

inv_log.of_debuglog(METHOD_NAME,"Function Returned Successful! "+" 
CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)

If lb_DataChanged=false then
 return 0
Else
 Return 1
End If

ERROR_RETURN:

inv_Log.of_addError(METHOD_NAME, as_Errtext+" CacheAlias="+as_CacheAlias+" 
DataObjects="+ls_DataObjects)

Rollback using itr_trans;
its_jag.SetAbort()

FOR ll_cnt=Upperbound(lds_dsServer) to 1 Step -1
 If Isvalid(lds_dsServer[ll_cnt]) then
  lds_dsServer[ll_cnt].reset()
      destroy lds_dsServer[ll_cnt]
 End If
Next
lds_dsServer=lds_Empty //Clear Array

Return -1
 


0
Yuan
1/29/2008 4:29:32 AM
sybase.easerver.general 7903 articles. 0 followers. Follow

2 Replies
401 Views

Similar Articles

[PageSpeed] 51

I'm not sure what you are doing. Your mixing concepts here. You are managing 
the transaction as well as letting EAS manage the transaction.

If the component is setup to be transaction and you are calling setcomplete 
and setabort, you should not call Commit and Rollback. If your going to 
manage the transaction in the code, you should define the component  "does 
not support transaction"

-- 
Dean Jones
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 Ext. 112

TeamSybase
* * Think Sybase * *


"Yuan.Jerry" <qianhy@gmail.com> wrote in message 
news:479eabac@forums-1-dub...
> When I Group Update Datawindow by PB NVO Compoent,Sometimes, Some of DWs 
> Update to Database SUCCESSful��Some of DWs Update to Database Failed, 
> It'looks Transaction Control is inValid!
>
> Here is My Codes:
>
> CONSTANT STRING METHOD_NAME="n_datastoreservice.of_updategroup()"
>
> long       ll_rc
> long       ll_Cnt
> datastore  lds_dsServer[]
> n_cst_compressionservice lnv_compression
> blob       lblb_Temp[]
> boolean    lb_DataChanged=false
> n_cst_stringservice lnv_string
> string     ls_DataObjects
> datastore  lds_Empty[]
>
> lnv_string=Create n_cst_stringservice
> lnv_string.of_parsearraytostring(as_dataobject,";",ls_DataObjects)
> destroy lnv_string
>
> inv_log.of_debuglog(METHOD_NAME,"Function Entered! "+" 
> CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)
>
> if inv_baseservice.of_TransactionConnect(as_cachealias,as_Errtext)=-1 then
> //as_Errtext="Fail to Connect the Specify Database Cache 
> Alias:'"+as_cachealias+"'!"
> inv_log.of_AddError(METHOD_NAME,as_Errtext+" CacheAlias="+as_CacheAlias+" 
> DataObjects="+ls_DataObjects)
>   return -1
> End if
>
> FOR ll_Cnt=1 to Upperbound(as_DataObject)
> If Isnull(as_DataObject[ll_cnt]) OR Trim(as_DataObject[ll_cnt])="" then
>    as_Errtext="No."+string(ll_cnt)+" DataObject's Name is not Specified!"
>    inv_log.of_AddError(METHOD_NAME,as_Errtext+" 
> CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)
>      return -1
> End if
> Next
>
> If UpperBound(as_DataObject)<>UpperBound(ablb_DataChanges) Then
>   as_Errtext="DataObject's Sum and Data Changes Blob's Sum is not Match!"
>   inv_log.of_AddError(METHOD_NAME,as_Errtext+" 
> CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)
>   return -1
> End If
>
> If ab_Zipped Then
> lnv_compression=create n_cst_compressionservice
> FOR ll_cnt=1 to Upperbound(ablb_DataChanges)
>   If Isnull(ablb_DataChanges[ll_cnt]) OR Len(ablb_DataChanges[ll_cnt])=0 
> Then
>    lblb_Temp[ll_cnt]=ablb_DataChanges[ll_cnt]
>   Else
> 
> ll_Rc=lnv_compression.of_UnCompress(ablb_DataChanges[ll_cnt],lblb_Temp[ll_cnt])
>      If ll_Rc=-1 then
>         as_Errtext="Fail to UnCompress the No."+string(ll_cnt)+" 
> DataObject's  Data Changes Blob! "
>         inv_Log.of_addError(METHOD_NAME, as_Errtext+" 
> CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)
>       destroy lnv_compression
>         return -1
>        End If
>   End If
> Next
> Destroy lnv_compression
> Else
> FOR ll_cnt=1 to Upperbound(ablb_DataChanges)
>    lblb_Temp[ll_cnt]=ablb_DataChanges[ll_cnt]
> Next
> End If
>
> //Update Preparing....
> FOR ll_Cnt=1 to Upperbound(as_DataObject)
>   If Isnull(lblb_Temp[ll_cnt]) OR Len(lblb_Temp[ll_cnt])=0 Then
>  Continue
> End If
>
> lds_dsServer[ll_cnt]=Create datastore
>
>   lds_dsServer[ll_cnt].dataobject=as_DataObject[ll_cnt]
>   //validate the actual assignment
>   If Not isNumber(lds_dsServer[ll_cnt].describe("DataWindow.Processing")) 
> Then
>    as_errtext="No."+string(ll_Cnt)+" DataObject Assignment is Failed!"
>      GOTO ERROR_RETURN
>   End If
>
>   ll_rc=lds_dsServer[ll_cnt].SetChanges(lblb_Temp[ll_cnt])
>   If ll_Rc<0 then
>    as_errtext="Fail to Set Changes To No."+string(ll_cnt)+" 
> Datastore,Error Code:"+String(ll_rc)
>      GOTO ERROR_RETURN
>   End If
>
>   lds_dsServer[ll_cnt].SetTransObject(itr_Trans)
>
> Next
>
> //Update Real Actions.....
> FOR ll_Cnt=1 to Upperbound(as_DataObject)
>   If Isnull(lblb_Temp[ll_cnt]) OR Len(lblb_Temp[ll_cnt])=0 Then
>  Continue
> End If
>
>   // Perform the actual datastore Update
> if Isvalid(lds_dsServer[ll_cnt]) then
>   If lds_dsServer[ll_cnt].Update()=-1 then
>    as_Errtext="Fail to Update the No."+string(ll_cnt)+" DataObject's 
> Changes to Database,Operation Code="+string(-1)+",DBError 
> Message:"+itr_Trans.sqlErrtext
>      GOTO ERROR_RETURN
>   End If
>
> lb_DataChanged=True
> End If
> Next
>
> Commit Using itr_trans;
> its_jag.SetComplete()
>
> FOR ll_cnt=Upperbound(lds_dsServer) to 1 Step -1
> If Isvalid (lds_dsServer[ll_cnt]) then
>  lds_dsServer[ll_cnt].reset()
>      destroy lds_dsServer[ll_cnt]
> End If
> Next
> lds_dsServer=lds_Empty  //Clear Array
>
> inv_log.of_debuglog(METHOD_NAME,"Function Returned Successful! "+" 
> CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)
>
> If lb_DataChanged=false then
> return 0
> Else
> Return 1
> End If
>
> ERROR_RETURN:
>
> inv_Log.of_addError(METHOD_NAME, as_Errtext+" CacheAlias="+as_CacheAlias+" 
> DataObjects="+ls_DataObjects)
>
> Rollback using itr_trans;
> its_jag.SetAbort()
>
> FOR ll_cnt=Upperbound(lds_dsServer) to 1 Step -1
> If Isvalid(lds_dsServer[ll_cnt]) then
>  lds_dsServer[ll_cnt].reset()
>      destroy lds_dsServer[ll_cnt]
> End If
> Next
> lds_dsServer=lds_Empty //Clear Array
>
> Return -1
>
>
> 


0
Dean
1/29/2008 2:28:16 PM
My Component is defined as ''does not support transaction"

My Component is stateless,and The function is to updating a group 
datawindow's datachanges

thanks.


"Dean Jones" <dean_dot_jones_at_powerobjects_dot_com> ?�J�����s?:479f3800$1@forums-1-dub...
> I'm not sure what you are doing. Your mixing concepts here. You are 
> managing the transaction as well as letting EAS manage the transaction.
>
> If the component is setup to be transaction and you are calling 
> setcomplete and setabort, you should not call Commit and Rollback. If your 
> going to manage the transaction in the code, you should define the 
> component  "does not support transaction"
>
> -- 
> Dean Jones
> CEO
> PowerObjects
> http://www.powerobjects.com
> (612) 339-3355 Ext. 112
>
> TeamSybase
> * * Think Sybase * *
>
>
> "Yuan.Jerry" <qianhy@gmail.com> wrote in message 
> news:479eabac@forums-1-dub...
>> When I Group Update Datawindow by PB NVO Compoent,Sometimes, Some of DWs 
>> Update to Database SUCCESSful��Some of DWs Update to Database Failed, 
>> It'looks Transaction Control is inValid!
>>
>> Here is My Codes:
>>
>> CONSTANT STRING METHOD_NAME="n_datastoreservice.of_updategroup()"
>>
>> long       ll_rc
>> long       ll_Cnt
>> datastore  lds_dsServer[]
>> n_cst_compressionservice lnv_compression
>> blob       lblb_Temp[]
>> boolean    lb_DataChanged=false
>> n_cst_stringservice lnv_string
>> string     ls_DataObjects
>> datastore  lds_Empty[]
>>
>> lnv_string=Create n_cst_stringservice
>> lnv_string.of_parsearraytostring(as_dataobject,";",ls_DataObjects)
>> destroy lnv_string
>>
>> inv_log.of_debuglog(METHOD_NAME,"Function Entered! "+" 
>> CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)
>>
>> if inv_baseservice.of_TransactionConnect(as_cachealias,as_Errtext)=-1 
>> then
>> //as_Errtext="Fail to Connect the Specify Database Cache 
>> Alias:'"+as_cachealias+"'!"
>> inv_log.of_AddError(METHOD_NAME,as_Errtext+" CacheAlias="+as_CacheAlias+" 
>> DataObjects="+ls_DataObjects)
>>   return -1
>> End if
>>
>> FOR ll_Cnt=1 to Upperbound(as_DataObject)
>> If Isnull(as_DataObject[ll_cnt]) OR Trim(as_DataObject[ll_cnt])="" then
>>    as_Errtext="No."+string(ll_cnt)+" DataObject's Name is not Specified!"
>>    inv_log.of_AddError(METHOD_NAME,as_Errtext+" 
>> CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)
>>      return -1
>> End if
>> Next
>>
>> If UpperBound(as_DataObject)<>UpperBound(ablb_DataChanges) Then
>>   as_Errtext="DataObject's Sum and Data Changes Blob's Sum is not Match!"
>>   inv_log.of_AddError(METHOD_NAME,as_Errtext+" 
>> CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)
>>   return -1
>> End If
>>
>> If ab_Zipped Then
>> lnv_compression=create n_cst_compressionservice
>> FOR ll_cnt=1 to Upperbound(ablb_DataChanges)
>>   If Isnull(ablb_DataChanges[ll_cnt]) OR Len(ablb_DataChanges[ll_cnt])=0 
>> Then
>>    lblb_Temp[ll_cnt]=ablb_DataChanges[ll_cnt]
>>   Else
>>
>> ll_Rc=lnv_compression.of_UnCompress(ablb_DataChanges[ll_cnt],lblb_Temp[ll_cnt])
>>      If ll_Rc=-1 then
>>         as_Errtext="Fail to UnCompress the No."+string(ll_cnt)+" 
>> DataObject's  Data Changes Blob! "
>>         inv_Log.of_addError(METHOD_NAME, as_Errtext+" 
>> CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)
>>       destroy lnv_compression
>>         return -1
>>        End If
>>   End If
>> Next
>> Destroy lnv_compression
>> Else
>> FOR ll_cnt=1 to Upperbound(ablb_DataChanges)
>>    lblb_Temp[ll_cnt]=ablb_DataChanges[ll_cnt]
>> Next
>> End If
>>
>> //Update Preparing....
>> FOR ll_Cnt=1 to Upperbound(as_DataObject)
>>   If Isnull(lblb_Temp[ll_cnt]) OR Len(lblb_Temp[ll_cnt])=0 Then
>>  Continue
>> End If
>>
>> lds_dsServer[ll_cnt]=Create datastore
>>
>>   lds_dsServer[ll_cnt].dataobject=as_DataObject[ll_cnt]
>>   //validate the actual assignment
>>   If Not isNumber(lds_dsServer[ll_cnt].describe("DataWindow.Processing")) 
>> Then
>>    as_errtext="No."+string(ll_Cnt)+" DataObject Assignment is Failed!"
>>      GOTO ERROR_RETURN
>>   End If
>>
>>   ll_rc=lds_dsServer[ll_cnt].SetChanges(lblb_Temp[ll_cnt])
>>   If ll_Rc<0 then
>>    as_errtext="Fail to Set Changes To No."+string(ll_cnt)+" 
>> Datastore,Error Code:"+String(ll_rc)
>>      GOTO ERROR_RETURN
>>   End If
>>
>>   lds_dsServer[ll_cnt].SetTransObject(itr_Trans)
>>
>> Next
>>
>> //Update Real Actions.....
>> FOR ll_Cnt=1 to Upperbound(as_DataObject)
>>   If Isnull(lblb_Temp[ll_cnt]) OR Len(lblb_Temp[ll_cnt])=0 Then
>>  Continue
>> End If
>>
>>   // Perform the actual datastore Update
>> if Isvalid(lds_dsServer[ll_cnt]) then
>>   If lds_dsServer[ll_cnt].Update()=-1 then
>>    as_Errtext="Fail to Update the No."+string(ll_cnt)+" DataObject's 
>> Changes to Database,Operation Code="+string(-1)+",DBError 
>> Message:"+itr_Trans.sqlErrtext
>>      GOTO ERROR_RETURN
>>   End If
>>
>> lb_DataChanged=True
>> End If
>> Next
>>
>> Commit Using itr_trans;
>> its_jag.SetComplete()
>>
>> FOR ll_cnt=Upperbound(lds_dsServer) to 1 Step -1
>> If Isvalid (lds_dsServer[ll_cnt]) then
>>  lds_dsServer[ll_cnt].reset()
>>      destroy lds_dsServer[ll_cnt]
>> End If
>> Next
>> lds_dsServer=lds_Empty  //Clear Array
>>
>> inv_log.of_debuglog(METHOD_NAME,"Function Returned Successful! "+" 
>> CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)
>>
>> If lb_DataChanged=false then
>> return 0
>> Else
>> Return 1
>> End If
>>
>> ERROR_RETURN:
>>
>> inv_Log.of_addError(METHOD_NAME, as_Errtext+" 
>> CacheAlias="+as_CacheAlias+" DataObjects="+ls_DataObjects)
>>
>> Rollback using itr_trans;
>> its_jag.SetAbort()
>>
>> FOR ll_cnt=Upperbound(lds_dsServer) to 1 Step -1
>> If Isvalid(lds_dsServer[ll_cnt]) then
>>  lds_dsServer[ll_cnt].reset()
>>      destroy lds_dsServer[ll_cnt]
>> End If
>> Next
>> lds_dsServer=lds_Empty //Clear Array
>>
>> Return -1
>>
>>
>>
>
> 


0
Yuan
1/30/2008 1:40:15 AM
Reply:

Similar Artilces:

Return charater causes DW update error and PB crash (re-post from the pb.general group)
Hi All PB 10.0.1, MSSQLServer 2000 We've got a field (defined as Char) that takes standard input... included in this is the odd carriage return (though we've got triggers preventing saving of said bad character).. When this was running with PB 8, the save went through without issue... As soon as app was migrated to PB 10 (no change in back end with migration to 10), the save started blowing up (cannot insert NULL error, even though we can see the value in the insert/update statement... only weird part is that in both the error msg and a DB Trace, the return key...

DataWindow Error : DataWindow does not have UPDATE capability
Hi! I have faced the above error message when I clicked on my saved button which is suppose to save any updates. The strange thing is, the changes are being captured! When I retrieve the particular record I changed, I reflected the changes I made to it. I created a window with a few tab pages, with 1 datawindow control on each tab page, anyway, my other window with a few tab pages works fine. So what's wrong? Any help will be appreciated! :) KCM wrote: > > Hi! > I have faced the above error message when I clicked on my saved button > which is suppose to save...

Datawindow NVO "out of memory" error in EAServer 3.6.1
Hi, I just test the stability of PB NVO. I use the 40 datastore in the component and each datastore will cache 256K rows. I already set the "dbStore.dataobject.storagepagesize='Large'", but when the memory used by EAServer up to about 1.4GB, the server is "out of memory". The platform I used is Dell PowerEdge 4400, 2x866MHz PIII, 1GB Mem, 1 GB Virtual memory, Windows NT 4.0 Server. Any suggestion will be highly appreciated! Thank you in advance! Lili By the way, the EAServer is 3.6.1, and I tested PBVM using PB7.0.3 & PB8.0, they ar...

Install PB 10 update without needing to install PB 9 update, then PB 8 update....
We have a bunch of updates to PB. Is there a way we can install PB 10 without needing to install all the previous versions of PB? If all you have is an update version, then you'll need to have some previous version of PB installed. On 4 Mar 2005 05:54:11 -0800, "Daniel Coppersmith" <daniel_N.0.S.P.A.M_at_InFrontSoftware_D0T_C0M> wrote: >We have a bunch of updates to PB. Is there a way we can install PB 10 >without needing to install all the previous versions of PB? > > Bruce Armstrong [TeamSybase] http://www.teamsybase.com Vote for D...

PB Remote Debugging error
Hey all... I get the following error when I try to connect to a remote server through the remote debugging option: DBG_Connection::Create - unable to connect to listener, error # 10060 When I test the connection in EAServer Profile, the connection is successful. Any ideas on how to fix this error? EAServer: 5.3.0 (Build 53016) on Windows 2003 Server SP1 PB: 10.5 (4523) on Windows XP SP2 Thank you, Matt me@my.com wrote... > Hey all... > > I get the following error when I try to connect to a remote server through > the remote debugging option: >...

ERROR: DataWindow definition not set. Error after 2nd update
Hi all, I'm getting an error on a datawindow on a web page that seems to work fine for a while. The error appears on the page, "Error: Datawindow definiation not set' I'm using powerdynamo, jaguar and powersite. I'm getting the error on a datawindow that has an update button on it, but I only get the error if the datawindow is updated twice. I added the Save/Update button in the datawindow painter. I'm using the defaults for most of the sybase html datawindow dtc and am using the generated code. I use a SESSION variable for the retrieval argument: ...

Update works in PB Datawindow Preview but not using dw.update() function
The following select statement will update successfully within the datawindow painter, when performing a preview, changing a value and updating the datawindow. But when running the application, changing the value and performing the .Update() function the data is unchanged in the database, however the return code is 1(successful): 1)The update properties of the datawindow are correct. 2)Inserting and Deleting rows work, but Updating and existing record does not work. 3)I also took out the UNION, thinking that may have something to do with it, NOT. Has anyone experienced this? ...

Datawindow update error
When I try to perform an update on my datawindow I receive an error: DataWindow does not have UPDATE capability I can't for the life of me understand what I've done to this datawindow to make it stop working. Here are some code snippets: WBool DetailForm::newBtn_Click( WObject * source, WEventData * event ) { nlResult = dw_1->InsertRow(0); if (nlResult > 0) { dw_1->ScrollToRow(nlNewRow); dw_1->SetColumn( "actionitems_statusid" ); } ...

Error when updating groups...
Hello everyone, I am trying to edit groups. When I clic on "Submit changes" button the next error is displayed: ------------------------------------------------- Updating groups Use of uninitialized value in string ne at D:\bugzilla-2.16.3\editgroups.cgi line 584 (#1) (W uninitialized) An undefined value was used as if it were already defined. It was interpreted as a "" or a 0, but maybe it was a mistake. To suppress this warning assign a defined value to your variables. To help you figure out what was undefined, perl tells you what operation you u...

Datawindow update error
When I try to perform an update on my datawindow I receive an error: DataWindow does not have UPDATE capability I can't for the life of me understand what I've done to this datawindow to make it stop working. Here are some code snippets: WBool DetailForm::newBtn_Click( WObject * source, WEventData * event ) { nlResult = dw_1->InsertRow(0); if (nlResult > 0) { dw_1->ScrollToRow(nlNewRow); dw_1->SetColumn( "actionitems_statusid" ); } ...

errors when datawindow updated
Anyone.... Help!!!!!!! When I update the information in datawindow, such as: deleting row, adding row, modified the information in a column or a row... then I use dw_1.update or dw_1.update(TRUE, FALSE). Sometimes, this is OK, but sometimes this gives me the error looked like the following: "Row changed between retrieve and update. No changes made to database" and this roll back. Does anyone know why this happen to me? Please give me the idea how to solve it. Thanks a lot. Tuan In article <370ABBD2.EC943674@theglobe.com>, ameritrust@theglobe.com says... ...

PB update in datawindow
When i try to Update a datawindow which has a computed column say X, it gives me a datawindow error on update saying Column X not found in database. Any ideas on how to rectify this error? Go Rows / Update Properties in the painter and remove the selection of that column from the Updatable Columns list. Good luck, Terry and Sequel the techno-kitten On 9 Aug 2009 23:32:27 -0700, Nitin wrote: >When i try to Update a datawindow which has a computed >column say X, it gives me a datawindow error on update >saying Column X not found in database. >Any ideas on how to ...

Datawindow Update Error
Hi I am using PB 7.0.2 Build 8025 with Sybase Adaptive Server Enterprise 11.9.2. I have a table with a column of "text" type. If I try to update the table using the text column in the where clause, I get the following message: Implicit conversion from datatype 'TEXT' to 'VARCHAR' is not allowed. Is there some work-around? TIA Ved Sorry I have no answer for your question, but i have seen, that you have a Path 7.0.2. I can't find this patch. Can you give me the location? Thanks for help Gogo Vedswarup Rai <vedsr@iname.com> sc...

pb datawindow group
Hello, I have a datawindow with 2 groups (break), when i use setfilter, the sum of the diferent group are not right, what can i do ? (powerbuilder 6.0) thank you Bruno MORLANS <b.morlans@s3g.fr> wrote: >I have a datawindow with 2 groups (break), when i use setfilter, the sum >of the diferent group are not right, what can i do ? Execute a GroupCalc ( ) after the SetFilter ( ). --- Craig Wagner | E-mail: cwagner@metacorp.com CPD Professional | Web: http://www.metacorp.com Certified Powersoft Instructor | Phone: (503) 452-634...

Web resources about - Group Update Datawindow by PB NVO Compoent Sometimes Error - sybase.easerver.general

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Intelligent Versus Surrogate Keys
Should I use business columns as primary key fields for tables in thedatabase, or generate artificial primary key values? When business-related ...

chevy volt
ProEXR File Description =Attributes= channels (chlist) compression (compression): Zip dataWindow (box2i): [0, 0, 5119, 2475] displayWindow (box2i): ...

Enable - A comprehensive solution for the localization of PowerBuilder applications Untitled Document ...
Enable is localization/ translation tool used by PowerBuilder developers to make their applications multilingual.Enable is a powerful tool that ...

comp.lang.clipper.visual-objects - Google Groups
comp.lang.clipper.visual-objects 1-20 von 33006 Themen werden angezeigt Integrity of a file marcosm...@gmail.com 09:35 Combobox value Lu 08:12 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
Developers can choose Win32 or newer style .Net development

PowerToTheBuilder - PowerBuilder UI Controls
HOME - COMPONENTS - PB UI DESIGNER - DOWNLOAD\PURCHASE - SUPPORT - FAQ - ABOUT Take Control of your UI with PB Ultimate Suite PowerToTheBuilder.com ...

Beautiful iPad Mini 3 Concept Reimagines Apple’s Tablet With iPhone 6 Design, Gold Color [Images]
The iPhone 6 may be grabbing all of the recent headlines due to its impending announcement, but spare a thought for those who prefer to stay ...

Java Networking - Real's HowTo
Real's HowTo Custom Search Java Language String and Number Applet AWT Swing Environment IO Javascript interaction JDBC Thread Networking JSP ...

Business Intelligence Products - Database Management, Data Warehousing & Mobility Software - Sybase Inc ...
Sybase offers a variety of Business Intelligence (BI) software like products for database management, data warehousing and mining, data integration ...

Resources last updated: 1/8/2016 8:50:42 PM