Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Thanks Cetin
Yes v_ticket is the current alias.
The help file seems to indicate that I must use the iForce option if I specify a table name.
>>I have a table TICKET
>>It has a primary key called P_Ticket
>>
>>I have an indexed view onto this Table called V_TICKET ( CURSORSETPROP("Buffering",3) )
>>
>>To insert a record I am doing the following
>>
>>*I insert a record into v_ticket
>>
>>insert into v_ticket (ticket) values (myValue)
>>=tableupdate(.t.)
>>
>>* This triggers NextKey routine which now generates a primary key for me
>>
>>At this point I have a primary key in my TICKET table but I do not have a Primary key in my V_TICKET view table.
>>
>>Since I need this key to be in my view I populate the view primary key as follows
>>
>>REPLACE v_ticket.P_ticket WITH giPrimaryKey && giPrimaryKey gets set when nextkey() is run
>>
>>* if I now do a table update (to be on the safe side)
>>=tableupdate(.t.)
>>
>>at this point my update fails with update conflict.
>>
>>I realise that I can do a REQUERY() instead of the above REPLACE but it is very inefficient to do this at this point.
>>
>>Please advise me if there is a solution to this problem.
>>
>>(Using Tableupdate with the lForce set stops the update failing but this is not desirable)
>>
>>Many Thanks
>
>Mark,
>Just one question. Is v_ticket current alias when you call tableupdate ? Better call it :
>tableupdate(...'v_ticket')
>Cetin
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement