Search results for query: *

SELECT ... FOR UPDATE has a NOWAIT predicate that returns -1 via ODBC if you can't acquire the relevant lock. LOCK TABLES does not have that option but I need it. I am copying from some tables which I want to lock. However, I want to move on immediately if the locks can't be acquired. I...

SPAMJIM Only privileged users, Admins who would be assigned the task of data backup.

I use Mysqldump to backup databases on the server machine. However I would like to include the ability to backup data from my software which is not running on the server machine. Can I backup via ODBC?

Thanks Guys. So no one has reported that it has worms or viruses built into it. Mike Lewis, but I get your point about the legality. You should know also that it is free and you need to have a copy of VFP 9 Installed on your machine.

Mike Lewis, Chris Boyd what say you about the subject matter? Thanks guys for your responses.

I came across this video which makes mention of the VFP guru Craig Boyd. Has anyone of you checked it out. I have not installed it and am doing some due diligence. https://www.youtube.com/watch?v=iQqoLBOCTrI

myearwood Okay, I could have been more efficient with the code as you did. Thanks. I will replace my codes with it. Thanks to all who assisted.

Chris Miller Sir, thanks a million. I spent so much time on this and can't believe that I did not see that space. That was the problem. I am so ashamed of myself. Do I have your permission to delete this post. I don't think it will serve anyone any good. What do you think?

cTableAlias does not work when a variable containing the table name is passed to SELECT cTableAlias or USED(cTableAlias) This a very strange case. Table test.dbf is clearly open in the current datasession. If I run from the IDE ? USED('test.dbf') it returns .T. However I when I do the...