Bob, thank you for your advice, I think you are right, I'll give some of
the tools for manage DBs a try.
Peter, thank you for your reply, I was trying revMoveToLastRecord only to
test how this cursor thing works in LC
Best regards,
Javier
___
use-live
Hi Javier,
According to the dictionary entry for revOpenDatabase, you need to use the
cursortype parameter for ODBC connections. The defualt is "forward only"
which does not support the use of revMoveToFirstRecord,
revMoveToLastRecord, and revMoveToPreviousRecord.
It looks like a cursortype of "e
I found using Livecode cursors so frustrating I almost gave up on using LC for
database driven projects. That is until I came across sqlYoga, by Blue Mango
Learning, Trevor Devore's but of genius. This will return a numbered array of
the query results. Much easier to work with.
Cursors are rea