Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I have an invoice an its itens
Both cursors are buffered as 4
The ID field of the invoice_header.dbf has a relation
with the ID of the iten.dbf
I generate the ID of the invoice_header.dbf by
***************************
dimension lctemp[1]
select max(ap.id2) from ap ;
into array lctemp
lcTemp[1] = nvl(lcTemp[1],0)+1
replace ap.id2 with lctemp
*******************************
The code above is in the init event of the form
Then, as itens are added :
replace iten.id with invoice_heard.ID
So I can see in the form, the header and its itens while they are added
But this would cause problem in a network
because the same ID could be generated
by both operators
How do you guys overcome it ?
I would generate the ID only in the save method, but
this way I would not be able to see the itens
Moises
Suivant
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