Monday, February 13, 2012

Am I in the right direction?

I am using VFP as my interface and using SQL table as my back-end but recently i got this problem when i add another field in one of my tables, Before it has only 35 field and it goes right, but when I add another 3 fields my problem starts,... if i edit a character fields with all necessary code to update a record and accepted by SQL it has no problem... but when i edit the numeric field which I add, after i refresh my form, it goes back to each original values. at sql table also when i opened nothing happened the old value still there.

Thank you for any help

Hi Madix_t,

Do you add the field via SQL Management Studio or by ALTER TABLE statements via SQL Pass-through?

I assume you use Visual FoxPro Remote Views, or perhaps VFP CursorAdapters to access the data, or are you using SQL Pass-through? Are you using a buffering scheme?

How are you changing the data? After you've typed in the Textbox (or Grid) do you use the VFP TableUpdate() statement to commit the changes? Do you then requery the SQL back end before you refresh the form?

|||

I am using CursorAdapter, and I even tried to recreate the CA, but it's d'same.

Regarding how I save my data, i dont have any problem with all my tables in MS SQL at VFP interface, all necessary steps that SQL will accept my data has been followed ,.. just only this table after I add another fields., and also this is the only table that has 38 fields.

thanks for any help

|||

Hi Madix_t,

Can you duplicate this problem with a new table? Is there anything about the column that's odd such as being accidentally set to read-only or having a constraint that prohibits the update values you've used?

|||

ok..i'll try it, and thank you maam

No comments:

Post a Comment