Re: Using FileMaker as ODBC Source

2015-09-16 Thread Javier Miranda
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

Re: Using FileMaker as ODBC Source

2015-09-15 Thread Peter Haworth
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

Re: Using FileMaker as ODBC Source

2015-09-15 Thread Bob Sneidar
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