DataWindow ColType is wrong in DataWindow Object, how do I change it?
Problem: rows = dw_1.Retrieve() crashes (returns -1) I know why it's doing it but I can't fix it. Here is what I have found. Initially I created a DataWindow Object called d_geninfo which saves data to the GENINFO table. Then, some months later, I changed the HOMEOWNER column in the GENINFO table from Char(1) to Char(16) and I created a second DataWindow Object d_geninfo_preferred that accesses the same GENINFO table. If I save data using d_geninfo_preferred that is more than 1 character long and I later retrieve it into d_geninfo it crashes. Now the goofy part. I go into the d_geninfo object and view the table and it does indeed show that the column is Char(16) but if I look at the ColType while the program is running (strg = dw_1.Object.homeowner.ColType) it shows Char(1). However, when I look at the ColType of d_geninfo_preferred it shows Char(16). My question is, how do I force d_geninfo to refresh itself with the correct table ColType? Thanks in advance, Greg
|
0 |
|
Greg
9/23/1999 12:19:07 AM
sybase.powerbuilder.objects
3160 articles. 
0 followers.
4 Replies
1369 Views
Export the datawindow and change the size manually. Then import it again. Changing is easy. you can see the column definitions at the beginning of the datawindow when you open the source code. You cannot miss it. -- Werner Warger PowerSolutions Austria Greg Heiner <gheiner@gmheng.com> schrieb in im Newsbeitrag: 37E971FB.93268F76@gmheng.com... > Problem: rows = dw_1.Retrieve() crashes (returns -1) > > I know why it's doing it but I can't fix it. Here is what I have found. > > Initially I created a DataWindow Object called d_geninfo which saves > data to the GENINFO table. Then, some months later, I changed the > HOMEOWNER column in the GENINFO table from Char(1) to Char(16) and I > created a second DataWindow Object d_geninfo_preferred that accesses the > same GENINFO table. If I save data using d_geninfo_preferred that is > more than 1 character long and I later retrieve it into d_geninfo it > crashes. > > Now the goofy part. I go into the d_geninfo object and view the table > and it does indeed show that the column is Char(16) but if I look at the > ColType while the program is running (strg = > dw_1.Object.homeowner.ColType) it shows Char(1). However, when I look > at the ColType of d_geninfo_preferred it shows Char(16). > > My question is, how do I force d_geninfo to refresh itself with the > correct table ColType? > > Thanks in advance, > Greg > > >
|
|
0 |
|
Werner
9/23/1999 7:10:57 AM
A more easy way, open the dataobject. and then open data source in graphical mode, just reselect the column(homeowner). then check the column specification. Greg Heiner wrote: > Problem: rows = dw_1.Retrieve() crashes (returns -1) > > I know why it's doing it but I can't fix it. Here is what I have found. > > Initially I created a DataWindow Object called d_geninfo which saves > data to the GENINFO table. Then, some months later, I changed the > HOMEOWNER column in the GENINFO table from Char(1) to Char(16) and I > created a second DataWindow Object d_geninfo_preferred that accesses the > same GENINFO table. If I save data using d_geninfo_preferred that is > more than 1 character long and I later retrieve it into d_geninfo it > crashes. > > Now the goofy part. I go into the d_geninfo object and view the table > and it does indeed show that the column is Char(16) but if I look at the > ColType while the program is running (strg = > dw_1.Object.homeowner.ColType) it shows Char(1). However, when I look > at the ColType of d_geninfo_preferred it shows Char(16). > > My question is, how do I force d_geninfo to refresh itself with the > correct table ColType? > > Thanks in advance, > Greg
|
|
0 |
|
chan
9/27/1999 3:06:31 PM
HI, It's so simple.. Open the datawindow into the painter. Then open the sql painter of this datawindow. Insert some blankspace or any charecter, then remove those, now close the sql painter and datawindow painter with save. This would've changed the coltype property of your datawindow column to the exact column property in the database, now it'll work fine. Riluvan. Greg Heiner wrote: > Problem: rows = dw_1.Retrieve() crashes (returns -1) > > I know why it's doing it but I can't fix it. Here is what I have found. > > Initially I created a DataWindow Object called d_geninfo which saves > data to the GENINFO table. Then, some months later, I changed the > HOMEOWNER column in the GENINFO table from Char(1) to Char(16) and I > created a second DataWindow Object d_geninfo_preferred that accesses the > same GENINFO table. If I save data using d_geninfo_preferred that is > more than 1 character long and I later retrieve it into d_geninfo it > crashes. > > Now the goofy part. I go into the d_geninfo object and view the table > and it does indeed show that the column is Char(16) but if I look at the > ColType while the program is running (strg = > dw_1.Object.homeowner.ColType) it shows Char(1). However, when I look > at the ColType of d_geninfo_preferred it shows Char(16). > > My question is, how do I force d_geninfo to refresh itself with the > correct table ColType? > > Thanks in advance, > Greg
|
|
0 |
|
rizwan5
11/6/1999 2:18:49 PM
Hi again. Also , can use Extended Attribute syncronizer. Riluvan. Greg Heiner wrote: > Problem: rows = dw_1.Retrieve() crashes (returns -1) > > I know why it's doing it but I can't fix it. Here is what I have found. > > Initially I created a DataWindow Object called d_geninfo which saves > data to the GENINFO table. Then, some months later, I changed the > HOMEOWNER column in the GENINFO table from Char(1) to Char(16) and I > created a second DataWindow Object d_geninfo_preferred that accesses the > same GENINFO table. If I save data using d_geninfo_preferred that is > more than 1 character long and I later retrieve it into d_geninfo it > crashes. > > Now the goofy part. I go into the d_geninfo object and view the table > and it does indeed show that the column is Char(16) but if I look at the > ColType while the program is running (strg = > dw_1.Object.homeowner.ColType) it shows Char(1). However, when I look > at the ColType of d_geninfo_preferred it shows Char(16). > > My question is, how do I force d_geninfo to refresh itself with the > correct table ColType? > > Thanks in advance, > Greg
|
|
0 |
|
rizwan5
11/6/1999 2:19:50 PM
Similar Artilces:
datawindow.object.datawindow.objects ?
Hi? I used this syntax in PB9, how to use in datawindow.net with C#? string ls_objects ls_objects = string(datawindow.object.datawindow.objects) I hope to get a list of the controls in the datawindow objects. TIA ..Describe("DataWindow.Objects") On 5 Jan 2006 23:30:30 -0800, "Robert" <jooong@empal.com> wrote: >Hi? > >I used this syntax in PB9, how to use in datawindow.net with C#? > >string ls_objects >ls_objects = string(datawindow.object.datawindow.objects) > >I hope to get a list of the controls in the dataw...
Use DataWindow Object Properties in DataWindow Object Expression
Hi all, Can I make use of the properties of objects in the expression? For example, can I set an expression in COLUMN_A's color property which reference the color property of COLUMN_B. I don't know how to access properties in expressions. Can anyone help me? Thanks. Alex You can use the Describe() function. Alex wrote in message <362D543F.F34B5F33@hotmail.com>... >Hi all, > Can I make use of the properties of objects in the expression? >For example, can I set an expression in COLUMN_A's color property which >reference the color property of...
DataWindows and datawindow objects
Difference between Datawindow and datawindowobjects? - datawindow is a control on a userobject or a window - datawindowobject (DWObject) is a control within a datawindow, defined in the dataobject of the datawindow. You refer to it as <datawindow-instance>.Object.<datawindow object> HTH, Ben (bede) <Santhoshi> wrote in message news:3f8bee8b.4631.846930886@sybase.com... > Difference between Datawindow and datawindowobjects? Not exactly; DW Control is a "container" that reserves real-estate on the surface of a visual object. DW Obj...
Change the transaction object of a child datawindow object
Is it possible to change the transaction object of a child datawindow that is associated to a field using drop down datawindow ? ( I would like to use another database connection for the datawindow object ) Following is my logic : ---------------------- 1. Get the handle to the child datawindow. 2. Change the transaction object using of_SetTransObject(Transaction Object) 3. Retrieve() Following is my scenario ------------------------ 1. I have one datawindow say, dw_1. This has a datawindow object that is based on SQLCA transaction object. 2. I have a single Data Window, ...
Creating objects in Datawindow Object
Dear Friends, Is it possible to create objects dynamically in a Datawindow object. For example in runtime I want to create 10 picture boxes in datawindow object in a freeform presentation style... My aim is to design a conference hall using datawindow. Is there any other better solution for this. Before I have created separate user objects and shown in the window and allowed client to design as per the requirement but in that method I was not able to take printout of entire design. Please suggest me in this regard, thanks in advance Hi John, yes, this is possible. ...
Objects Selection in Datawindow Objects
PowerBuilder 10 crashes when I try to select one or more objects in Datawindow Objects. Why is it so? Can someone help me please. This was posted some time ago and is related to PB 10.0.1 EBF build 6044 (you might want to check it's your case): "Andy Turiansky [TeamSybase]" wrote in message news:41ecf0f7@forums-1-dub... > Have you reported this yet? ANd it is not jsut on a DataWindow. I selected a> commandbutton and a SLE.... whoop! > > On 18 Jan 2005 01:04:30 -0800, > in sybase.public.powerbuilder.general > Lilian Pigallio <lpigallio@no...
Draggin Objects in Datawindow object
Hi all, I have created a picture box object in a datawindow object,a and set the property movable & resize TRUE. When object is dragged, how can I take the X,Y,Width & height properties. When the object is dragged, when the user releases left mouse button...immdly I want to take X & Y coordinates and same for the width & height properties also. Thanks in advance for any help Please don't cross post. On 11 Jul 2006 02:10:03 -0700, John Smith wrote: >Hi all, > >I have created a picture box object in a datawindow object,a >and set the proper...
Report object in the DataWindow Object
Hello all...We have PB9.03 and I am trying to create a Report Object within my DataWindow Object. My question is whether there is any way that a Report Object can have a Horizontal and Vertical Scrollbar? I've tried everything and don't seem to be able to produce one. > Hello all...We have PB9.03 and I am trying to create a > Report Object within my DataWindow Object. My question is > whether there is any way that a Report Object can have a > Horizontal and Vertical Scrollbar? Nope, there isn't any way ...
Describe("DataWindow.Objects") Functionality for Report DataWindow object Doesn't Work
Hello there. I want to change the nested report object(s) attributes. I had used Describe() function to get objects -("DataWindow.Objects"). After removing the tab spaces I was able to get the object name within that DW. By checking the Attributes -(ls_obj + ".Attributes") I came to know by finding "nested_argument" that the current object is (nested) report. Now if I assigned this object to the DDDWChild/Any variable it gives error either at compilation or at run time. If I created a datastore locally & assigned the dataobject of the current ...
Help!!! Assign Datawindow into Datawindow object
Usually I used to assign a datawindow (dw_train) in a datawindow object (dw_1) in a window is go to propertise of datawindow object and browse for datawindow. My Question:- How to this action into pb script? If you want to assign datawindow 'd_my_dw' to a dw control dw_1 in your script, you would say dw_1.DataObject = 'd_my_dw' If you are going to make an executable, do not forget to include d_my_dw in your resource file. On Fri, 04 Dec 1998 07:34:37 -0500, in powersoft.public.powerbuilder.powerscript CKS21 <cks21@tm.net.my> wrote: >Usually I used to...
Binding DataWindow object to DataWindow control
When we create a datawindow object we can bind it to datawindow control which actually i dont know to do, so i have dragged and dropped the objects onto a window then the source code generated is something like this dw_window is my window dw_1 is datawindow object on the window forward global type dw_window from window end type type st_1 from statictext within dw_window end type type dw_1 from datawindow within dw_window end type end forward What this line of code specify? type dw_1 from datawindow within dw_window Is it that by dragging and dropping it automatically cr...
Datawindow Object
Dear all, i am having one application, which will export and import the datawindow obejcts into a pbl, using libraryexport and libraryimport, i am not attaching this pbl on this application. If some user is using the datawindow object using infomaker, i dont want to export or import the datawindow object. How to find out the datawindow object is in use? any idea Regards M.S.Mylraj Try not to cross-post. -EGM Mylraj Subbiah <mylrajms@batelco.com.bh> wrote in message news:h0xDIVjvBHA.328@forums.sybase.com... > Dear all, > > i am having o...
problem with dw_1.object.datawindow.objects
Hi all, I am using PB 6.51 and have the following strange behaviour. In a tabular DW, I paste twice the same column, giving to each a different name . If I ask dw_1.object.datawindow.objects or the equivalent describe property, I get the secondly pasted column twice in the list .... And of course, in the DW and in the export, the two objects are unique. The problem is that PB does not like when I am trying to access the 'duplicate' column .... by dot notation or by getitem... notation ... Any ideas ? Thanks Philip ...
Converting datawindow objects to datawindow .Net
Hi, Can someone please list the various methods we can use to convert the standard datawindow object to a datawindow .net object ? Thanks, Sanjay I'm lost. There's no conversion necessary. PB and DW.Net use the same datawindow objects. On 19 Feb 2007 17:46:15 -0800, Converting wrote: >Hi, > >Can someone please list the various methods we can use to >convert the standard datawindow object to a datawindow .net >object ? > >Thanks, > >Sanjay Thanks Bruce. I probably confused you but good to know that we can modify the datawin...
Hi? I used this syntax in PB9, how to use in datawindow.net with C#? string ls_objects ls_objects = string(datawindow.object.datawindow.objects) I hope to get a list of the controls in the datawindow objects. TIA ..Describe("DataWindow.Objects") On 5 Jan 2006 23:30:30 -0800, "Robert" <jooong@empal.com> wrote: >Hi? > >I used this syntax in PB9, how to use in datawindow.net with C#? > >string ls_objects >ls_objects = string(datawindow.object.datawindow.objects) > >I hope to get a list of the controls in the dataw...
Use DataWindow Object Properties in DataWindow Object Expression
Hi all, Can I make use of the properties of objects in the expression? For example, can I set an expression in COLUMN_A's color property which reference the color property of COLUMN_B. I don't know how to access properties in expressions. Can anyone help me? Thanks. Alex You can use the Describe() function. Alex wrote in message <362D543F.F34B5F33@hotmail.com>... >Hi all, > Can I make use of the properties of objects in the expression? >For example, can I set an expression in COLUMN_A's color property which >reference the color property of...
DataWindows and datawindow objects
Difference between Datawindow and datawindowobjects? - datawindow is a control on a userobject or a window - datawindowobject (DWObject) is a control within a datawindow, defined in the dataobject of the datawindow. You refer to it as <datawindow-instance>.Object.<datawindow object> HTH, Ben (bede) <Santhoshi> wrote in message news:3f8bee8b.4631.846930886@sybase.com... > Difference between Datawindow and datawindowobjects? Not exactly; DW Control is a "container" that reserves real-estate on the surface of a visual object. DW Obj...
Change the transaction object of a child datawindow object
Is it possible to change the transaction object of a child datawindow that is associated to a field using drop down datawindow ? ( I would like to use another database connection for the datawindow object ) Following is my logic : ---------------------- 1. Get the handle to the child datawindow. 2. Change the transaction object using of_SetTransObject(Transaction Object) 3. Retrieve() Following is my scenario ------------------------ 1. I have one datawindow say, dw_1. This has a datawindow object that is based on SQLCA transaction object. 2. I have a single Data Window, ...
Creating objects in Datawindow Object
Dear Friends, Is it possible to create objects dynamically in a Datawindow object. For example in runtime I want to create 10 picture boxes in datawindow object in a freeform presentation style... My aim is to design a conference hall using datawindow. Is there any other better solution for this. Before I have created separate user objects and shown in the window and allowed client to design as per the requirement but in that method I was not able to take printout of entire design. Please suggest me in this regard, thanks in advance Hi John, yes, this is possible. ...
Objects Selection in Datawindow Objects
PowerBuilder 10 crashes when I try to select one or more objects in Datawindow Objects. Why is it so? Can someone help me please. This was posted some time ago and is related to PB 10.0.1 EBF build 6044 (you might want to check it's your case): "Andy Turiansky [TeamSybase]" wrote in message news:41ecf0f7@forums-1-dub... > Have you reported this yet? ANd it is not jsut on a DataWindow. I selected a> commandbutton and a SLE.... whoop! > > On 18 Jan 2005 01:04:30 -0800, > in sybase.public.powerbuilder.general > Lilian Pigallio <lpigallio@no...
Draggin Objects in Datawindow object
Hi all, I have created a picture box object in a datawindow object,a and set the property movable & resize TRUE. When object is dragged, how can I take the X,Y,Width & height properties. When the object is dragged, when the user releases left mouse button...immdly I want to take X & Y coordinates and same for the width & height properties also. Thanks in advance for any help Please don't cross post. On 11 Jul 2006 02:10:03 -0700, John Smith wrote: >Hi all, > >I have created a picture box object in a datawindow object,a >and set the proper...
Report object in the DataWindow Object
Hello all...We have PB9.03 and I am trying to create a Report Object within my DataWindow Object. My question is whether there is any way that a Report Object can have a Horizontal and Vertical Scrollbar? I've tried everything and don't seem to be able to produce one. > Hello all...We have PB9.03 and I am trying to create a > Report Object within my DataWindow Object. My question is > whether there is any way that a Report Object can have a > Horizontal and Vertical Scrollbar? Nope, there isn't any way ...
Describe("DataWindow.Objects") Functionality for Report DataWindow object Doesn't Work
Hello there. I want to change the nested report object(s) attributes. I had used Describe() function to get objects -("DataWindow.Objects"). After removing the tab spaces I was able to get the object name within that DW. By checking the Attributes -(ls_obj + ".Attributes") I came to know by finding "nested_argument" that the current object is (nested) report. Now if I assigned this object to the DDDWChild/Any variable it gives error either at compilation or at run time. If I created a datastore locally & assigned the dataobject of the current ...
Help!!! Assign Datawindow into Datawindow object
Usually I used to assign a datawindow (dw_train) in a datawindow object (dw_1) in a window is go to propertise of datawindow object and browse for datawindow. My Question:- How to this action into pb script? If you want to assign datawindow 'd_my_dw' to a dw control dw_1 in your script, you would say dw_1.DataObject = 'd_my_dw' If you are going to make an executable, do not forget to include d_my_dw in your resource file. On Fri, 04 Dec 1998 07:34:37 -0500, in powersoft.public.powerbuilder.powerscript CKS21 <cks21@tm.net.my> wrote: >Usually I used to...
Binding DataWindow object to DataWindow control
When we create a datawindow object we can bind it to datawindow control which actually i dont know to do, so i have dragged and dropped the objects onto a window then the source code generated is something like this dw_window is my window dw_1 is datawindow object on the window forward global type dw_window from window end type type st_1 from statictext within dw_window end type type dw_1 from datawindow within dw_window end type end forward What this line of code specify? type dw_1 from datawindow within dw_window Is it that by dragging and dropping it automatically cr...
Datawindow Object
Dear all, i am having one application, which will export and import the datawindow obejcts into a pbl, using libraryexport and libraryimport, i am not attaching this pbl on this application. If some user is using the datawindow object using infomaker, i dont want to export or import the datawindow object. How to find out the datawindow object is in use? any idea Regards M.S.Mylraj Try not to cross-post. -EGM Mylraj Subbiah <mylrajms@batelco.com.bh> wrote in message news:h0xDIVjvBHA.328@forums.sybase.com... > Dear all, > > i am having o...
problem with dw_1.object.datawindow.objects
Hi all, I am using PB 6.51 and have the following strange behaviour. In a tabular DW, I paste twice the same column, giving to each a different name . If I ask dw_1.object.datawindow.objects or the equivalent describe property, I get the secondly pasted column twice in the list .... And of course, in the DW and in the export, the two objects are unique. The problem is that PB does not like when I am trying to access the 'duplicate' column .... by dot notation or by getitem... notation ... Any ideas ? Thanks Philip ...
Converting datawindow objects to datawindow .Net
Hi, Can someone please list the various methods we can use to convert the standard datawindow object to a datawindow .net object ? Thanks, Sanjay I'm lost. There's no conversion necessary. PB and DW.Net use the same datawindow objects. On 19 Feb 2007 17:46:15 -0800, Converting wrote: >Hi, > >Can someone please list the various methods we can use to >convert the standard datawindow object to a datawindow .net >object ? > >Thanks, > >Sanjay Thanks Bruce. I probably confused you but good to know that we can modify the datawin...
Web resources about - DataWindow ColType is wrong in DataWindow Object, how do I change it? - sybase.powerbuilder.objects 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 ...
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 ...
Should I use business columns as primary key fields for tables in thedatabase, or generate artificial primary key values? When business-related ...
chevy voltProEXR 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 ...
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 ...
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 .NetDevelopers 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 ...
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 ...
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 ...
Sybase offers a variety of Business Intelligence (BI) software like products for database management, data warehousing and mining, data integration ...
Resources last updated: 1/7/2016 7:04:35 PM