Cursor Adaptor Question

[sstamm]

Is anyone using the new VFP cursorAdaptor class?

I am having a problem getting my CursorAdaptor class to update the database. It pulls data from the database flawlessly and appears to update as well, returning .T. from TABLEUPDATE(), 1 in _Tally, and .T. in lResult.But the original table remains unchanged and when I issue CursorRefresh() the old data comes back. I read a great CODE Magazine article by Chuck Urwiler that was very informative. I have gone through this article several times but can find nothing that I am overlooking.

If anyone wants to see my class I will be glad to email it.

Any help that anyone could give me will be greatly appreciated.

Thanks.

Steve

 

[sstamm]

Leland,

Thanks for the speedy reply.

I just checked and the Key is unique. Even if it wasn't I would have expected VFP to give sone warning that the update didn't happen, right?

I am using the NorthWind sample data set the Customer table and the class I have written is based on the Data Environment baseclass.

Any other suggestions?

Again, thanks.

Steve

 

[rgbean]

Steve,
You might want to check out Mark McCasland's CursorAdapter class at

http://www.mctweedle.com

. He has a whole set of samples for it's use and a lot of insights into how to make using CAs easier.

Rick

 

[sstamm]

Thanks Rick!

I sure appreciate it. Seems as if CA examples and references are few and far between.

Thanks.

Steve

 

[Mike Lewis]

Steve,

My apologies if this is stating the obvious, but I assume you have set the AllowUpdate property to .T.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[sstamm]

Hi Mike,

No need to apologize for the obvious. I have been known to overlook that in the past. In this case though that's not it... unfortunatly...

Would anyone like to take a look at the class just to see if I missed anything?

Thanks again,

Steve