Setup Databrowser

[Former Member]

Hi,

I was trying to setup a databrowser but, has not been successful. I have setup UniqueID=txtTNo, Alias=TNo, TableName=@TBL and DataBound=True in screen painter. My code as follow:

Set oForm = SBO_Application.Forms(FormUID)

oForm.AutoManaged = True

oForm.SupportedModes = -1

oForm.Mode = fm_FIND_MODE

oForm.DataBrowser.BrowseBy = "txtTNo"

My concerns:

1. the browseby will generate an error "General Failure"

2. the navigation buttons are not enabled

3. how to link the navigation with UDO tables

I have searched the forum and try different solutions but, no luck.

I am using VB and would appreciate if someone could guide me through this. Thanks.

[Former Member · Accepted solution]

Adele,

1. You need to register a user-defined object. This is where your tables are linked. Have you done this?

>> I have registered the UDO and linked the 'documents' via wizard.

3. Do databinding in screen painter. I believe you've done this too. Also set the Object Type property of the form to the name of your user-defined object.

>> Do I bind all the items on the form?

4. Now set the properties in your original post in code.

>> Don't really get what you meant?

I'll try it out and keep you posted. Thanks.

[Former Member · Accepted solution]

1. Great

3. If you're having problems, start with just doing data binding on your main edit text boxes. (Like code and name), can expand if those are working. Based on your code you can start with just data binding your txtTNo field to the docnum field of your UDO.

4. Set the settings you had in your first post...

Set oForm = SBO_Application.Forms(FormUID)
oForm.AutoManaged = True
oForm.SupportedModes = -1
oForm.Mode = fm_FIND_MODE
oForm.DataBrowser.BrowseBy = "txtTNo"

Once you've got this you should be able to browse your data (navigation buttons should be enabled).

Adele