This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[<MASTER."VALOR_PAGO"> - (<MASTER."VALOR_PAGO"> * (<MASTER."TAXA_ADMINISTRATIVA"> / 100))] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var | |
GrupoRodapeColaborador: Integer; | |
procedure GF_COLABORADOROnAfterPrint(Sender: TfrxComponent); | |
begin | |
GrupoRodapeColaborador := 0; | |
end; | |
procedure GF_COLABORADOROnBeforePrint(Sender: TfrxComponent); | |
begin |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[<MASTER."QUANTIDADE"> * <MASTER."VALOR_UNITARIO">] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$path = "D:\trunk" | |
Get-ChildItem $path -Hidden -Recurse -Filter "__history" | Remove-Item -Force -Verbose -Recurse | |
Write-Host "Feito: __history" | |
Write-Host | |
Get-ChildItem $path -Hidden -Recurse -Filter "__recovery" | Remove-Item -Force -Verbose -Recurse | |
Write-Host "Feito: __recovery" | |
Write-Host |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[ | |
IIF(Length(<MASTER."CNPJ_CPF">) = 11, | |
FormatMaskText('000\.000\.000\-00;0;_', <MASTER."CNPJ_CPF">), | |
FormatMaskText('00\.000\.000\/0000\-00;0;_', <MASTER."CNPJ_CPF">), | |
) | |
] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Salvar em crontab -e: | |
# Backup do banco de dados TROPICAL.fdb - 12:00 todo dia | |
0 12 * * * cd /ESTACAO/BANCODADOS && ./backup_banco_dados_tropical.sh | |
# Backup do banco de dados TROPICAL.fdb - 00:00 todo dia | |
0 0 * * * cd /ESTACAO/BANCODADOS && ./backup_banco_dados_tropical.sh |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# google-drive-ocamlfuse | |
$ sudo add-apt-repository ppa:alessandro-strada/ppa | |
$ sudo apt update && sudo apt install google-drive-ocamlfuse | |
# To set your Google drive folder, launch the tool. | |
$ google-drive-ocamlfuse | |
# It’ll pop up a webpage in your default browser, prompting you to log in to your Google account. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Guarda data inicial. | |
dataInicial=$(date) | |
# Envia notificação para ser mostrado no sistema. | |
zenity --notification --text "$dataInicial: Iniciando rotina de backup automático para GDrive." | |
# Salva texto em arquivo de log. | |
echo "$dataInicial: Iniciando rotina de backup automático para GDrive." >> /ESTACAO/BANCODADOS/log_gbak_fdb.log | |
# Gera o arquivo de backup. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE OR ALTER USER FB_ADMIN PASSWORD 'fb_admin' GRANT ADMIN ROLE; | |
EXECUTE BLOCK | |
AS | |
DECLARE VARIABLE tablename VARCHAR(32); | |
BEGIN | |
FOR SELECT rdb$relation_name | |
FROM rdb$relations | |
WHERE rdb$view_blr IS NULL | |
AND (rdb$system_flag IS NULL OR rdb$system_flag = 0) |