Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Atualizando banco de dados
Message
 
To
28/01/2002 07:08:12
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00611428
Message ID:
00611588
Views:
22
This message has been marked as a message which has helped to the initial question of the thread.
Aqui utilizamos esta rotina:
public m.gcInsertDisabled
public array aUpgrade(1,1)
m.lnUpgrade=adir(aUpgrade,".\upgrade\*.dbf")
for m.loop1=1 to alen(aUpgrade,1)
	wait window "Upgrade da tabela "+aupgrade(m.loop1,1) noclear nowait
	m.lcMacro=".\upgrade\"+aupgrade(m.loop1,1)
	m.lcMacro1=".\db\"+aupgrade(m.loop1,1)
	use (lcMacro) exclusive
	zap
	append from (lcMacro1)
endfor
release m.gcInsertDisabled
close databases all
wait window "Linkando novas tabelas" noclear nowait
copy file .\upgrade\*.* to .\db
wait window "Apagando versão antiga" noclear nowait
delete file .\upgrade\*.* 
=messagebox("upgrade realizado com sucesso. ",64,"Informação")
Assim, não importa que modificação fizemos ou mesmo que tabela, o upgrade das tabelas sempre vai acontecer normalmente.

Pasta de origem: DB
Pasta dos novos arquivos: UPGRADE
Cordialmente,

Fabiano Costa
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform