Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Update() does not update

Status
Not open for further replies.
Koen Piller

Koen Piller

Programmer
Joined
Jun 30, 2005
Messages
841
Location
NL
Hi,

I have this code which does not update
Code: 
Update PERMISSION ;
SET ;
PERMISSION.Permissionnmbr = curPermiss5a.Permissionnmbr , ;
PERMISSION.Permissionfrom = curPermiss5a.Permissionfrom , ;
PERMISSION.Permissiontill = curPermiss5a.Permissiontill , ;
PERMISSION.Permissiondate = curPermiss5a.Permissiondate ;
FROM curPermiss5a ;
WHERE PERMISSION.ID = curPermiss5a.ID
lnRec = _Tally
la =  AERROR(aPermis)
If lnRec = 0
	lnError = 8
Else
	m.llSuccess = Tableupdate(.T.)
Endif
If llSuccess = .F.
	lnError = 16
Endif

Select VERZEKNR

[ul]
[li]The cursor curPermiss5a all fields have values.
The values of the both ID's are equal
aPermis does not show any update errors
My Errorcatcher is not activated
lnRec = 1 [/li][/ul]
and still the fields of the table to be updated, PERMISSION, remains blank
Any clue how to find what is the cause of this unwanted behavior?

I keep on puzzling.

Koen
 
Sort by date Sort by votes
What is the buffering/locking state of curPermiss5a? And how is it created? By a CA or updatable view on permission.dbf?

Bye, Olaf.

Olaf Doschke Software Engineering
 
Upvote 0 Downvote
Olaf,
Buffering of cursor curPermiss5a was 5, I changed to 1: no effect.
Cursor was created with a SQL Select from 3 dbf's
Code: 
Select ;
T1.Id, ;
T1.Permissionfrom,	;
T1.Permissiontill,	;
T1.Permissionnmbr,	;
T1.Permissiondate, ;
T1.Permissionrqst, ;
T1.iVerzeknr, ;
T2.Permissionrecvd, ;
T2.ID As VerzeknrID, ;
T3.chemoenz, ;
T3.nierdialyse, ;
T3.ID As NAWID ;
FROM PERMISSION T1 With (Buffering = .T.) ;
JOIN VERZEKNR T2 With (Buffering = .T.) On T2.ID = T1.iVerzeknr ;
JOIN NAW T3 With (Buffering = .T.) On T3.ID = T2.iNAW ;
INTO Cursor curPermiss5a Readwrite NOFILTER

Regards,
Koen
 
Upvote 0 Downvote
Koen,
Did you try FLUSH FORCE command?

Regards,

Ilya
 
Upvote 0 Downvote
It would only by chance, if you do a single table query and get a filter cursor.

An updatable cursor needs to be a view or CA, because you already get an error 1468, if you try to CURSORSETPROP("SendUpdates", .T.).

Bye, Olaf.

Olaf Doschke Software Engineering
 
Upvote 0 Downvote
Olaf,

It is not the cursor curPermiss5a which needs to be updated it is the DBF Permission.DBF which needs to be updated.
This technique to update a dbf with the content from a cursor is used for 'ages'.

@Ilya,
The lowlevel 'Flush Force' was not issued, I will give it a try.

Regards,
Koen
 
Upvote 0 Downvote
Koen, fantastic, then it should be easy to set this up as it's necessary and you'll get this yourself.

Bye, Olaf.

Olaf Doschke Software Engineering
 
Upvote 0 Downvote
Olaf,

sorry I think I donot follow. What is fantastic?

Regards,
Koen
 
Upvote 0 Downvote
What do you see when you use a query with the same conditions?

Code: 
SELECT * FROM PERMISSION ;
 JOIN curPermiss5a ;
   ON PERMISSION.ID = curPermiss5a.ID

Tamar
 
Upvote 0 Downvote
Tamar,
I get a query with one record, correct according to the code, with all fields from PERMISSION.DBF and curPermiss5a with data from their relevant sources.
Koen
 
Upvote 0 Downvote
Okay, so what do you see if you check the table right after the UPDATE command?

Tamar
 
Upvote 0 Downvote
Tamer,
I notice that the fields are not updated, they remain blank as initially.
You know I lost lust to find out what is going on here. So, since it is after all only an update of a few fields, I changed my code from
Code: 
SQL..Update
to a
Code: 
REPLACE Permissionnmbr WITH curPermiss5a.Permissionnmbr,;
etc. works fine and I can go on.
Thanks for your advise and sorry for bothering.
Koen
 
Upvote 0 Downvote
how are you checking the table after the update?

Could this be SET SQLBUFFERING ?

hth

n
 
Upvote 0 Downvote
Nigel,

You can check the Buffering with ln= Cursorgetprop('Buffering', cTableAlias)
if ln = 5 Optimistic Table Buffering is on

Regards,

Koen
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question Question
Update Data SQL server Using Create Cursor VFP
Replies
13
Views
2K
bharons
bharons
DDPL
  • Question Question
Using cursor adaptor to update blob data in MySQL
Replies
19
Views
998
Chriss Miller
C
foxmuldr3
  • Locked
  • Question Question
Visual FreePro Update
Replies
11
Views
2K
Scott24x7
Scott24x7
foxmuldr3
  • Locked
  • Question Question
Visual FreePro Update
Replies
13
Views
4K
foxmuldr3
foxmuldr3
bharons
  • Locked
  • Question Question
update data table sql server using form vfp
Replies
13
Views
1K
bharons
bharons

Part and Inventory Search

Sponsor

Back
Top