>>>I have master-detail form with both master and detail tables on table buffered mode. Both of them are put on grid. After I issue a COUNT TO ... (or CALCULATE XXX()) on the child table and when I start appending new record, I will get Uniqueness of Index Violation on my child table's primary key. The primary key is generated from NEWID function (tastrade) and I can't imagine how it can go wrong.
>>>
>>>Is it a bug in VFP? Anyone has encountered such thing before? I suspect having two table-buffered grids will cause such problem.
>>>
>>>Any opinion?
>>>
>>>Thanks in advance.
>>
>>Hi Tai,
>>I don't know if I got the problem , but why don't you use an Insert SQL statement instead of append ?
>>I think it will give you no problem.
>> HTH
>>Alessio
>
>Hi! I didn't want to code INSERT INTO the primary key field and the NEWID() function in my program. It will make the program harder to maintain.
>
>Anyway, I found that my problem would go away if I removed 'DODEFAULT()' in the grid refresh. It is strange... Isn't it?
Yes it is.
Alessio
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