CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 Table with more than 1 field as primary key

Print topic Send  topic

Author Message
Tuong Do
Posted: 07/24/2002, 12:05 AM

Hi

How do we get around the problem of having a table with more than one field
that make up the primary key.

In CCS It always assume the primary key is a single field column when you do
the record builder query.

If you have a multi column primary key then you will have problem of trying
to edit the record by clicking on the grid table to edit the record table.
It won't retrieve the right record.

DonB
Posted: 07/24/2002, 5:02 AM

This is not anything that limits functionality in your application or
freedom to design your database. You only need to go back and add the other
key columns to the appropriate form's "Source/Parameters" once the wizard is
done and everything will be fine.

It is, however, something of a nuisance. I hope this gets fixed in the next
release, but not at the expense of other higher priority issues.



"Tuong Do" <tuongdo@somewhere.onerath> wrote in message
news:ahljj0$g6s$1@news.codecharge.com...
> Hi
>
> How do we get around the problem of having a table with more than one
field
> that make up the primary key.
>
> In CCS It always assume the primary key is a single field column when you
do
> the record builder query.
>
> If you have a multi column primary key then you will have problem of
trying
> to edit the record by clicking on the grid table to edit the record table.
> It won't retrieve the right record.
>
>


   


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.