Updates to empty db fields cause pb error in exe

We are using jag with pb nvos -

during development it runs fine via the runman in pb but with the exe
updates to existing records - only when the column being updated was
retrieved with no data- cause a pb error and the app shuts down.  Nothing is
written to the log.  New records, adding additional data to already
populated columns, deletes of entire records and deletes of column data in
existing records all work fine.

We are using Oracle 8 with Oracle ODBC (because of the prob with native
drivers)

We are running Jag 3.5 no ebfs

- What trace facilities can we incorporate into a debug exe that might help
us track down the problem?

thanks,
j

--
Jenine Serviolo
757.865.8440 x116


0
Jenine
8/4/2000 3:21:26 PM
sybase.easerver 11371 articles. 0 followers. Follow

2 Replies
483 Views

Similar Articles

[PageSpeed] 13

You could try setting up and ODBC trace....

Jenine Serviolo wrote:

> We are using jag with pb nvos -
>
> during development it runs fine via the runman in pb but with the exe
> updates to existing records - only when the column being updated was
> retrieved with no data- cause a pb error and the app shuts down.  Nothing is
> written to the log.  New records, adding additional data to already
> populated columns, deletes of entire records and deletes of column data in
> existing records all work fine.
>
> We are using Oracle 8 with Oracle ODBC (because of the prob with native
> drivers)
>
> We are running Jag 3.5 no ebfs
>
> - What trace facilities can we incorporate into a debug exe that might help
> us track down the problem?
>
> thanks,
> j
>
> --
> Jenine Serviolo
> 757.865.8440 x116

0
Jim
8/4/2000 5:44:21 PM
Thanks Jim -

Now, how do I do that exactly?  We created a version of the exe that we are
calling debug and set up some stuff in PB but that hasn't given us any
clue...

Do we set up the ODBC trace in the ini file as part of the DBPARM?

TIA,
Jenine

I looked in the ODBC settings for the ORACLE ODBC system DSN but there is
not an option on there.
Jim O'Neil [Sybase] <joneil@sybase.com> wrote in message
news:398B00F5.90884A3@sybase.com...
> You could try setting up and ODBC trace....
>
> Jenine Serviolo wrote:
>
> > We are using jag with pb nvos -
> >
> > during development it runs fine via the runman in pb but with the exe
> > updates to existing records - only when the column being updated was
> > retrieved with no data- cause a pb error and the app shuts down.
Nothing is
> > written to the log.  New records, adding additional data to already
> > populated columns, deletes of entire records and deletes of column data
in
> > existing records all work fine.
> >
> > We are using Oracle 8 with Oracle ODBC (because of the prob with native
> > drivers)
> >
> > We are running Jag 3.5 no ebfs
> >
> > - What trace facilities can we incorporate into a debug exe that might
help
> > us track down the problem?
> >
> > thanks,
> > j
> >
> > --
> > Jenine Serviolo
> > 757.865.8440 x116
>


0
Jenine
8/7/2000 12:07:20 PM
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...

Error while update a record in a date field ( DB Null)
hi, I have a datagrid that contain a date field. if the field has a adate before I update the row, it make the update, but if a edit a record that has no date in the column field, I get the following error, any idea how to fix it. thanks Al Cast from type 'DBNull' to type 'Date' is not valid. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidCastException: Cast from type 'DBNull' to type 'Date' is no...

Error -312 when updating a record with a key containing an empty field
Error is: {code}EADDBEngineException with message '[FireDAC][Phys][IB] -312. Exact update affected [0] rows, while [1] was requested'.{code} Steps to reproduce: *On a Firerbird DB* lauch this script: {code}CREATE TABLE T ( CODICE VARCHAR(15) NOT NULL, FLAG VARCHAR(3) NOT NULL, DESC1 VARCHAR(60), CONSTRAINT PK_T PRIMARY KEY (CODICE,FLAG) ); GRANT ALL ON T TO SYSDBA WITH GRANT OPTION; COMMIT; INSERT INTO T (CODICE, FLAG, DESC1) VALUES ('1', '2', '3'); INSERT INTO T (CODICE, FLAG, DESC1) VALUES ('b', 'x', '2454564'...

Blob field get null when update table from PB DB painter
Hello everybody, I'm working with sqlserver 2005, I have a table with a blob field (image), it works fine (updateblob and selectblob), but when I make an update, in a field different that the blob field, from Powerbuilder Database painter the blob field get null. Thanks in advance PowerBuilder 10.2.1 Build 9948 SqlServer 2005 Blob field type Image ...

TADQuery with fields from 2 distinct tables gives error on update to DB [Edit]
Hi! Simple scenario: I have a grid showing the results of a TADQuery, this query is a select like Select T1.Name, T2.Code From T1, T2 Where T1.id=T2.id Well, the grid shows the data correctly, so far so good. When i edit this row in the grid and the TADQuery sends the changes made, i get a exception saying that the T2.Code field doesn't exist in the T1... Basically i cannot have fields from 2 different tables in the ADQuery and update a row... It seems that is trying to update the fieldnames of the 2 tables in the T1... wich does not make sense. The other thing that...

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...

dw.update() with OLE DB
Hi all, I am using PBL 9.0 and trying to convert my system from using MSSQL driver to OLE DB. In the system, when i need to update the db using a datawindow, i naturally use the update method: l_sql_code = dw.update() in case of success, dw.update() returns l_sql_code = 1, and in case of any db error, it returns l_sql_code = -1, and you simply write if l_sql_code = 1 then commit; if l_sql_code = -1 then rollback; this is the "standard" way to trap the db errors, which works fine with MSSQL driver. However, when i switch the system to the OLE DB driver, t...

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: >...

DB error when loading file into DB through PB but NOT thru ISQL
PB 6.5 w/ SQLAny 5.0 V5503 When I try to load a datafile into a table using the following script I got a db error: SQLCode -1 SQLCode 7006 Cannot convert 03/31/98 to a date Script in PB: ls_sql = "LOAD TABLE CONV_ASM " ls_sql += "FROM '" + sle_source.Text + "' " ls_sql += "FORMAT 'ASCII' " ls_sql += "QUOTES ON ESCAPES ON STRIP OFF " ls_sql += "DELIMITED BY ',' " EXECUTE Immediate :ls_SQL; And this is the chunk of data to be imported: "000000272","03/31/98",1,&qu...

Update causes errors
Name: CARMON BROOKS Email: bweezatyahoodotcom Product: Firefox Summary: Update causes errors Comments: The latest update that I received is preventing me from getting online through Mozilla Firefox. I don't know what it did or how to fix it. I can get online with Internet Explorer. Browser Details: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; IEMB3; IEMB3) ...

PB Error in .exe
Problem: We are getting an error when we run the .exe we created. We are using the non-native code method. The error does not occur when running from PB. Behaviour: This error is displayed upon opening our mdi frame. 'Unknown object type w_tm_tv_tablemnt at line 7 in function +pfc_open of object w_tm_frame.' The frame is attempting to open up a sheet when the frame itself is opened. Code from pfc_Open of w_tm_frame (line 7 is the OpenSheet statement): string ls_sheet w_sheet lw_sheet ls_sheet = Message.StringParm This.SetRedraw(false) OpenSheet(lw_shee...

Update field in db
May you help me guys. What is wrong with my update code? May you please fix it.  1  Dim actcode As String MyCommand.CommandText = "select * from member where MemberID='" & Session("strID") & "'" MyCommand.Connection = myConnection MyReader = MyCommand.ExecuteReader MyReader.Read() actcode = MyReader("Act_Code") MyReader.Close() If (actcode = Pword.Text) Then MyCommand.CommandText = "update memmber set " & _ " Counter='" & Replace(Label1.Text, "'", "''&quo...

Migrated PB 6.5 to 7.0, No Errors but CreatInstance() causes error 55??
Hello, I have just migrated our application from PB 6.5 to the latest version PB 7.0. During the migration and the rebuild of the application I received no errors. Some information about our application, we are currently using some distributed processing but will be shortly moving to N-tier using Jaguar. We use the createinstance( ) powerbuilder function to create the instance of the object on the distributed server (Its not a real server it actually runs as a separate application on the workstation but it does function as a distributed server). A snippet of my code: // create ...

Software Error: DBD::Pg::db do failed : ERROR: could not serialize access due to concurrent update
Software error: DBD::Pg::db do failed: ERROR: could not serialize access due to concurrent update [for Statement "DELETE FROM profile_search WHERE id = ?"] at Bugzilla/Search/Recent.pm line 67 Bugzilla::Search::Recent::create('Bugzilla::Search::Recent', 'HASH(0x7b21110)') called at Bugzilla/Search/Recent.pm line 75 Bugzilla::Search::Recent::create_placeholder('Bugzilla::Search::Recent') called at Bugzilla/CGI.pm line 448 Bugzilla::CGI::redirect_search_url('Bugzilla::CGI=HASH(0x7854b60)') called at /var/www/html/b...

Web resources about - Updates to empty db fields cause pb error in exe - sybase.easerver

Saturday Night Live Weekend Update Thursday - Wikipedia, the free encyclopedia
Saturday Night Live Weekend Update Thursday is an American limited-run series broadcast on NBC . It is a political satire news show spin-off ...

Gizmodo.com Updates
Nobody should have to use a pay phone , natural disaster or no natural disaster. So if your gadgets are out of juice after Sandy, here’s a tiny ...

Lifehacker.com Updates
By Whitson Gordon Ever run into a situation where you have multiple wireless networks available, but one is clearly better than the other? WiFi ...

Facebook Messenger For Android Update Includes Conversation Shortcuts
Facebook released an update to its Android Messenger application that incorporates the group -creation and message forwarding features in last ...

OneDrive’s latest update brings 3D Touch support, scoped folder search
Microsoft’s latest update for OneDrive adds a couple of new features into the mix, and sees the return of an old one, too. Support for Apple’s ...

Kickstarter learned of Zano collapse “through a bare-bones project update”
... by what’s happened with this project." We learned the news of the Zano bankruptcy the same way that you did—through a bare-bones project update. ...

Post-Racial America Update
The only thing I’m surprised about when it comes to five Black Lives Matter activists at a vigil in Minneapolis being shot last night by a couple ...

Microsoft confirms the Windows 10 November Update WAS pulled and this is why
Over the weekend we spotted that the Windows 10 November Update (aka Threshold 2) had been removed from the Media Creation Tool (MCT), and had ...

Windows 10 November update’s most annoying bug: Deleting apps without asking
Microsoft released its most significant update yet for Windows 10 update in November, but the software release isn’t bug-free. In fact, it seems ...

Is a potential eCommerce update upon us?
... we’ve been noticing some significant ranking changes, largely across the retail sector. My initial thoughts were that the latest Penguin update ...

Resources last updated: 11/25/2015 4:45:33 PM