This topic is locked

Error after update?

10/11/2006 7:13:47 AM
ASPRunner.NET General questions
J
JosefTK author

Hey everybody (esp. Eugene)

Yesterday I made an update because of an explorer error. This morning I build my project. Now I have a strange effect and I'm not sure this is caused by the update I made. The thing is:

In my form.vb I've build a few functions which are called uppon inserting a new record something like this:

e.Values("LZV") = calculus(e.Values("PrSp"), e.Values("Zs"), e.Values("ArtikelName"), e.Values("AltTarifklasse"), e.Values("AltTarif"), e.Values("NeuTarif")).

The function calculus should return an integer. Actualy it did until yesterday. Today when I observe the function it returns the Integer but my e.valus("LZV") is not updated! Thus the field in the updated record shows value=1!<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=3580&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />

Eugene 10/11/2006

Please, ensure that debug mode is ON (page "Output directory, step 12 in ASPRunner.NET wizard) and send me sql string, that you see when update data.

J
JosefTK author 10/11/2006

Hey Eugene,
do you mean something like this?

InsertCommand = insert into [dbo].[vertraegen] ([Verlengd], [Anrede], [Vorname], [Name], [Geburtsdatum], [MSISDN], [Kundennummer], [ArtikelName], [Geraetenummer], [SimNR], [HaendlerID], [Eintragsdatum], [AltTarif], [AltTarifklasse], [NeuTarif], [NeuTarifklasse], [Firmenname], [LZV], [Adresse], [Hausnummer], [PLZ], [Ort], [PrSp], [Zs]) values (@Verlengd, @Anrede, @Vorname, @Name, @Geburtsdatum, @MSISDN, @Kundennummer, @ArtikelName, @Geraetenummer, @SimNR, @HaendlerID, @Eintragsdatum, @AltTarif, @AltTarifklasse, @NeuTarif, @NeuTarifklasse, @Firmenname, @LZV, @Adresse, @Hausnummer, @PLZ, @Ort, @PrSp, @Zs)
@Verlengd(Boolean)=False

@Anrede(String)=

@Vorname(String)=

@Name(String)=Heinen

@Geburtsdatum(DateTime)=03.06.1968 00:00:00

@MSISDN(String)=49494949494584

@Kundennummer(String)=

@ArtikelName(String)=Motorola SLVR L7

@Geraetenummer(String)=1233432343245

@SimNR(String)=121231

@HaendlerID(String)=53994

@Eintragsdatum(DateTime)=11.10.2006 00:00:00

@AltTarif(String)=TM2004_200_40SMS_1000

@AltTarifklasse(String)=L

@NeuTarif(String)=1

@NeuTarifklasse(String)=

@Firmenname(String)=

@LZV(Decimal)=0

@Adresse(String)=Von Humboldt Strasse

@Hausnummer(String)=119

@PLZ(String)=52511

@Ort(String)=Geilenkirchen

@PrSp(Boolean)=False

@Zs(Boolean)=False
Hey you are really fast I'll tell that around

Eugene 10/11/2006

That is very interesting. I see, that @LZV(Decimal)=0 in update command, but you insist that table value remains equal 1.

Could you please send me your project (including project file, output directory and database file or database backup) with this error on support@xlinesoft.com? I will investigate it on my box.

J
JosefTK author 10/11/2006

That is very interesting. I see, that @LZV(Decimal)=0 in update command, but you insist that table value remains equal 1.

Could you please send me your project (including project file, output directory and database file or database backup) with this error on support@xlinesoft.com? I will investigate it on my box.



Oops that table value=1 was because I tried a Cint on the return value but I will send you the project file and output dir anyway I'm not sure what to do with my dbase file its on a sql express 2005 server

Thank you for your quick response

Greetz Josef <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=11776&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />