Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate View Error
Message
From
27/04/2001 14:58:06
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00500856
Message ID:
00500976
Views:
25
>>>>Our opinions on that particular generic error are in agreement... But I'm even getting it if I open the project, browse any view and issue the update from the command window... It will work only if I use just the force parameter, but not with the alias... Any ideas?
>>>>
>>>>Renoir
>>>>
>>>>>>I am getting the error, "Function arguement value, type, or count is invalid." when calling...
>>>>>>
>>>>>>TableUpdate(.T.,"v_Allegations")
>>>>>>
>>>>>>...where v_Allegations is my (currently selected) view name. What is going on? Thanks!
>>>>>>
>>>>>>Regards, Renoir
>>>>>
>>>>>I love that error. The main thing I check for when I get this is that the data types are correct in what you are updating. Dont shove a character string into a numeric field, or a character into a Date field, etc...
>>>>>
>>>>>HTH
>>>
>>>Does the tableupdate work if you do:
>>>
>>>SELECT v_Allegations
>>>TableUpdate()
>>
>>Yes - no error; only when I add the alias. Are you on to something?
>
>Have you made changes to the table structure since the view was created?
>Have you deleted field or rearranged fields in the table since the view was created?

Nope... I'm going to shut everything down and reload my classes. Maybe something is just hanging-on like it does sometimes in Fox...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform