Updateable view Not Updating...have Send SQL Updates checked.... 3

[ahaws]

Good Afternoon-
Having a problem I have never encountered:

I have txtboxes that control source to an updateable view.

When the user is finished editing - I execute this code:

If Messagebox("Save Changes to Lienholder Information?",4+32+128,"Please Confirm&quot == 6
Select vvehlieninfo &&& updateable view
Replace app_inits With employeeinit
= Tableupdate(2,.t.,'vvehlieninfo')
WAIT WINDOW "Vehicle Lien Information Saved Successfully" TIMEOUT 1.5 AT 40,40
Else
= TABLEREVERT(.T.,'vvehlieninfo')
WAIT WINDOW "Vehicle Lien Information Was Not Saved" TIMEOUT 1.5 AT 40,40
ENDIF


I know the underlying table never gets updated because I requery it and it doesn't contain the changes.
I have the underlying table cursorsetprop(buffering",5,"tablename&quot...

Any ideas as to why this would not save to the underlying table? Also, as stated in the title - have 'Send SQL updates" IS checked.

Thanks in advance
Angie

 

[kueyiar]

Angie,
I've checked on you suggestion, both table and view are in the correct directory, any other idea ?
In vfp 8 while creating a view the only strange thing i see is that when i add the table, select fields, set filter, update criteria, but it automatically sets a 'join' where as i only have one table. it sets it like this :
'left table'= charges(my table)
'join type '= cross join
'pri. '= 0
and the rest ot the fields empty.
I've erased the view, erased this join condition but it always rebuilds it, could this be my problem..?

antonio

 

[ahaws]

Antonio-
Not sure- I use VFP7.0, but that doesn't sound like it should be operating that way.
Do you use the view wizard or set up by yourself?
Angie

 

[kueyiar]

Angie,
I set it up myself. I've tried using the wizard but both problems persitst, not updating and the join condition always appears. Something i didn't mention before is that the update works when its a new record, but if i try to modify it, thats where it doesn't work at all.

Antonio

 

[ahaws]

Antonio-
What field does it join to?
Not sure what's going on here...Havent ever seen where there is a join for only one table.
Maybe a guru will pop in at any time...
angie

 

[kueyiar]

Angie-
Thats the thing, it doesn't join to any field. It just sits there with taht "cross join" clause.
Do you know of any other good place where maybe i could find some help ?
antonio

 

[ahaws]

Antonio-
Try Universal Thread or Experts Exchange-they are forums as well, although there are alot of experts here as well.
That's why I cant believe no one has popped in with other suggestions, although it could be a program setting, local to your machine...
If I find anything I will let you know.
I am by no means an expert, but I have been there, yuno?
Good Luck.
Angie

 

[kueyiar]

Angie,
I think so too, pretty strange, but, we'll see.
Thank you very much for your help and time, I really apreciate it. And you sure know your way around fox, don't underestimate yourself !!
Just in case here's my address kueyiar@hotmail.com
Thanks again,
antonio

 

[ahaws]

Antonio-
Im still learning myself, only since 2001 have I been trying to!
I will probably post here so everyone can benefit..so if I find a solution I will let you know via Tek-Tips..
Take care!

Angie

 

[kueyiar]

Angie,
Ok thanx !

 

[badscots]

Hello all,

Blimey this is getting good...

Have you tried setting the cursor prop:
cursorsetprop('buffering',3,'tablename')

I know it shouldnt make a bit of difference but I set up a view in the same way, set Buffering to '5' and it didnt update the base table, then set it to '3' and it worked.

Do you have the View in the DE? If so set the BufferModeOveride = 3.

Crazy I know...

IanMc.

 

[kueyiar]

IanMc,
Tried it, but it doesn't work either.

 

[wwopp]

I was very stuck on the same type of problem and saw the suggestion to not use double buffering - took the buffering our of the underlying table and left it in the view and everything works just fine.

Thanks!

Opp