Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate not successful
Message
From
23/11/1998 22:44:00
 
 
To
23/11/1998 02:11:05
Victor Lapid
Phil. Long Distance Tel. Co.
Manila, Philippines
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00160409
Message ID:
00160757
Views:
14
>I have a remote view which is based on the 26 fields of MSACCESS. from there Ive created a form with a grid and 26 textboxes on it. the grids recordsource is based on the alias of the view and controlsource of the textboxes is based on the view.fieldname. In the form i have a button which has a command like this =tableupdate 1,.t.,y2k to update the cursor then the datasource. but when i tried to run again the form still i get the same data and no updating happens in the process. Ive tried diff. approaches on views update criteria but still no effect at all. Please help me it gives me a terrible headache for this thing. I dont want to resort using msaccess.

May be a stupid question, but do you have 'Send SQL Updates' checked in the view designer?
Are you using the following syntax (your message was unclear)?

TABLUPDATE('MyView',.T.,.T.)

I have never had any problems connecting to Access and am not aware of any secret settings for getting it to accept updates.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform