StrataFrame Forum / StrataFrame Application Framework / Business Objects and Data Access (How do I?)

View in DDT with subquery

Angela Sampaio — Thu, 08 May 2008 13:37:50 GMT

Hello!

I'm trying to create a view with subquery in DDT but when I see the fields of view, appears only in the field you search subquery.

It has another way to achieve this?

Thank you

Speed of Stored Procedure

Bill Cunnien — Thu, 08 May 2008 11:08:08 GMT

I am not getting it. Earlier this spring I discussed in these forums the utilization of UDFs in filling a BO. The conclusion was to not use them since they have a great deal of overhead involved. So, instead, I went with some raw SQL to achieve the same results. I was able to get one of my more complex queries down to about 3 seconds. That was wonderful. Now, I am simply taking the same script that runs in the SQL Query Analyzer at 3 seconds and placing it into a stored procedure with three parameters. These parameters are declared at the beginning of the script in the query analyzer, too. I run the stored procedure and it takes many minutes to run (last run: 10 min 04 sec). I really don't get this. It is the exact same script. Is there really that much of a difference in quality between raw SQL script and the same SQL script placed into a stored procedure? What am I doing wrong? I have attached the script that I am running in the Query Analyzer and the stored procedure. I know that these are not pretty...I am still working through the details of this query. Any help, tips, criticism is welcome! :)

Thanks,
Bill

Increase Connection Timeout

Bill Cunnien — Thu, 08 May 2008 17:58:22 GMT

I have a query that is taking about 90 seconds. The window times out before any data is displayed. How do I increase the connection timeout for this query?

Thanks,
Bill

Bind a SF project to a particular data store?

Keith Chisarik — Fri, 09 May 2008 08:28:38 GMT

Is there a way currently to do this?

I now have more than one SF data store, one for internal projects, one for a large customer at their site I access via VPN, and one just for testing and training. If someone forgets to reset the store connection it can be a pain an lead to lost time while they or I figure out what is wrong, is there currenly anywhere I can override/set the SF Data Store used when a project is loaded via the solution file, code, or "smoke and mirrors" :)

Thanks

Move methods and filtering

Tim Dol — Thu, 08 May 2008 10:23:45 GMT

I'm not sure if I'm doing something wrong or discovered a small bug.

I have two related business objects on a form, Tasks and TaskPredecessors. I'm using 'MatchCurrentRow' on the ChildFilterRowMethod.

I am executing a routine to populate the 'Tasks' BO based on data from a temporary business object. Basically iterating through the temporary BO and creating new rows in the 'Tasks' BO. This works fine.

Once this routine has completed, I need to populate the 'TaskPredecessors' based on information in the Tasks BO. Basically I am creating dependencies between the tasks.

I am using a similar approach of iterating the Tasks BO...If MoveFirst... MoveNext.. and creating new rows in the TaskPrecedessors BO, however I am getting an error on the NewRow (Index 0 is either negative or above rows count).

I discovered that the Tasks filter property isn't changing as I iterate through the BO. The property holds the value of the last row from the initial population.

Should the Move methods be changing the filter property according to the parent primary key?

Thanks,

Tim

Best Practice for UpdateConcurrencyType?

Edhy Rijo — Tue, 06 May 2008 10:17:27 GMT

Hi,

What would be the best option to use between the RowVersion and TimeStamp for checking the concurrency type and why?

July Course - Travel Question

Gerard O Carroll — Tue, 06 May 2008 15:29:26 GMT

Hi.. non technical question. I am attending course in July, and one option , to get back home, is to take an Amtrak train from Dodge City to Chicago . Train leaves at midnight on Friday.

My question is.... will I make it to Dodge City(Via Hire Car or Greyhound bus if available) after the course finishes on Friday, bearing in mind Friday traffic etc. I understand it is about a two hour drive from Amarillo to Dodge City but have no idea if Friday -Weekend traffic will cause me any problems (or are there any other issuses which could delay me .

Any feedback appreciated.

Best Practice for LastModifiedUser and LastModifiedDate fields in a BO

Edhy Rijo — Tue, 06 May 2008 10:20:35 GMT

Hi,

For some tables it is very useful to have a fields that will tell the user when was the record changed and by who.

Is there anything in SF logic to auto update this kind of fields?
If these fields should be updated manually what would be the correct event to use to have these fields updated?

Thansk!

DBNULL...again

Keith Chisarik — Sun, 04 May 2008 22:34:31 GMT

Scenario:

I have inherited a table with two fields, one decimal, one string. These together represent the primary key. I need both fields on a maintenance form, bound to textboxes.

Display/Edit/Save is working. I cannot get a new record to add.

I get 'Conversion from type 'DBNull' to type 'String' is not valid.' on the line:

Return CType(Me.CurrentRow.Item("ITREPORT"), System.String) in the field properties. I tried to set the defaultValues and the first one sets fine, the second always gives the above error, regardless of the order set. I have PrimaryKeyIsAutoIncremented = False, PrimaryKeyIsUpdateable = True, and even tried out AllowNullsOnNewRow = True. The database fields (DB2) are set to not allow nulls, and have default values set.

I know this could be fixed easily by adding a proper autoincrement key column but I cant, the table is part of a legacy system and the customer is insistant it work as described above, frankly I'm not sure why it isnt. It works fine if the fields are unbound from the textboxes.

I must be missing somethign simple. Which is likely since I havent been coding much lately.

CurrentRow Setting.

Ertan Deniz — Tue, 06 May 2008 05:50:09 GMT

I've added a row to my business object over CurrentTable.ImportRow method. The row is an currentRow of an another object with the same type. Since Business Object Translation is a complicated work, I've choosen this method.

How can I make this row as current row ? So , I can easily access to its properties without exception?

Filling a BO from a BBS

Bill Cunnien — Mon, 05 May 2008 14:44:28 GMT

I have created several custom BBS's for use in my DX report. So far, all is going quite well. One thing that would make my life a lot easier is being able to access my custom fill methods from the BO. Here is an example of my code to fill a BO which fills the BBS which provides data for my report:

public partial class PackingListDS : BusinessBindingSource
{
public PackingListDS()
{
InitializeComponent();
BusinessObject = new PackingListBO();
}

public PackingListDS(IContainer container)
{
container.Add(this);
InitializeComponent();
BusinessObject = new PackingListBO();
}

public void Fill(int pPLIndex)
{
BusinessObject.FillByPrimaryKey(pPLIndex);
}
}

This works great! But, what if I want to fill the BO with a different method than the base methods (MyBO.FillWithMyReallyCoolMethod())? If I could somehow cast the BBSs BO as the BO of choice, then I could get to them. How do I do this?

Thanks,
Bill

ComboBoxEdit Requery Event Failing

Bill Cunnien — Fri, 02 May 2008 14:40:27 GMT

Time to get some help on this.

I have a comboboxedit control that has a requery event taking three integer parameters. The FillDataTable method in the BO looks like this:

public void FillByOrderIndex(int pPLType, int pMasterIndex, int pAddrIndex)
{
SqlParameter mPLType = new SqlParameter("@pltype", pPLType);
SqlParameter mMasterIndex = new SqlParameter("@masterindex", pMasterIndex);
SqlParameter mAddrIndex = new SqlParameter("@addrindex", pAddrIndex);
FillByStoredProcedure("spx_GetOrderItemList", mPLType, mMasterIndex, mAddrIndex);
}

This actually works (thanks for the help earlier this week!). The problem comes in when the combobox hits one of the resulting columns. It is the "orderid" field. It gets to the following code:

[Browsable(false),
BusinessFieldDisplayInEditor(),
Description(""),
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
public System.Int32 orderid
{
get
{
return (System.Int32)this.CurrentRow["orderid"]; <--*** OFFENDING CODE ***
}
set
{
this.CurrentRow["orderid"] = value;
}
}

The get_orderid() method kicks out a "Specified cast is not valid" error. If I place the parameters into the SQL Query Analyzer, I get a result set that does have an orderid and it is an integer value.

Any ideas about what I should do or where to look for a solution?

Thanks!!
Bill

New C# Component

Bill Cunnien — Sat, 03 May 2008 13:12:11 GMT

I have seen the design of a VB component that inherits from BusinessBindingSource; however, I cannot see to create a C# component that does the same thing (my VB to C# translation skills are not always up to par). My goal is to create an extended component for a specific business object. The XBBS will be dropped onto an XtraReport as a datasource. Any pointers would be appreciated?

Bill

Event BeforeEdit

Angela Sampaio — Wed, 30 Apr 2008 15:05:13 GMT

Hello

I noticed that the business objects have the events BeforeSave, BeforeAddNew, BeforeDelete and BeforeUndo.

I need to use an event "BeforeEdit" but i'm not meeting.

Is there any way to do that?

Thanks.

SQL Notification Services

Aaron Young — Tue, 29 Apr 2008 16:52:33 GMT

I haven't used SQL Notification Services before so this is all new to me.

I have notification services installed, the broker service is enabled on the database and I have set the BO ReceiveQueryNotifications to True. When I run a form containing the BO I get the error:-

"When using SqlDependency without providing an options value, SqlDependency.Start() must be called prior to execution of a command added to the SqlDependency instance"

I have done nothing in SQL Notification Services itself as I have assumed SF handles this for me. Are there any additional steps I have missed in Notification Services itself?

Thanks in advance,

Aaron

BeforeSave event not firing in 1.6.6

Randy Jean — Wed, 30 Apr 2008 10:06:27 GMT

I have some code in the beforesave event of one of my business objects. I've verified the handler is still connected. When I set a break point and fire a save on this business object, the code in event handler is not firing. Any ideas?

Parameters collection for FillByStoredProcedure

Bill Cunnien — Mon, 28 Apr 2008 16:13:37 GMT

How do I pass multiple parameters to the FillByStoredProcedure method?

Updatable Primary Key problem

Aaron Young — Wed, 23 Apr 2008 18:01:07 GMT

I want to set my own value for primary keys but the BO.Save() method doesn't write the primary key back to the database.

For example, I have an Int32 primary key called "CustomerID" and I set the value in SetDefaultValues() and the value is unique. I call BO.Add() which sets the value of CustomerID. I check the value of BO.CustomerID and it is correctly set to a valid value. However, when I do BO.Save() the CustomerID field is not written back to the SQL database (I can see this in SQL Profiler).

I have tried setting PrimaryKeyIsUpdatable to true but I guess I haven't done it correctly as Save() never writes the primary key.

Can anyone help?

Thanks in advance.

Using BeforeSave Event in Web Application

Cyrus Welch — Sat, 26 Apr 2008 11:20:33 GMT

I'm trying to use the before save event in a web application to log changes to the database. I need to be able to access this from the application base page so I have access to the session and other application settings as well as my application's transaction log table. It's working, however I get an error when building (which doesn't stop it from working, it's just very annoying at this point)

"Error 104 Method 'Private Sub snpccore_BeforeDelete(e As MicroFour.StrataFrame.Business.BeforeDeleteEventArgs)' cannot handle Event 'Public Event BeforeDelete(e As MicroFour.StrataFrame.Business.BeforeDeleteEventArgs)' because they do not have the same signature. C:\projects\MetSYSDotNet\MetSYSDotNet\App_Code\MetSYSSnapShotBasePage.vb 165 121 C:\...\MetSYSDotNet\"

I get the same error showing in the editor for each line as well. I'm not sure why it thinks that the signature is not the same since it clearly is since it's clearly working (the event is getting called and it's properly calling the method I've set up with the object reference and such so I can parse and log all the data changes and they are indeed being logged properly).

As I said, the build succeeds, unless there is ANOTHER error, in which case it's really painful to find the real error in all the other stuff. I'm also getting the same issue with the BeforeDelete event which I'm using the log deletes as well, but I figure it's going to be the same issue.

BTW this is with version 1.6 and upgrading to the latest version isn't a option for a few days as the boss wants to get this version out the door in about 4 days. Obviously this isn't going to be a stopper since it's working, but if there's an easy fix it's going to make any other troubleshooting easier for me. I'll be ok with finding out that the latest version woudl make this go away since I'll be moving to it soon, but needed to ask anyways.

Transaction & IsDirty

Crones — Fri, 18 Apr 2008 13:36:58 GMT

So here is the scenario:

I have an inherited BO that generates an "AutoID" value based on other field values. This ONLY happens when a new record is created. Now what happens is during the very FIRST save, my BO creates a transaction and saves the record using a temporary value for the AutoID so I can retrieve the PrimaryKey value, and then update the AutoID value with the field values I need and re-save just the AutoID value using a command object. Once this completes the transaction is committed. (Subsequent saves doe not automatically use a transaction unless I tell it too.) So far, everything works great and I have a happy day continuing on my way. Now the kicker:

In my case I generally open a form, fill just the data I need, make a change, save and close. When opening the form again (thus refilling the BO) and make a change, save & close everything is fine and dandy, HOWEVER, if I open the form, create a NEW record, save and do NOT close the form, and begin modifying data and save again, my changes are NOT pushed back to the database. I traced this to the Base BusinessLayer's save event and checking on the IsDirty property which returns FALSE if _IsSavedOnTransaction is set to TRUE which happened because I initially saved the BO in a transaction but do not need to save in a transaction again.

My question here would be: Is there some way to reset the BO's _IsSavedOnTransaction property to false without refilling the data?

FillDataTable affects Business Object property

Ertan Deniz — Wed, 23 Apr 2008 06:26:20 GMT

In my case,

A Business Object, for example, Group has a property for another Business Object (Company).

I'm accessing as Group.Company. (Property get section initializes and fill the Company object with some rules.)

But I've noticed that, When Group.FillDataTable was executed, Group.Company was also accessed. (In Debug mode, I've not caught this.) Company object was initalized and filled.

This was unexpected condition. Prior to my call as Group.Company, internally it has been done.

I need help.

Thanks.

Displaying field from a joined table

Charles R Hankey — Sun, 20 Apr 2008 14:20:57 GMT

I imagine this concept will be the same whether the sql statement is executed from the front end or the cursor is returned from a stored proc

I left joined credit cards to customers ( handling nulls and returning "NO CARD ON FILE") so there is a cardnumber field being returned in the cursor that I get with the stored proc

At debug time in me.customersbo1.currentview I can see the cardnumber column with data.

I looked in BO mapper and there doesn't look to be anyplace there to fake the BO into created a property (probably just as well as I assume it could not be updateable) Thought a custom field prop would be the way to go but

[codesnippet]

''' <summary>

''' Customer's Credit Card

''' </summary>

''' <remarks></remarks>

<Browsable(False), _

BusinessFieldDisplayInEditor(), _

Description("Customer's Credit card"), _

DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _

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

Get

Return cardnumber

End Get

End Property

Protected Overrides Function GetCustomBindablePropertyDescriptors() As MicroFour.StrataFrame.Business.FieldPropertyDescriptor()

'-- Create and return a new array of FieldPropertyDescriptor

' objects that contains the ReflectionPropertyDescriptor

' for the cust_fullname field.

Return New FieldPropertyDescriptor() { _

New ReflectionPropertyDescriptor( _

"cardnumber", GetType(CustomersBO))}

End Function

[/codesnippet]

Return Cardnumber gets the error that it must be declared - but I'm not sure what the syntax is to tell it the field will be in the cursor at runtime

( I do realize that if I add a custom prop in this way I will probably need to always be sure it is provided in each data access scenario. Does that mean I should be creating a view on the back end so the field is present in the definition when the bizobj is mapped? No problem, if that's the case but wanted to make sure there wasn't another trick I was missing as I might want to display something like this without having to create an updateable view on the back end)

TIA

Charles

BO with two tables?

Aaron Young — Mon, 14 Apr 2008 12:14:43 GMT

I am trying to setup a situation that we use a lot and would want to continue using.

Basically, we often bind an Infragistics Ultragrid to a dataset containing 2 or 3 tables. If I bind to a BO then it looks like I am restricted to only one table as the BO itself can only deal with a single table. Is this correct or have I missed something?

Thanks.

How to create a BO for a SQL View

Aaron Young — Sun, 20 Apr 2008 15:49:57 GMT

I would like to create a BO for a SQL View which will be bound to an UltraGrid via a Business Binding Source. So far, I have created all my BOs and configured them through the Database Deployment Toolkit. However, it looks like I can only do this for tables and not views.

I have created a BO manually and inserted the SQL statement to query the view. However, when I add a BBS for the BO and bind it to my UltraGrid, no column information is displayed in the grid. The BO is not passing schema information to the grid at design time.

1. Is there an easier way of creating a BO for a SQL View rather than manually creating the entire BO?

2. How do I tell the BO to give the correct schema information to the UltraGrid at design time?

Thanks in advance.

Database Connection Wizard always shows

Aaron Young — Fri, 11 Apr 2008 17:31:02 GMT

Hi,

I have a simple one BO, one form project on a Vista 64bit system. When I do an F5, the form runs and the Database Connection Wizard appears. I setup the connection and the form loads and throws an error when I attempt to fill the BO.

The error is:-

DataLayerException
An error occurred while creating a new DataLayer for the business object.
DataLayerException
The DataSourceKey [] is not defined.

Each time I do an F5 and run the project, the Database Connection Wizard always displays. From what I have read, it doesn't look like the wizard is saving the connection details as I believe it is supposed to only run the wizard once.

Have I missed something silly?

Thanks,

Aaron

Customize Wizard error and a request...

Peter Jones — Sat, 05 Apr 2008 18:14:42 GMT

Hi,

The Error: ----

This, or something similar, happened in 1.6.0 but I ignored it hoping that 1.6.5 would fix the issue. Given that it remains it may just be a problem in my environment. I have a solution with 50 projects and 150 BO's. When I open the Customize Wizard in the BO Mapper the "Populatin Tree View" message appears but after about 2 minutes is fails with this error:

NullReferenceException
Object reference not set to an instance of an object.

Source : MicroFour StrataFrame AddIns

Stack Trace:
at MicroFour.StrataFrame.AddIns.DTEprojectsBO.FillProjects(String[] ProjectPaths)
at MicroFour.StrataFrame.AddIns.PartialClassBuilderCustomizeWizard.ᜀ(ᜏ A_0)
at MicroFour.StrataFrame.AddIns.PartialClassBuilderCustomizeWizard.ᜀ()
at MicroFour.StrataFrame.AddIns.PartialClassBuilderCustomizeWizard.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
at System.Windows.Forms.Nativewindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.SetVisibleCore(Boolean value)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at System.Windows.Forms.Form.ShowDialog()
at MicroFour.StrataFrame.AddIns.PartialClassBuilderDialog.ᜃ()

Any suggestions about what I can do to fix this?

The suggestion: ----

Return the field list in the BO mapper to the same order as it was in 1.6.0, i.e. database schema order. For me anyway having the field list column in alphabetic sequence is confusing. Why not have it in schema order and let the user click the Name column to sort alphabetically if that's what they want.

Cheers, Peter

Backup a Database

Geoff Hirst — Wed, 19 Mar 2008 11:21:38 GMT

Chaps,

I want to offer my users a backup routine from my application, which may or may not be on the same machine as SQL Server Express. My users are not SQL Server literate and as such I want to protect them from it as much as I can.

I have a routine from a while ago, that allows the application I have written to backup the SQL Server Express database that it uses. This routine was written for an application that ran on the same machine as SQL Server Express.

Is there any routine built into SF, that will undertake backup and possibly restore? If not, can you advise how I get the Microfour.Strataframe.DBEngine.SQL.SQLServerInfo structure populated? It has everything in it that I need to modify my existing application.

Your advice, as always is appreciated.

regards

Geoff Hirst

Transaction Support For DeleteByPrimaryKey

Ertan Deniz — Fri, 11 Apr 2008 03:43:19 GMT

I need to execute DeleteByPrimaryKey as part of a transaction.

I've seen that Overload method does not exist.

What should I do ? If I use QueryInformation class for delete ,How can I execute this instance of QueryInformation. ?

We know that FillDataTable gets QueryInformation as parameter for fill queries. But What about Delete,update,Insert Queries ?

TransactionKey property

Ertan Deniz — Fri, 11 Apr 2008 08:39:28 GMT

I think this key is used to get DbTransaction object from Transaction Collection.

(DataBasics.DataSources[""].Transactions).

Normally, When BusinessLayer.TransactionBegin is called a DbTransaction Object is added to the collection with a default key value. This default transaction will be used.

When do I need simultaneous transactions ? I mean, When will be more than one transactions in that collection. So I will follow a key.

Insert Fails on BOs Created From Views

choyt — Wed, 09 Apr 2008 15:28:15 GMT

When we attempt to do an NewRow/Save through a BO that was created based on a VIEW, we get this error

"Cannot create INSERT command because the business object does not contain any PrimaryKeyFields"

I tried to set the PrimaryKey in the BO but that is a read only property.

Is there a way to work around this?

Thanks!

Clay

Built-in FillAll method?

Aaron Young — Thu, 10 Apr 2008 15:58:00 GMT

I am new here so please excuse my ignorance :)

I have been reading through the help file and I thought it would be a benefit to offer a built-in FillAll() population method which simply reads all records into the BO. I can see quite a large no of BOs in our application (i.e. lookup lists, etc.) that would benefit from this. I know I can add my own FillAll() to each BO but, as I am lazy, it would be nice if it was built-in :)

Is there a reason why you have decided not to implement it?

Thanks,

Aaron

Restrict access for BusinessLayer Object properties and Methods

Ertan Deniz — Wed, 09 Apr 2008 06:20:03 GMT

I have an Business Base class that is inhereted from BusinessLayer. I want to restrict some of them and not to see when dealing with my Business Base.

I have overriden some methods then made private. But It does not work. Because I ve got "virtual and abstract methods can not be private."message.

What is the best way ?

Business Binding Source DataSource Property

Ertan Deniz — Fri, 04 Apr 2008 06:43:25 GMT

Standart Binding Source component has Datasource property. This is used to give a type for the control like a grid in design time. Then, At runtime an instance (Datatable) is binded to a control.

We are using Business Binding Source to bind an object to Devexpress Grid.

In my case, I have an instance object (Companies). But I have to drop that type of object on the form for informing the Devexpress grid. At Design time, I can easily manage the columns etc.

Is there any way to accomplish this without dropping Business Object on the form?

How to use BOs from Win project within a Web project

Larry Tucker — Sun, 06 Apr 2008 10:49:36 GMT

Hi,

I've been working on a SF Windows project and would now like to build my first SF Web project that uses the same business objects. I've read the SF Tutorial several times but cannot quite get it to work.

First, can I leave the BO's within the Win solution, or do I need to pull them out as a separate BO library? I'd prefer to just leave them in the Win project and manage them there. If this is possible, how do I reference them from the Web project?

On the assumption that I need to pull them out as a separate BO Library (like the Tutorial), I tried this before posting this question. When I go to add a reference to the new BOL from either the Win or Web solutions, the Add Reference / Project folder is empty (unlike the Tutorial!).

So I'm stuck at step one of my first SF Web project and must be missing something basic.

TIA,

Larry

Access AutoNumber Insert

Crones — Fri, 04 Apr 2008 00:11:24 GMT

Ok... I'm having a major brainfart here... I could've sworn I saw a posting somewhere here talking about retrieving AutoNumber fields from an Access DB after an insert awhile back....

Anyways, how to I get the new AutoNumber value after adding (and saving) a BO? It keeps returning -1 on me...

Do I have to resort to executing a "SELECT @@IDENTITY" command to retrieve it?

ParentForm and ParentContainer

Ertan Deniz — Wed, 02 Apr 2008 08:22:03 GMT

I want to use ParentForm property for the businessObjects that is initiated in the code (i.e not dropped on the form)

Currently, This type of objects has null value for the property. I've seen the other constructor (with parameter Icontainer) was working. But I couldn't understand When these properties were set. I may follow the same way.

How can I achieve this ?

Design Time problem with Complex Business Object

Ertan Deniz — Wed, 02 Apr 2008 03:33:30 GMT

I have an complex Business Object called Companies with a property called rGroups. "rGroups" is also a business object. When I dropped complex Business Object on the form , I 've got the error msg in attached file.

New Bee .. Help Setting Up

John Davies — Wed, 26 Mar 2008 04:35:59 GMT

Hi All,

I am trying to set up my first Webforms Demo. I am using c# ASP.NET and hope to use the Developer Express Control Set ... after I get going.

Questions

1) Is there a c# help file ? I have looked around .. I heard about it in the forum but I can't find it? I am finding it very difficult to read the help instructions in VB.NET then implement them in C#.

2) I have been unsuccesessful trying to set up the 1 included Web Application Sample .. (Error post Submitted) ...Does anyone have a couple of very simple c# Web Examples ... simple examples say a data grid or simple form and/or parent-child form set-up so I can see how this is done.

3) When building a web form can you mix Strata controls with Standard VS controls ? What do you need to consider when choosing between Strata controls and VS 2005 controls. Will I have to wrap the VS 2005 controls? Can I use GridView, FormView and Breadcrumbs controls ... In a Strataform Application ?

Thanks In Advance

This will help me get going I have been going round in circles

Kind Regards

Childformdialog and BOTranslations

Geoff Hirst — Tue, 01 Apr 2008 13:53:58 GMT

Evening Chaps,

If I have a CFD, with a WIDGET business object that is then translated from ParentX to ChildY, when the WIDGET is used on ChildY, should I expect to have the currentrowindex in the same place on the child as it was on the parent?

If it should, It's not and I could do with any ideas as to what I might be doing wrong. If it shouldn't then great, it's working like it should and my workarounds can stay where they are.

thanks

Geoff.

Two business objects on one form

Ross L. Rooker, Sr. — Tue, 01 Apr 2008 09:02:09 GMT

If I have a form with a primary business object that drives the form in terms of the navigation tool bar. There is a secondary table (second business object) with a one to one relationship of data that the user wants to see at the same time on the form. Naturally when they click on EDIT they want to be able to modify data from both business objects then click on SAVE.

It appears as though I would need to manually enable/disable the secondary business object columns displayed as well as call the SAVE or UNDO methods for the second business object. Do you have a sample that demonstrates this, or could you point me in a direction?

Thanks

Ross