General information
Category:
Coding, syntax & commands
I've tried aliasing the field name and still no joy. here is what is happending:
create sql view Polh Remote connection Policies as ;
select id, Branch, Propnum, clientcode, licocode, classcode, ;
eventcode, policynum, termyears, riskdate, maturitydate, ;
"1st_2ndDeathBenefit" as DeathBen ;
from PolHistory
1st_2nd Deathbenefit is the problem field. A digit as the first char. If I leave things as they are at this point, I can update the contents of this field by changing its alias "DeathBen". All looks well but when you see the table back in Access, no changes have been made. So I have added the following:
cursorsetprop("KeyFieldList","Branch, PropNum, ClientCode")
cursorsetprop("UpdateNameList","DeathBen Polh.1st_2ndDeathBenefit)
cursorsetprop("Sendupdates",.T.)
cursorsetprop("Tables","PolH")
cursorsetprop("UpdatableFieldList","Deathben")
All seems well at this point, you can add and change the contents of the DeathBen field, but as soon as i try to update, I get connectivity errors.
I am sure I cant be far from the solution, but it is a Friday, Ive got a headache and this is my first foray into ODBC.
Any help would be monumentally appreciated.
Ashley
Assuresoft.
Previous
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