CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Can't Add Or Modify Records Help

Print topic Send  topic

Author Message
Paul
Posted: 02/14/2001, 4:53 AM

I'm using CodeCharge on Windows 98 and using Access 97 Database, and am
creating ASP pages. Iam running the generated pages on a local machine
using PWS.

I built a very simple form and generated it. The form looks great, I am
able pull up my existing data with no problem. When I edit a record
(example: I changed the street address) and click the update button I get no
errors and it appears that the change is made. However when I call the
record back up and view the street address it shows the old address. When I
look at the raw data the old address is still there.

When I add a new record and click on the insert button, again, I get no
errors and it would appear that the record had been added. However when I
look at the data table I find that no record has been added.

Any help would be greatly appreciated.

Roger

Alexey Alexapolsky
Posted: 02/14/2001, 8:20 AM

Make sure the read-only attribute is not set on the Access file.

--
Regards,
Alexey
CodeCharge Support

Paul <paporter@visto.com> wrote in message
news:96dv42$m6o$1@news.codecharge.com...
> I'm using CodeCharge on Windows 98 and using Access 97 Database, and am
> creating ASP pages. Iam running the generated pages on a local machine
> using PWS.
>
> I built a very simple form and generated it. The form looks great, I am
> able pull up my existing data with no problem. When I edit a record
> (example: I changed the street address) and click the update button I get
no
> errors and it appears that the change is made. However when I call the
> record back up and view the street address it shows the old address. When
I
> look at the raw data the old address is still there.
>
> When I add a new record and click on the insert button, again, I get no
> errors and it would appear that the record had been added. However when I
> look at the data table I find that no record has been added.
>
> Any help would be greatly appreciated.
>
> Roger
>
>

Paul
Posted: 02/14/2001, 12:14 PM

Appreciate your input Alexey. I've solved the problem.

For anyone else that runs into this I found that this was an ODBC/Access
problem. What I had done was to setup my relationships in Access. ODBC
will not let you edit or delete records that are relationally tied together.

So I created a new database and imported the tables without the
relationships and gave it the same name as the original database and it is
working fine now.

Thanks again Alexey I appreciate your help.


Alexey Alexapolsky wrote in message <96eb78$dhf$1@news.codecharge.com>...
>Make sure the read-only attribute is not set on the Access file.
>
>--
>Regards,
>Alexey
>CodeCharge Support
>
>Paul <paporter@visto.com> wrote in message
>news:96dv42$m6o$1@news.codecharge.com...
>> I'm using CodeCharge on Windows 98 and using Access 97 Database, and am
>> creating ASP pages. Iam running the generated pages on a local machine
>> using PWS.
>>
>> I built a very simple form and generated it. The form looks great, I am
>> able pull up my existing data with no problem. When I edit a record
>> (example: I changed the street address) and click the update button I get
>no
>> errors and it appears that the change is made. However when I call the
>> record back up and view the street address it shows the old address.
When
>I
>> look at the raw data the old address is still there.
>>
>> When I add a new record and click on the insert button, again, I get no
>> errors and it would appear that the record had been added. However when
I
>> look at the data table I find that no record has been added.
>>
>> Any help would be greatly appreciated.
>>
>> Roger
>>
>>
>
>


   


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.