Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing data tables from a Web Service
Message
General information
Forum:
Visual FoxPro
Category:
Web Services
Title:
Accessing data tables from a Web Service
Miscellaneous
Thread ID:
00800125
Message ID:
00800125
Views:
52
I know I am missing something when I try to access a data table from within my web server class. What I am trying to do is pass data to the web service via parameters and then have the web service update a table that resides in a folder on the same box as the web service.

When I run the client program that accesses the web service, I get an error "cannot update the cursor" when it attempts to process the line of code that contains the table access command.

I have tried accessing the table via native Fox commands and by way of a SQL statement. Neither method works. (See examples of both below.)

***********************************************************
PROCEDURE newClaim (inFile_code, inBr_Code, inDiv_Code)

INSERT INTO c:\data\myfile (file_code, br_code, div_code) VALUES (inFile_Code, inBr_Code, inDiv_Code)

EndProc

**********************************************************

PROCEDURE newClaim (inFile_code, inBr_Code, inDiv_Code)

USE c:\data\myfile
APPEND BLANK
Replace file_code WITH inFile_Code
Replace Br_Code WITH inBr_Code
Replace Div_Code WITH inDiv_Code
USE

EndProc

************************************************************


Any help on this would be greatly appreciated.

-Steve
Next
Reply
Map
View

Click here to load this message in the networking platform