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