Message
From
27/06/2001 12:55:44
To
26/06/2001 19:54:12
General information
Fórum:
Visual FoxPro
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Título:
Miscellaneous
ID da thread:
00523854
ID da mensagem:
00524275
Views:
24
Nadya,
When multiple DBCs are opened and have a stored procedure with the same name the CURRENT database's (SET DATABASE TO) stored procedure is executed. If no database is set as current.
If no database is set to current if you open a table in each database without issuing SET DATABASE TO. Both databases are opened but neither are set as the current. In this case, the database opened lasted will execute the stored procedure.
As far as your default values are concerned. They are only used if you don't supply a value. So in your case, updating the cursor's primary key then issuing a TABLEUPDATE() will override the default value procedure from being executed.
Will
When multiple DBCs are opened and have a stored procedure with the same name the CURRENT database's (SET DATABASE TO) stored procedure is executed. If no database is set as current.
If no database is set to current if you open a table in each database without issuing SET DATABASE TO. Both databases are opened but neither are set as the current. In this case, the database opened lasted will execute the stored procedure.
As far as your default values are concerned. They are only used if you don't supply a value. So in your case, updating the cursor's primary key then issuing a TABLEUPDATE() will override the default value procedure from being executed.
Will
Heavy Metal Pedal - click with care