logo
Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
Guest  
#1 Posted : Wednesday, July 21, 2010 1:24:05 PM(UTC)
Guest

Rank: Guest

Groups: Guest
Joined: 9/17/2008(UTC)
Posts: 66

Hi,
I want to update one field from database table from website.
Now I use OpenControl and AjaxEnabled option.
In control I have my update query which looks like this:

Quote:
Query = "UPDATE TACU_nowinki SET nazwa = 'DELETED' WHERE Id = " & nowId
pbw.run_Query(false,1,1,Query,Pbw.Get_ConString())


and the problem is that when I look in SIENN in Database > Data into my table the field 'nazwa' is changed, but at the website (where is called ViewControl with data of this table) there's nothing changed - I have old values. Refresh etc. doesn't help, but when I save again fhis data in SIENN (Database > Data > Change > Confirm) this works...

I don't know what kind of problem it is..

Thanks for help.

Wanna join the discussion?! Login to your Sienn Forum forum account. New Registrations are disabled.

bart  
#2 Posted : Wednesday, July 21, 2010 5:08:41 PM(UTC)
bart

Rank: Administration

Reputation:

Groups: Administration
Joined: 10/8/2008(UTC)
Posts: 188
Man

Was thanked: 1 time(s) in 1 post(s)
Do you have any relation fields on this table?
Those might not be set so the viewcontrol doesn't show the records.

You can check the data on the database directly before and after the confirmation en check what's the difference, then you know what to do about it.

Regs

Bart

Edited by user Wednesday, July 21, 2010 5:09:14 PM(UTC)  | Reason: Not specified

Guest  
#3 Posted : Thursday, July 22, 2010 12:10:24 PM(UTC)
Guest

Rank: Guest

Groups: Guest
Joined: 9/17/2008(UTC)
Posts: 66

Thanks for reply, this problem is already solved.

This behavior was caused by Cache instellingen (Part Cache Default Viewitems was 'On' ;)

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.