Configuration Case Study (SQL Server users)

[Dark_V]

Hi,

Finaly have a few weeks playing with configuration tool using SQL Server... i'm disapointed about support!

In a business space created a few business objects from existing SQL Server selecting primary key... information is viewed and edited in test mode... but have problems to create objects.

In 244 page of user guide do not have more information about considerations about data stored in existen database... (only a few logical limitations).

By this moment need information about:
Tables in sql server more columns? i see some in demo.
How disable or hide columns in edit, creation and update?
How create forms for this object (not auto-generated).

Some other user with this experience?
Exists some case study for sql server users?

Thanks.

[ghilton]

I would love to be at this point but stuck with Derby at the moment

[Dark_V]

That's why i'm so disapointed with support!

[aware_support]

If you want your issues to be answered to in a timely fashion by the support team you need to purchase a support ticket. This forum is mainly for communication between Aware IM users and we cannot guarantee timely responses to your queries.

Regarding your questions. I don't quite understand most of them so if you can elaborate on exactly what problems you are having, it would help.

[Rem]

I really think Awaresoft should focus more on the product and the developers who use it and less with individual support.

If you make more demoapps, more documentation, more focus on the forum, more helptools, more marketing and so on you will be able to help much more people and the product will grow.

As it is now the product is great to start of with, but it tends that many of us easilly get stuck and that is a shame, since the product has great potential.

/Rem

[Dark_V]

Hi,

I have this SQL Server table:

CREATE TABLE [dbo].[New_Table](
[ID] [tinyint] IDENTITY(1,1) NOT NULL PRIMARY KEY,
[Name] [varchar](50) NULL,
[Create_Date] [smalldatetime] NULL DEFAULT (getdate()),
[Create_User] [varchar](50) NULL DEFAULT (''),
[Update_Date] [smalldatetime] NULL DEFAULT (getdate()),
[Update_User] [varchar](50) NULL DEFAULT (''),
[Status_Flag] [bit] NULL DEFAULT ((1)),
)

Discover attributes and define rules for object creation to fill values of Create_User, Create_Date, Update_User, Update_Date and Status.

With or without those columns in form, with or without rules show me this error: Internal error. Error persisting business object Mailer_Failure Parameter #7 has not been set. in status bar.

I test inserting rules for ID and for EXT_ID attributes:
If Mailer_Failure IS NEW Then Mailer_Failure.ID=MAX Mailer_Failure.ID+1
If Mailer_Failure IS NEW Then Mailer_Failure.EXT_ID=MAX Mailer_Failure.EXT_ID+1

Try diferents ways with this rules (delete one, define and disabling IDENTITY in table, etc.)... same result.

Try defining NULL values for all other columns.

I test with a simple structure with two columns with same result, but error msg talk about Parameter #2. In user guide and how to manual do not show create objects from external database... or at least some consideration, did you have a sample?

Please, help... i have 12 tables with this structure.

[aware_admin]

We did a quick test with a similar structure in MySQL and it seems to be working properly.

You are saying that you tried it with a simple structure with two columns. What are these two columns?

[Dark_V]

This structure:

CREATE TABLE [dbo].[New_Table](
[Llave] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
[Nombre] [varchar](50) NOT NULL DEFAULT (''),
)

Can create a Business Space with this table? or a list of steps to follow?

Thanks.