VFP Stored Procedures and Foxpro 2.6

[pmbroh]

I would like to update a 2.6 table through ODBC - The RFID application is ODBC compliant. The application is a large one developed in 2.6. As best I can tell 2.6 ODBC like 2.6 does not support UPDATE/DELETE transaction.

To update a 2.6 table using ODBC I was thinking that I could do an SQLEXEC call to a VFP stored procedure and have VFP Stored Procedure update the 2.6 table. Does this work or is there a better way.

Thanks, Pete B.

 

[Mike Lewis]

Pete,

In theory, what you suggest is possible. The problem is that a 2.6 table cannot reside in a database -- it can only be a free table. Therefore you would need to create a separate database simply to hold the stored procedure. If you are able to do that, your approach should work.

However, I am surprised that you said that the 2.6 table "does not support UPDATE/DELETE transaction". If you mean that you can't send an UPDATE or a DELETE via SQLEXEC(), I'm sure that's wrong. If you mean that it doesn't support transaction processing, that's true, but if it is only one table, I don't see why that should be an issue.

Finally, you mentioned about calling the stored procedure from a SQLEXEC(). That suggests that you are using VFP as your front end. If so, why do you need ODBC? Why not simply update the 2.6 table directly?

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[pmbroh]

Thanks Mike so much for your reply.

Your right about the ODBC support of Update on 2.6 - I was running the update against a View - fixed now - Front end right now is VFP but when finished front end will be a hand held scanner. Thanks