Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC to Access VFP
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
ODBC to Access VFP
Miscellaneous
Thread ID:
00105674
Message ID:
00105674
Views:
66
I have a simple VFP app. I would like to put all my rules in the DBC so clients who buy the app can add onto its functionality through ODBC. My problem is as soon as I place a rule in the stored procedures that is slightly complicated ( see below ) and access the data via VFP ODBC driver, the rule fails - always - even if the entered data is correct. If I use a simple rule it works. For example, this works:

PROCEDURE AddressRules
IF EMPTY( AddrID )
RETURN .F.
ENDIF

but, this does not work:

PROCEDURE AddressRules
USE Person IN 0 AGAIN ALIAS AddressRules
IF NOT SEEK( PersonID,"AddressRules","I1" )
USE IN "AddressRules"
RETURN .F.
ENDIF
USE IN "AddressRules"

Are some commands and functions not supported if accessed via ODBC? If yes, where can I find a detailed list?

Thanks for any help.
Ben
Reply
Map
View

Click here to load this message in the networking platform