Archivo anual: 2019

0

Debug Problems – ContextSwitchDeadlock –

While debugging an application written in C #, I found the following error, Context «ContextSwitchDeadlock». The process waits to load a file in txt. ContextSwitchDeadlock detected Message: The CLR could not make the COM...

0

Format Chilean Rut in Postgresql

Here is a very practical method to format Chilean Rut (xx.xxx.xxx-x) The only requirement is to have the following function previously.PadIndex Postgresql CREATE OR REPLACE FUNCTION public.fn_format_rut(var_rut varchar(12)) RETURNS varchar(12) as $ declare v_cont...

0

PatIndex Postgresql

As you may already notice postgresql does not contain the function patidex, it is for this reason that we bring them to you next: CREATE OR REPLACE FUNCTION patindex(pattern VARCHAR, expression VARCHAR ) RETURNS...

0

Get and set .ini file values c #

Suppose you have an .ini file with the following information: [Data] Count=5 The following functions will allow you to obtain and modify your configuration file in a simple way: using System.Runtime.InteropServices; using System.Text; namespace...

0

Get data from a table in MySQL

In MYSQL there are several methods to know if a table exists or get information from the table directly from the SHEMA, one way is as follows: SELECT TABLE_SCHEMA AS BD, TABLE_NAME AS NOMBRE_TABLA,...