Hello, I made a according to the example of online pb11 webservice example, the client can see the data window, but can't update to update, can you tell me how to update?
A use the update function, there is error, : the database transaction information not available
Call SetTrans or SteTranobject function.
I am using pb11 + IIS + the.net application,
Now is the use of pb in the server and the client, the client calls the data window is successful, but cannot save a modified,

CodePudding user response:

1 if the database is connected
2 if dw set up transaction object, settransobject (sqlca)

CodePudding user response:

Database connection, now I will only use data storage call data window, in client how to call the server to connect to the database, also don't understand, so I won't be able to update, ever do pb11 webservice, give advice or comments please!!!!!

CodePudding user response:

Data storage call data window?
Use stored procedures? Should not, if it is, must first connect to the database do

The client how to invoke the server to connect to the database
This should be fixed by connecting to the server IP to implement it, haven't tried:)

CodePudding user response:

refer to the original poster WHBXHL posts:

hello, I made a according to the example of online pb11 webservice example, the client can see the data window, but can't update to update, can you tell me how to update?
A use the update function, there is error, : the database transaction information not available
Call SetTrans or SteTranobject function.
I am using pb11 + IIS + the.net application,
Now is the use of pb in the server and the client, the client calls the data window is successful, but modified can't save,

1. Must first connect to the database.
2. The data window to:
Dw_1. Settransobject (sqlca)
3. The table must have a primary key.

CodePudding user response:

May be I don't know, I'm a reference on the network routines do routine connections: http://www.mpinfo.com.tw/pdffile/9611PB_Tips.pdf

This routine, I've already finished, write very good oh, everyone can learn, I now update data window appear problem, the way it is now, the modified data in the data window, back to the server, delete the original data in a table, then import I returned data, preservation,

This is the most stupid way, and each data window I want to write a function that everyone made pb11 webservice, both, I will for you is not difficult, but I just contact, feel very difficult, hope everybody to help,

CodePudding user response:

Used PB11, highest version is PB10.5 now

CodePudding user response:

The dw to set the update properties as usual,
Web service for data source dw needs, set up web servicesupdate attribute
Again you set three web service (can be the same)
In this way, you generate insert, update, delete statements, such as
You are now set up a web servicesupdate attribute, then converted to call what you fill out the web service,
Just understand, very simple,

CodePudding user response:

Thank afic, I now through getchange function and setchange function, also can realize the update, the way you said, is under construction in the data window, select the web service data source, the inside of the configuration, how to set up?
And you put the data window on the server or client?

CodePudding user response:

refer to 6th floor sjq521521 response:

used PB11, is now the highest version PB10.5

Buddy, PB11.5 all out!!!

CodePudding user response:

Use web service on the client is not directly to the update operation of DW, retrieve also not line, unless it is web service do DW data source can be set in the way of AFIC accordingly after operation

General is to put the data to the service, and then in the service for the update operation

CodePudding user response:

Masters, now the problem has changed, I now the question is web service and application have been built, and then production. Net Windows forms application generated after the client, in the machine can run, on the other computer can not access, ie toolbar on my other computer input: http://202.202.202.126//pb_client/publish.htm, then, can display the version of the page, click here, after the pop-up dialog, said the application cannot be started, somehow,