Recent content by kueyiar

Hi, we've just connected a second site to our hq offices. We have a 128mb dedicated link from this second site to our hq. We are running an vfp/sql client/server application. The thing is, it takes about 1min and a half to load up the application when at hq office takes about 3-5seconds, queries...

_Ras Thank you so much for your help, reserverd words where my problem, now everything is working perfectly. Strange thing though how it allowed me to do use some of them on other cases, but oh well, thank you guys so much !

Its funny that you mention it, i've been using it that way since vfp5 and never had this problem. I tried your suggestion, but no luck at all, still get the same error.. Any other thoughts.. Do you have any special setting or set pre defined on your work area i may be missing ?

Nope no relationships at all. I created a new tryout .dbc , table and view to see if it where something like that, but the error remains. I did a search for error code 10 on vfp help and all it says is "syntax error"... I really don't know what could be wrong, why can it let me append a new...

This is how i tried to update it: IF TABLEUPDATE(1,.T.,'VCHARGES') and i tried :IF TABLEUPDATE(.T.) as well..same error I've recreated under a differente location the table, .dbc and view, yet the error still appears.. By the way the JOIN still get created automatically..

I validated the database and no error apparently occured, under error for AERROR(laDataError) i gel #10 Any thoughts...?

_RAS I changed the field names and still have the same problem. How could i check if :"AERROR(). REQUERY() with a dirty buffer (failed update will leave the buffer dirty) will trigger an error.

_RAS The error occurs when i try a =requery() right after i have issued a =tableupdate(.t.) This is what the structure of the view looks like SELECT *; FROM ; charges; WHERE Charges.code LIKE ( ?parA ) DBSetProp(ThisView,"View","SendUpdates",.T.)...

Well, i'm trying it on vfp7. Its very strange, i just created a new table on a new .dbc i tried creating a new record, issued the =tableupdate(.t.), used =requery(), modified the record, issued another =requery() and it worked, the thing is i closed the .dbc and tried to do the same operation...

I'm using the vieweditor .exe that you recommended and its supposedly telling me that the alias of the .dbc is not assigned correctly for instas where it shoutd be hotels!charges.code appears only as charges.code Its supposed to be the problem or isn't it !? antonio

Mike, The thing is mike, i have the view with send sql updates, pk, updatable fields and everything(its a parametrized view by the way), i run a =requery(), it asks me for the data i wish to search, i input it, it shows me the result, i issue a =tableupdate(.t.) and when i issue a =requery()...

Angie, Did you ever find a solution for that "syntax error" message, i have the same problem. antonio.

What is the correct way to update and requery a local sql view on vfp7 and vfp8?

It is about views, that is what i meant. If i use a view with a table already build on old version that already contains records i'm able to append and modifiy it, different case with the views i use with tables built on vfp8, does the function oldval() have anything to do with it !?

I've noticed something strange: I use views to update tables of vfp previous version 6,7; update, revert, append with my current 8.0 version and everything is fine, but if i try to do the same thing on a new table it will only allow me to append it new, not modify it. Does the function oldval()...