CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> ASP

 Losing Data on Update

Print topic Send  topic

Author Message
cruisin

Posts: 31
Posted: 10/25/2004, 10:00 AM

I'm noticing that in some of my forms data that is saved correctly in an add transaction isn't displaying correctly when you access the record to update it. The problem is that when you update it, the null values on the screen (where there should be values) over writes the correct information in the database and wipes it out. I've tried regenerating the pages but have had inconsistent results. Suggestions?
View profile  Send private message
cruisin

Posts: 31
Posted: 11/03/2004, 1:44 PM

I had to run this one through support. It was a problem with SQL server and ODBC not liking where the memo fields were in my tables. Moving the columns to the end of the record fixed it.
View profile  Send private message
DonB
Posted: 11/08/2004, 12:33 PM

Use the OLE DB Provider. It does not exhibit the flaw you encountered with
the generic ODBC driver. I haven't been bothered by it in CCS since
switching more than 2 years ago. I always use the OLE DB Providers whenever
possible.

--
DonB

http://www.gotodon.com/ccbth


"cruisin" <cruisin@forum.codecharge> wrote in message
news:641895120ab74a@news.codecharge.com...
> I had to run this one through support. It was a problem with SQL server
and ODBC
> not liking where the memo fields were in my tables. Moving the columns to
the
> end of the record fixed it.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>


Add new topic Subscribe to topic   


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

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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