Hi,

I´ve read in the post below that Ed says about configure a CFP to shows.

http://forum.strataframe.net/Topic17056-7-1.aspx

I configured my CFP and implemented this code below, but BD does not show my field on list.

''' <summary>

''' NOME DO VENDEDOR CUSTOM PROPERTY

''' </summary>

''' <remarks></remarks>

<Browsable(False), _

BusinessFieldDisplayInEditor(), _

Description("Nome do Vendedor"), _

DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _

Public ReadOnly Property [GET_ven_nome]() As System.String

Get

Dim loCommand As New SqlClient.SqlCommand()

'-- Build the command

loCommand.CommandText = "SELECT ven_nome from tb_vendedor where ven_cod = @ven_cod"

'-- Create and set the parameters

loCommand.Parameters.Add("@ven_cod", SqlDbType.Int)

loCommand.Parameters("@ven_cod").Value = Me.ven_cod

'-- Execute the query and return the value

Return CType(Me.ExecuteScalar(loCommand), String)

End Get

End Property

Some help?

Hi Luiz,



Glad you are moving forward, you will be surprise how nice this is handle by SF

Edhy Rijo

Ed,

Tks a lot again... surprise? no man, i´m ecstically
I came from Cobol, Delphi, Centura... but now.. SF... o GOSH!!!!! (Tks Trent!!!!!! :cool

Let´s come back to my problem..

1-) CFP was so slowly (I will implement view)
2-) There´s no way to search by CFP (the error is: The given key was not present in the dictionary), normal because the field does not exist in Sql table.
3-) I will implement a view to obtain performance, but I have problems with copy from BoView to FormBo because views has more columns than the original BO (boForm)

Can you help me?

Tks

Luiz,

The BrowseDialog control has two properties that allow you to override the table (or view in this case) that will be used to retrieve the records. They are the OverrideSearchTableName and OverrideSearchTableSchema (I think ).  Anyway, these two properties allow you to query a view or another table.  This feature gives you the ultimate flexibility in what to query server side including joining in tables, etc.  I have posted a link below on the forum to a thread I think you should read as well as a sample that may help.

http://forum.strataframe.net/FindPost24299.aspx

Trent,

The overidetable  property are available on version 1.6.6.0?

Tks

Hi Luiz!

You are sticking to an older version?

I will have to go back and look to see what version that was implemented, but I would strongly suggest moving to 1.7.0.6. There have been many new features and fixes since 1.6.6!

Ivan and Trent,

I should to move to new version but I have a lot of work to do in this moment, and also we use a USB NIC to share the same license
Sincerly, I´m afraid to change to new version, if my project stop it? (please don´t laught... but in other framework, this is a reallity).

PS: Sorry again by my english... rs

See ya