What's wrong with creating datawindow?

[Negator]

Hello all PowerBuilder wizards!

I use such code to create datawindow:

datawindow NewDw
long Code

NewDw = create datawindow
NewDw.DataObject = 'main_datawindow'
Code = NewDw.SetTransObject(SQLCA)
MessageBox('code', string(code))


It returns -1, so SetTransObject fails. However, I tried to create a datawindow control manually at design-time and use such code:

//datawindow NewDw
long Code

//NewDw = create datawindow
NewDw.DataObject = 'main_datawindow'
Code = NewDw.SetTransObject(SQLCA)
MessageBox('code', string(code))

As you guess it works! What is my mistake?
Thank you!!!

 

[mbalent]

Is the transaction object connected to the database at run time?

 

[Lekar]

Why do not you use a datastore?

Lenin.

 

[leyka]

1. In this case you should use Datasore instead of Datawindow:

datastore NewDw
long Code

NewDw = create datastore
NewDw.DataObject = 'dw_main'
Code = NewDw.SetTransObject(SQLCA)
MessageBox('code', string(code))

2. if you want to use Datawindow you can add this line:

/*CurrentWindow.&*/
OpenUserObject(NewDw,1,1)

and it looks like:

datawindow NewDw
long Code

NewDw = create datawindow
/*CurrentWindow.&*/
OpenUserObject( NewDw, 1,1)
NewDw.DataObject = 'main_datawindow'
Code = NewDw.SetTransObject(SQLCA)
MessageBox('code', string(code))