General information
Title:
Accessing data tables from a Web Service
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only