Hi friends,

can you help me with my problem?

I tried to create a dw to set different price level for different item.
but cannot update the dw.


I created a datawindow with the following sql syntax:
  SELECT
         "itempricelevel"."iplevelid",
         "itempricelevel"."plevelid",
         "itempricelevel"."itemid",
         "itempricelevel"."customprice",
         "item"."itemprice",
         "item"."boughtprice",
         "item"."itemnm"
    FROM {oj "itempricelevel" RIGHT OUTER JOIN "item" ON
"itempricelevel"."itemid" = "item"."itemid"}

and then put that datawindow into dw_2 control.


The following is the script to update dw_2:

int ii
long ll_row, ll_result
string ls_result

for ii = 1 to dw_2.rowcount( )

  ls_result = dw_2.inv_base.of_getitem(ii, "customprice")

 if ls_result = "" then
  ll_result = dw_2.deleterow(ii)
 else
  if dw_2.inv_base.of_getitem(ii, "plevelid") = "" then
   ll_result = dw_2.inv_base.of_setitem (ii, "plevelid", "13")
  end if
 end if
next

ll_result = dw_2.update()
if ll_result <> 1 then
 messagebox("error", "saved failed")
 sqlca.of_rollback()
else
 sqlca.of_commit()
 messagebox("error", "saved success")

end if


The update failed and returned:
-----------------------------------------------------------------------
A database error has occurred
Database error code = -3

database error message:
row changed between retrieve and update

no changes made to the database

DELETE FROM "itempricelevel" where "iplevelid" IS NULL
------------------------------------------------------------------------


many thanks in advance,
rony

no need to comment on this, i've changed the logic and it worked !

thanks,
rony
"Rony Santoso" <rony_xg@yahoo.de> wrote in message
news:4204efe4@forums-2-dub...
> Hi friends,
>
> can you help me with my problem?
>
> I tried to create a dw to set different price level for different item.
> but cannot update the dw.
>
>
> I created a datawindow with the following sql syntax:
>   SELECT
>          "itempricelevel"."iplevelid",
>          "itempricelevel"."plevelid",
>          "itempricelevel"."itemid",
>          "itempricelevel"."customprice",
>          "item"."itemprice",
>          "item"."boughtprice",
>          "item"."itemnm"
>     FROM {oj "itempricelevel" RIGHT OUTER JOIN "item" ON
> "itempricelevel"."itemid" = "item"."itemid"}
>
> and then put that datawindow into dw_2 control.
>
>
> The following is the script to update dw_2:
>
> int ii
> long ll_row, ll_result
> string ls_result
>
> for ii = 1 to dw_2.rowcount( )
>
>   ls_result = dw_2.inv_base.of_getitem(ii, "customprice")
>
>  if ls_result = "" then
>   ll_result = dw_2.deleterow(ii)
>  else
>   if dw_2.inv_base.of_getitem(ii, "plevelid") = "" then
>    ll_result = dw_2.inv_base.of_setitem (ii, "plevelid", "13")
>   end if
>  end if
> next
>
> ll_result = dw_2.update()
> if ll_result <> 1 then
>  messagebox("error", "saved failed")
>  sqlca.of_rollback()
> else
>  sqlca.of_commit()
>  messagebox("error", "saved success")
>
> end if
>
>
> The update failed and returned:
> -----------------------------------------------------------------------
> A database error has occurred
> Database error code = -3
>
> database error message:
> row changed between retrieve and update
>
> no changes made to the database
>
> DELETE FROM "itempricelevel" where "iplevelid" IS NULL
> ------------------------------------------------------------------------
>
>
> many thanks in advance,
> rony
>
>

This is a multi-part message in MIME format.
--------------090809060401040908030601
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

are you sure the error went away because of any change you made ?
The -3 is the classic Optimistic Concurrency control error.  PB adds a 
few other columns to the where clause of the update statement. If 
another process has changed the record while your user was filling in 
the DW, then the update finds nothing. Internally, PB checks the 
@@rowcount, and if it is zero, then you get the -3 error.

Rony Santoso wrote:

>no need to comment on this, i've changed the logic and it worked !
>
>thanks,
>rony
>"Rony Santoso" <rony_xg@yahoo.de> wrote in message
>news:4204efe4@forums-2-dub...
>  
>
>>Hi friends,
>>
>>can you help me with my problem?
>>
>>I tried to create a dw to set different price level for different item.
>>but cannot update the dw.
>>
>>
>>I created a datawindow with the following sql syntax:
>>  SELECT
>>         "itempricelevel"."iplevelid",
>>         "itempricelevel"."plevelid",
>>         "itempricelevel"."itemid",
>>         "itempricelevel"."customprice",
>>         "item"."itemprice",
>>         "item"."boughtprice",
>>         "item"."itemnm"
>>    FROM {oj "itempricelevel" RIGHT OUTER JOIN "item" ON
>>"itempricelevel"."itemid" = "item"."itemid"}
>>
>>and then put that datawindow into dw_2 control.
>>
>>
>>The following is the script to update dw_2:
>>
>>int ii
>>long ll_row, ll_result
>>string ls_result
>>
>>for ii = 1 to dw_2.rowcount( )
>>
>>  ls_result = dw_2.inv_base.of_getitem(ii, "customprice")
>>
>> if ls_result = "" then
>>  ll_result = dw_2.deleterow(ii)
>> else
>>  if dw_2.inv_base.of_getitem(ii, "plevelid") = "" then
>>   ll_result = dw_2.inv_base.of_setitem (ii, "plevelid", "13")
>>  end if
>> end if
>>next
>>
>>ll_result = dw_2.update()
>>if ll_result <> 1 then
>> messagebox("error", "saved failed")
>> sqlca.of_rollback()
>>else
>> sqlca.of_commit()
>> messagebox("error", "saved success")
>>
>>end if
>>
>>
>>The update failed and returned:
>>-----------------------------------------------------------------------
>>A database error has occurred
>>Database error code = -3
>>
>>database error message:
>>row changed between retrieve and update
>>
>>no changes made to the database
>>
>>DELETE FROM "itempricelevel" where "iplevelid" IS NULL
>>------------------------------------------------------------------------
>>
>>
>>many thanks in advance,
>>rony
>>
>>
>>    
>>
>
>
>  
>

--------------090809060401040908030601
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
are you sure the error went away because of any change you made ?<br>
The -3 is the classic Optimistic Concurrency control error.&nbsp; PB adds a
few other columns to the where clause of the update statement. If
another process has changed the record while your user was filling in
the DW, then the update finds nothing. Internally, PB checks the
@@rowcount, and if it is zero, then you get the -3 error.<br>
<br>
Rony Santoso wrote:<br>
<blockquote type="cite" cite="mid42070bf7@forums-1-dub">
  <pre wrap="">no need to comment on this, i've changed the logic and it worked !

thanks,
rony
"Rony Santoso" <a class="moz-txt-link-rfc2396E" href="mailto:rony_xg@yahoo.de">&lt;rony_xg@yahoo.de&gt;</a> wrote in message
<a class="moz-txt-link-freetext" href="news:4204efe4@forums-2-dub">news:4204efe4@forums-2-dub</a>...
  </pre>
  <blockquote type="cite">
    <pre wrap="">Hi friends,

can you help me with my problem?

I tried to create a dw to set different price level for different item.
but cannot update the dw.


I created a datawindow with the following sql syntax:
  SELECT
         "itempricelevel"."iplevelid",
         "itempricelevel"."plevelid",
         "itempricelevel"."itemid",
         "itempricelevel"."customprice",
         "item"."itemprice",
         "item"."boughtprice",
         "item"."itemnm"
    FROM {oj "itempricelevel" RIGHT OUTER JOIN "item" ON
"itempricelevel"."itemid" = "item"."itemid"}

and then put that datawindow into dw_2 control.


The following is the script to update dw_2:

int ii
long ll_row, ll_result
string ls_result

for ii = 1 to dw_2.rowcount( )

  ls_result = dw_2.inv_base.of_getitem(ii, "customprice")

 if ls_result = "" then
  ll_result = dw_2.deleterow(ii)
 else
  if dw_2.inv_base.of_getitem(ii, "plevelid") = "" then
   ll_result = dw_2.inv_base.of_setitem (ii, "plevelid", "13")
  end if
 end if
next

ll_result = dw_2.update()
if ll_result &lt;&gt; 1 then
 messagebox("error", "saved failed")
 sqlca.of_rollback()
else
 sqlca.of_commit()
 messagebox("error", "saved success")

end if


The update failed and returned:
-----------------------------------------------------------------------
A database error has occurred
Database error code = -3

database error message:
row changed between retrieve and update

no changes made to the database

DELETE FROM "itempricelevel" where "iplevelid" IS NULL
------------------------------------------------------------------------


many thanks in advance,
rony


    </pre>
  </blockquote>
  <pre wrap=""><!---->

  </pre>
</blockquote>
</body>
</html>

--------------090809060401040908030601--

This is a multi-part message in MIME format.
--------------020001000607080400030909
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

are you sure the error went away because of any change you made ?
The -3 is the classic Optimistic Concurrency control error.  PB adds a 
few other columns to the where clause of the update statement. If 
another process has changed the record while your user was filling in 
the DW, then the update finds nothing. Internally, PB checks the 
@@rowcount, and if it is zero, then you get the -3 error.

Rony Santoso wrote:

>no need to comment on this, i've changed the logic and it worked !
>
>thanks,
>rony
>"Rony Santoso" <rony_xg@yahoo.de> wrote in message
>news:4204efe4@forums-2-dub...
>  
>
>>Hi friends,
>>
>>can you help me with my problem?
>>
>>I tried to create a dw to set different price level for different item.
>>but cannot update the dw.
>>
>>
>>I created a datawindow with the following sql syntax:
>>  SELECT
>>         "itempricelevel"."iplevelid",
>>         "itempricelevel"."plevelid",
>>         "itempricelevel"."itemid",
>>         "itempricelevel"."customprice",
>>         "item"."itemprice",
>>         "item"."boughtprice",
>>         "item"."itemnm"
>>    FROM {oj "itempricelevel" RIGHT OUTER JOIN "item" ON
>>"itempricelevel"."itemid" = "item"."itemid"}
>>
>>and then put that datawindow into dw_2 control.
>>
>>
>>The following is the script to update dw_2:
>>
>>int ii
>>long ll_row, ll_result
>>string ls_result
>>
>>for ii = 1 to dw_2.rowcount( )
>>
>>  ls_result = dw_2.inv_base.of_getitem(ii, "customprice")
>>
>> if ls_result = "" then
>>  ll_result = dw_2.deleterow(ii)
>> else
>>  if dw_2.inv_base.of_getitem(ii, "plevelid") = "" then
>>   ll_result = dw_2.inv_base.of_setitem (ii, "plevelid", "13")
>>  end if
>> end if
>>next
>>
>>ll_result = dw_2.update()
>>if ll_result <> 1 then
>> messagebox("error", "saved failed")
>> sqlca.of_rollback()
>>else
>> sqlca.of_commit()
>> messagebox("error", "saved success")
>>
>>end if
>>
>>
>>The update failed and returned:
>>-----------------------------------------------------------------------
>>A database error has occurred
>>Database error code = -3
>>
>>database error message:
>>row changed between retrieve and update
>>
>>no changes made to the database
>>
>>DELETE FROM "itempricelevel" where "iplevelid" IS NULL
>>------------------------------------------------------------------------
>>
>>
>>many thanks in advance,
>>rony
>>
>>
>>    
>>
>
>
>  
>

--------------020001000607080400030909
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
are you sure the error went away because of any change you made ?<br>
The -3 is the classic Optimistic Concurrency control error.&nbsp; PB adds a
few other columns to the where clause of the update statement. If
another process has changed the record while your user was filling in
the DW, then the update finds nothing. Internally, PB checks the
@@rowcount, and if it is zero, then you get the -3 error.<br>
<br>
Rony Santoso wrote:<br>
<blockquote type="cite" cite="mid42070bf7@forums-1-dub">
  <pre wrap="">no need to comment on this, i've changed the logic and it worked !

thanks,
rony
"Rony Santoso" <a class="moz-txt-link-rfc2396E" href="mailto:rony_xg@yahoo.de">&lt;rony_xg@yahoo.de&gt;</a> wrote in message
<a class="moz-txt-link-freetext" href="news:4204efe4@forums-2-dub">news:4204efe4@forums-2-dub</a>...
  </pre>
  <blockquote type="cite">
    <pre wrap="">Hi friends,

can you help me with my problem?

I tried to create a dw to set different price level for different item.
but cannot update the dw.


I created a datawindow with the following sql syntax:
  SELECT
         "itempricelevel"."iplevelid",
         "itempricelevel"."plevelid",
         "itempricelevel"."itemid",
         "itempricelevel"."customprice",
         "item"."itemprice",
         "item"."boughtprice",
         "item"."itemnm"
    FROM {oj "itempricelevel" RIGHT OUTER JOIN "item" ON
"itempricelevel"."itemid" = "item"."itemid"}

and then put that datawindow into dw_2 control.


The following is the script to update dw_2:

int ii
long ll_row, ll_result
string ls_result

for ii = 1 to dw_2.rowcount( )

  ls_result = dw_2.inv_base.of_getitem(ii, "customprice")

 if ls_result = "" then
  ll_result = dw_2.deleterow(ii)
 else
  if dw_2.inv_base.of_getitem(ii, "plevelid") = "" then
   ll_result = dw_2.inv_base.of_setitem (ii, "plevelid", "13")
  end if
 end if
next

ll_result = dw_2.update()
if ll_result &lt;&gt; 1 then
 messagebox("error", "saved failed")
 sqlca.of_rollback()
else
 sqlca.of_commit()
 messagebox("error", "saved success")

end if


The update failed and returned:
-----------------------------------------------------------------------
A database error has occurred
Database error code = -3

database error message:
row changed between retrieve and update

no changes made to the database

DELETE FROM "itempricelevel" where "iplevelid" IS NULL
------------------------------------------------------------------------


many thanks in advance,
rony


    </pre>
  </blockquote>
  <pre wrap=""><!---->

  </pre>
</blockquote>
</body>
</html>

--------------020001000607080400030909--