CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Undefined index: MasterID

Print topic Send  topic

Author Message
Dave Rhodes
Posted: 10/17/2003, 3:32 PM

What the hell does that mean?
MasterID is the primary key DEFINED in the table I'm using.

Also I'm getting "Set the Date Format property to work correctly with the
Date fields"

There are NO date fields.

Any clues?

--
No good deed will go unpunished.
Walter Kempees
Posted: 10/19/2003, 6:01 PM

Are you using CC or CCS?

Fisrt Q:
Your MasterId error:
Could you tell me which DB you are using?
Include the Table Description, an I'll get back to you.

Second Q:
If CSS {
The dateformat settings for the application must be set in [setting] as well
as and conform to the settings used in the [connection] to the database.
} else {
sorry no info
}

"Dave Rhodes" <captain@teamnasty.net> schreef in bericht
news:1it55acd5xa49.l3kjf9n18iyb.dlg@40tude.net...
> What the hell does that mean?
> MasterID is the primary key DEFINED in the table I'm using.
>
> Also I'm getting "Set the Date Format property to work correctly with the
> Date fields"
>
> There are NO date fields.
>
> Any clues?
>
> --
> No good deed will go unpunished.

Dave Rhodes
Posted: 10/22/2003, 8:26 AM

On Mon, 20 Oct 2003 02:59:12 +0200, Walter Kempees wrote:

> Are you using CC or CCS?

CCS

> Fisrt Q:
> Your MasterId error:
> Could you tell me which DB you are using?

MS Access / Office Xp

> Include the Table Description, an I'll get back to you.

MasterID is a number type field (long integer).
The rest are either text or memo.
I can provide the complete table desription, but it's a bit long.
Here is the descrition of the MasterID field:

Name Type Size
MasterID Long Integer 4
AllowZeroLength: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {306F6CB6-300C-4EB9-A674-86F80E098E35}}
OrdinalPosition: 1
Required: False
SourceField: MasterID
SourceTable: tbl_GolfRev


> Second Q:
> If CSS {
> The dateformat settings for the application must be set in [setting] as well
> as and conform to the settings used in the [connection] to the database.

Ok, I fixed this, date formats differed. Thanks.

However, I create a simple page to display a record and no data is pulled
from the db. I tested the connection, it's fine. Publish in Access works fine,
using a product called Netdynamics, I created this app in 5 minutes and it
works fine. I've tried the Application Builder and the simple Record Builder
form the toolbox, no records displayed, just the labels. Any clues?

> } else {
> sorry no info
> }

Thanks for your help
DonB
Posted: 10/22/2003, 7:11 PM

If you changed the primary key AFTER you created the form, then CCS might be
confused about which column is the PK. I only have been able to recover
from this by recreating the form. If you have lots of fancy HTML
formatting, then it is generally safe to save the current HTML, recreate the
form with exactly the same fields, names and datasource - then past the old
HTML back over the new HTML. I've done this numerous times and it saves a
great deal of effort yet let's me recover from my stupidity or the
occasional broken form CCS might have built (not been a problem since 2.2, I
should note in all fairness to Yes).

If you are not doing so already - use the Access 4.0 OLEDB Driver *NOT* the
ODBC Driver for Access. Memo fields are not going to work right with the
ODBC driver.

If you have the wrong datatype in the form-fields (they don't agree with the
database), then you likely will see blank fields - so check that.

Make sure you don't select "auto-increment primary keys" if the PK is NOT
"autonumber")

Don't publish the project to the same folder where you do development - use
a separate folder for each.

That's all that I can think of that might be relevant to what you've
described.

--
DonB

http://www.gotodon.com/ccbth


"Dave Rhodes" <captain@teamnasty.net> wrote in message
news:1fjsgxsh5tr9d.1gyjgom8c03u.dlg@40tude.net...
> On Mon, 20 Oct 2003 02:59:12 +0200, Walter Kempees wrote:
>
> > Are you using CC or CCS?
>
> CCS
>
> > Fisrt Q:
> > Your MasterId error:
> > Could you tell me which DB you are using?
>
> MS Access / Office Xp
>
> > Include the Table Description, an I'll get back to you.
>
> MasterID is a number type field (long integer).
> The rest are either text or memo.
> I can provide the complete table desription, but it's a bit long.
> Here is the descrition of the MasterID field:
>
> Name Type Size
> MasterID Long Integer 4
> AllowZeroLength: False
> Attributes: Fixed Size
> CollatingOrder: General
> ColumnHidden: False
> ColumnOrder: Default
> ColumnWidth: Default
> DataUpdatable: False
> DecimalPlaces: Auto
> DisplayControl: Text Box
> GUID: {guid {306F6CB6-300C-4EB9-A674-86F80E098E35}}
> OrdinalPosition: 1
> Required: False
> SourceField: MasterID
> SourceTable: tbl_GolfRev
>
>
> > Second Q:
> > If CSS {
> > The dateformat settings for the application must be set in [setting] as
well
> > as and conform to the settings used in the [connection] to the database.
>
> Ok, I fixed this, date formats differed. Thanks.
>
> However, I create a simple page to display a record and no data is pulled
> from the db. I tested the connection, it's fine. Publish in Access works
fine,
> using a product called Netdynamics, I created this app in 5 minutes and it
> works fine. I've tried the Application Builder and the simple Record
Builder
> form the toolbox, no records displayed, just the labels. Any clues?
>
> > } else {
> > sorry no info
> > }
>
> Thanks for your help

Walter Kempees
Posted: 10/23/2003, 3:16 AM

OK Dave

I promised you to get back if you gave me DBType end table def.

MasterId is your PrimaryKey on your Table, right ?
I am not a frequent user of .mdb Access, but by general DB rules a
PrimaryKey contains a never changing value.
For instance an automatically incremented number, Autonumber.

From your description of MasterId 2 things spring to mind:

1/ It's nowhere obvious to me that this field is being used as a PrimaryKey
of type Index and AutoSequence or Autonumber or AutoIncrement
2/ Your field description states this field as being not required, that
should be required to help trigger the autonum.

DonB mentioned things can get out of sequence when changing database
definitions, I agree.
But be assured that I would:
Define the table(s), do the normalisation, go Into CCS, set my project
properties, make the connection, choose the appropriate type of App I want
Generate Publish and be running within your 5 minutes.

So it can be done don't despair.
Check your database table definition see that it actually contains a primary
key and it is autosequence.
In CCS open a 'new'secondary project, set properties for the project, choose
your favourable appwiz an do it.
See if that works, than from there conclude wether possibly your original
project has a out of date Db definition .

Walt
"Dave Rhodes" <captain@teamnasty.net> schreef in bericht
news:1fjsgxsh5tr9d.1gyjgom8c03u.dlg@40tude.net...
> On Mon, 20 Oct 2003 02:59:12 +0200, Walter Kempees wrote:
>
> > Are you using CC or CCS?
>
> CCS
>
> > Fisrt Q:
> > Your MasterId error:
> > Could you tell me which DB you are using?
>
> MS Access / Office Xp
>
> > Include the Table Description, an I'll get back to you.
>
> MasterID is a number type field (long integer).
> The rest are either text or memo.
> I can provide the complete table desription, but it's a bit long.
> Here is the descrition of the MasterID field:
>
> Name Type Size
> MasterID Long Integer 4
> AllowZeroLength: False
> Attributes: Fixed Size
> CollatingOrder: General
> ColumnHidden: False
> ColumnOrder: Default
> ColumnWidth: Default
> DataUpdatable: False
> DecimalPlaces: Auto
> DisplayControl: Text Box
> GUID: {guid {306F6CB6-300C-4EB9-A674-86F80E098E35}}
> OrdinalPosition: 1
> Required: False
> SourceField: MasterID
> SourceTable: tbl_GolfRev
>
>
> > Second Q:
> > If CSS {
> > The dateformat settings for the application must be set in [setting] as
well
> > as and conform to the settings used in the [connection] to the database.
>
> Ok, I fixed this, date formats differed. Thanks.
>
> However, I create a simple page to display a record and no data is pulled
> from the db. I tested the connection, it's fine. Publish in Access works
fine,
> using a product called Netdynamics, I created this app in 5 minutes and it
> works fine. I've tried the Application Builder and the simple Record
Builder
> form the toolbox, no records displayed, just the labels. Any clues?
>
> > } else {
> > sorry no info
> > }
>
> Thanks for your help


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.