References:
http://www.compartir-tecnologias.es/call-id-y-c-ayuda-206872292.html
Code
http://www.codeproject.com/KB/dotnet/CShart_TAPI_3x.aspx
http://stackoverflow.com/questions/3128204/how-detect-caller-id-from-phone-line
http://www.forosdelweb.com/f29/modem-con-identificador-llamadas-caller-id-con-c-694795/
http://intellitechture.com/The-basics-of-System-IO-Ports-SerialPort/
http://www.tech-archive.net/Archive/Development/microsoft.public.win32.programmer.tapi/2006-06/msg00106.html
Test Modem
http://stackoverflow.com/questions/1200921/how-to-get-caller-id-in-c
Wednesday, December 28, 2011
Saturday, December 10, 2011
Enable SVN log edit (Windows)
Create pre-revprop-change.bat and save it in the /hooks subdirectory for your repository.
references:
[1] http://stackoverflow.com/questions/692851/can-i-go-back-and-edit-comments-on-an-svn-checkin
[2] http://stackoverflow.com/questions/197224/what-is-a-pre-revprop-change-hook-in-svn-and-how-do-i-create-it
set userName=%3
set propertyName=%4
set action=%5
:: Only allow the log message to be changed, but not author, etc.
if /I not "%propertyName%" == "svn:log" goto ERROR_PROPNAME
:: Only allow modification of a log message, not addition or deletion.
if /I not "%action%" == "M" goto ERROR_ACTION
:: Make sure that the new svn:log message is not empty.
set bIsEmpty=true
for /f "tokens=*" %%g in ('find /V ""') do (
set bIsEmpty=false
)
if "%bIsEmpty%" == "true" goto ERROR_EMPTY
goto :eof
:ERROR_EMPTY
echo Empty svn:log messages are not allowed. >&2
goto ERROR_EXIT
:ERROR_PROPNAME
echo Only changes to svn:log messages are allowed. >&2
goto ERROR_EXIThttp://www.blogger.com/img/blank.gif
:ERROR_ACTION
echo Only modifications to svn:log revision properties are allowed. >&2http://www.blogger.com/img/blank.gif
goto ERROR_EXIT
http://www.blogger.com/img/blank.gif
:ERROR_EXIT
exit /b 1
references:
[1] http://stackoverflow.com/questions/692851/can-i-go-back-and-edit-comments-on-an-svn-checkin
[2] http://stackoverflow.com/questions/197224/what-is-a-pre-revprop-change-hook-in-svn-and-how-do-i-create-it
Wednesday, November 30, 2011
Tuesday, November 29, 2011
Thursday, November 24, 2011
Servicios Windows
[1] ¿Cómo hacer un Servicio Windows en C#?
http://www.cjorellana.net/2009/07/como-hacer-un-servicio-windows-en-c.html
[2] Crear un servicio windows y un instalador de un servicio windows.
http://www.onglasses.net/Default.aspx?id=4450
http://www.cjorellana.net/2009/07/como-hacer-un-servicio-windows-en-c.html
[2] Crear un servicio windows y un instalador de un servicio windows.
http://www.onglasses.net/Default.aspx?id=4450
Inteligencia emocional
Test
http://www.helios3000.net/cgi-bin/tests/eq.pl
Referencias
[1]Escala de inteligencia http://es.wikipedia.org/wiki/Wechsler_Adult_Intelligence_Scale
http://www.helios3000.net/cgi-bin/tests/eq.pl
Referencias
[1]Escala de inteligencia http://es.wikipedia.org/wiki/Wechsler_Adult_Intelligence_Scale
Wednesday, November 16, 2011
Configurar Celular - Claro - Perú
I) Internet (Configura el acceso de Internet )
01) Press [Menu] and select [Settings] .
02) Scroll to [Connectivity] tab and select [Internet settings] .
03) In [Internet settings] , select [Connect using] .
04) In [Data accounts] press [Options] > [Create new] > [PS data] .
Enter the following information :
Name : CLARO DATOS DM
APN : claro.pe
05) Press [Save] .
06) In [Data accounts] , select the created profile, CLARO DATOS DM and press [Options] > [Edit] .
Enter the following information :
APN : claro.pe
Username : claro
Password : claro
Login request : Off
IP address : Ignore
DNS address : Ignore
Authentication : Ignore
Data compression : Off
Header compr. : Off
Proxy settings : Press [Edit].
Proxy : Off
07) Press the end call key to return to the main screen.
The profile is saved .
II) MMS GPRS(Configura el acceso a Mensajes Multimedia )
01) Press [Menu] and select [Messaging] > [Settings] > [Picture message] > [MMS profile] .
02) In [MMS profile] select [New profile] (press [Add] ).
Enter the following information :
MMS profile name : CLARO MMS DM
Message server : http://claro/servlets/mms
Connect using : Press [Edit]
03) In [Data accounts] press [Options] > [Create new] > [PS data] .
Enter the following information :
Name : CLARO MMS DM
APN : mms.claro.pe
04) Press [Save] .
05) In [Data accounts] , select the created profile, CLARO MMS DM and press [Options] > [Edit] .
Enter the following information :
APN : mms.claro.pe
Username : claro
Password : claro
Login request : Off
IP address : Ignore
DNS address : Ignore
Authentication : Ignore
Data compression : Off
Header compr. : Off
Proxy settings : Press [Edit].
Proxy : On
Same for all servers : Off
Proxy servers : Press [Edit].
HTTP :
Username : Leave blank
Password : Leave blank
Proxy address : 192.168.231.30
Port : 80
06) Press [Back] four times, to return to [Data accounts] .
07) In [Data accounts] select the created profile, CLARO MMS DM (press [Select] ).
08) Press [Save] .
09) In [MMS profile] select the created profile, CLARO MMS DM (press [Select] ).
The profile is saved and activated .
III) WAP GPRS(Configura el acceso a WAP)
01) Press [Menu] and select [Settings] .
02) Scroll to [Connectivity] tab and select [Internet settings] .
03) In [Internet settings] , select [Connect using] .
04) In [Data accounts] press [Options] > [Create new] > [PS data] .
Enter the following information :
Name : CLARO WAP DM
APN : wap.claro.pe
05) Press [Save] .
06) In [Data accounts] , select the created profile, CLARO WAP DM and press [Options] > [Edit] .
Enter the following information :
APN : wap.claro.pe
Username : claro
Password : claro
Login request : Off
IP address : Ignore
DNS address : Ignore
Authentication : Ignore
Data compression : Off
Header compr. : Off
Proxy settings : Press [Edit].
Proxy : On
Same for all servers : Off
Proxy servers : Press [Edit].
HTTP :
Username : Leave blank
Password : Leave blank
Proxy address : 192.168.231.30http://www.blogger.com/img/blank.gif
Port : 80http://www.blogger.com/img/blank.gif
07) Press [Back] four times to return to [Data accounts] .
08) In [Data accounts] , select the created profile, CLARO WAP DM (press [Select] ).
Enter the following information :
Allow local conn. : Ignore
09) Press [Save] .
The profile is saved and activated .
Referencias:
[1] http://dmcatc.hc012.sicap.com/frontoffice.view
[2] http://www.ivanandrei.com/2010/12/configura-wap-data-y-mms-de-claro-peru-con-solo-ingresar-tu-numero/
01) Press [Menu] and select [Settings] .
02) Scroll to [Connectivity] tab and select [Internet settings] .
03) In [Internet settings] , select [Connect using] .
04) In [Data accounts] press [Options] > [Create new] > [PS data] .
Enter the following information :
Name : CLARO DATOS DM
APN : claro.pe
05) Press [Save] .
06) In [Data accounts] , select the created profile, CLARO DATOS DM and press [Options] > [Edit] .
Enter the following information :
APN : claro.pe
Username : claro
Password : claro
Login request : Off
IP address : Ignore
DNS address : Ignore
Authentication : Ignore
Data compression : Off
Header compr. : Off
Proxy settings : Press [Edit].
Proxy : Off
07) Press the end call key to return to the main screen.
The profile is saved .
II) MMS GPRS(Configura el acceso a Mensajes Multimedia )
01) Press [Menu] and select [Messaging] > [Settings] > [Picture message] > [MMS profile] .
02) In [MMS profile] select [New profile] (press [Add] ).
Enter the following information :
MMS profile name : CLARO MMS DM
Message server : http://claro/servlets/mms
Connect using : Press [Edit]
03) In [Data accounts] press [Options] > [Create new] > [PS data] .
Enter the following information :
Name : CLARO MMS DM
APN : mms.claro.pe
04) Press [Save] .
05) In [Data accounts] , select the created profile, CLARO MMS DM and press [Options] > [Edit] .
Enter the following information :
APN : mms.claro.pe
Username : claro
Password : claro
Login request : Off
IP address : Ignore
DNS address : Ignore
Authentication : Ignore
Data compression : Off
Header compr. : Off
Proxy settings : Press [Edit].
Proxy : On
Same for all servers : Off
Proxy servers : Press [Edit].
HTTP :
Username : Leave blank
Password : Leave blank
Proxy address : 192.168.231.30
Port : 80
06) Press [Back] four times, to return to [Data accounts] .
07) In [Data accounts] select the created profile, CLARO MMS DM (press [Select] ).
08) Press [Save] .
09) In [MMS profile] select the created profile, CLARO MMS DM (press [Select] ).
The profile is saved and activated .
III) WAP GPRS(Configura el acceso a WAP)
01) Press [Menu] and select [Settings] .
02) Scroll to [Connectivity] tab and select [Internet settings] .
03) In [Internet settings] , select [Connect using] .
04) In [Data accounts] press [Options] > [Create new] > [PS data] .
Enter the following information :
Name : CLARO WAP DM
APN : wap.claro.pe
05) Press [Save] .
06) In [Data accounts] , select the created profile, CLARO WAP DM and press [Options] > [Edit] .
Enter the following information :
APN : wap.claro.pe
Username : claro
Password : claro
Login request : Off
IP address : Ignore
DNS address : Ignore
Authentication : Ignore
Data compression : Off
Header compr. : Off
Proxy settings : Press [Edit].
Proxy : On
Same for all servers : Off
Proxy servers : Press [Edit].
HTTP :
Username : Leave blank
Password : Leave blank
Proxy address : 192.168.231.30http://www.blogger.com/img/blank.gif
Port : 80http://www.blogger.com/img/blank.gif
07) Press [Back] four times to return to [Data accounts] .
08) In [Data accounts] , select the created profile, CLARO WAP DM (press [Select] ).
Enter the following information :
Allow local conn. : Ignore
09) Press [Save] .
The profile is saved and activated .
Referencias:
[1] http://dmcatc.hc012.sicap.com/frontoffice.view
[2] http://www.ivanandrei.com/2010/12/configura-wap-data-y-mms-de-claro-peru-con-solo-ingresar-tu-numero/
Salesforce - General Information
http://www.blogger.com/img/blank.gif
Referenceshttp://www.blogger.com/img/blank.gif
[1]http://wiki.developerforce.com/page/Force.com_Tutorial:_An_Introduction_to_Visualforce
[2] Adding Custom List Buttons using Standard List Controllers
http://www.salesforce.com/us/developer/docs/pages/Content/pages_controller_sosc_custom_button.htm
[3]
http://sfdc.arrowpointe.com/2009/01/08/invoke-apex-from-a-custom-button-using-a-visualforce-page/
[4] Send email and validation form
http://gokubi.com/archives/using-javascript-to-validate-an-apex-form
[5] Invoke apex from custom button
http://sfdc.arrowpointe.com/2009/01/08/invoke-apex-from-a-custom-button-using-a-visualforce-page/
Referenceshttp://www.blogger.com/img/blank.gif
[1]http://wiki.developerforce.com/page/Force.com_Tutorial:_An_Introduction_to_Visualforce
[2] Adding Custom List Buttons using Standard List Controllers
http://www.salesforce.com/us/developer/docs/pages/Content/pages_controller_sosc_custom_button.htm
[3]
http://sfdc.arrowpointe.com/2009/01/08/invoke-apex-from-a-custom-button-using-a-visualforce-page/
[4] Send email and validation form
http://gokubi.com/archives/using-javascript-to-validate-an-apex-form
[5] Invoke apex from custom button
http://sfdc.arrowpointe.com/2009/01/08/invoke-apex-from-a-custom-button-using-a-visualforce-page/
Salesforce API - Dates
Query with DateTime field in Salesforce
If you have to work with DateTime field in Salesforce, consider next items:
1. Don't use quote
For example:
SELECT Id FROM Opportunity WHERE CreatedDate > 2005-10-08
2. Use DateTime literals: YESTERDAY, TODAY, TOMORROW, LAST_WEEK, THIS_WEEK, NEXT_WEEK, ...
For example:
SELECT Id FROM Account WHERE CreatedDate = LAST_WEEK
3. DateTime in Salesforce is UTC format
For example(C#):
string strSQL = "SELECT Id FROM Opportunity WHERE CreatedDate > " + DateTime.Today.ToString("yyyy-MM-dd");
If you have to work with DateTime field in Salesforce, consider next items:
1. Don't use quote
For example:
SELECT Id FROM Opportunity WHERE CreatedDate > 2005-10-08
2. Use DateTime literals: YESTERDAY, TODAY, TOMORROW, LAST_WEEK, THIS_WEEK, NEXT_WEEK, ...
For example:
SELECT Id FROM Account WHERE CreatedDate = LAST_WEEK
3. DateTime in Salesforce is UTC format
For example(C#):
string strSQL = "SELECT Id FROM Opportunity WHERE CreatedDate > " + DateTime.Today.ToString("yyyy-MM-dd");
Monday, November 14, 2011
Friday, November 11, 2011
Salesforce API - SQL
Salesforce API(Relationship Queries)
http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_relationships.htm
http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_relationships.htm
Wednesday, November 09, 2011
Visual C++ Runtime version
If you install an application and receive an error that the C runtime is not available or you need to develop an application using the runtime, you may need to obtain one or more versions. There are multiple versions of the Visual C runtime:
* Msvcr90.dll -Visual C++ 2008
* Msvcr80.dll -Visual C++ 2005
* Msvcr71.dll -Visual C++ .NET 2003 (.NET Framework 1.1)
* Msvcr70.dll -Visual C++ .NET 2002 (.NET Framework 1.0)
* Msvcr90.dll -Visual C++ 2008
* Msvcr80.dll -Visual C++ 2005
* Msvcr71.dll -Visual C++ .NET 2003 (.NET Framework 1.1)
* Msvcr70.dll -Visual C++ .NET 2002 (.NET Framework 1.0)
Friday, October 28, 2011
Winamp Alternatives
XMPlay
http://www.un4seen.com/
Sonique
http://oldapps.com/download.php?oldappsid=sonique196.exe
References
[1] Download players http://www.megaupload.com/?d=BF2X2POA
[2] http://www.techmalaya.com/2007/10/25/10-alternatives-to-winamp-desktop-music-player-freeware/
[3] https://github.com/noahwilliamsson/openspotify
http://www.un4seen.com/
Sonique
http://oldapps.com/download.php?oldappsid=sonique196.exe
References
[1] Download players http://www.megaupload.com/?d=BF2X2POA
[2] http://www.techmalaya.com/2007/10/25/10-alternatives-to-winamp-desktop-music-player-freeware/
[3] https://github.com/noahwilliamsson/openspotify
Thursday, October 27, 2011
Postgres - Fechas
Tipos Fecha
timestamp
timestamp with time zone
date
time
time with time zone
interval
Variables de Fecha
CURRENT_DATE : Fecha Actual
CURRENT_TIME : Hora Actual
CURRENT_TIMESTAMP : Fecha y Hora Actual
LOCALTIME
LOCALTIMESTAMP
referencias:
[1] http://elreinodelterror.wordpress.com/2011/02/01/fechas-y-horas-en-postgres/
[2] http://saforas.wordpress.com/2009/11/12/postgresql-fechas-y-horas/
[3] http://postgresql.ru.net/manual/functions-formatting.html
timestamp
timestamp with time zone
date
time
time with time zone
interval
Variables de Fecha
CURRENT_DATE : Fecha Actual
CURRENT_TIME : Hora Actual
CURRENT_TIMESTAMP : Fecha y Hora Actual
LOCALTIME
LOCALTIMESTAMP
referencias:
[1] http://elreinodelterror.wordpress.com/2011/02/01/fechas-y-horas-en-postgres/
[2] http://saforas.wordpress.com/2009/11/12/postgresql-fechas-y-horas/
[3] http://postgresql.ru.net/manual/functions-formatting.html
Wednesday, October 26, 2011
Claro TUN
Para acceder a la Tarifa Única Nacional (TUN), el cliente debe inscribirse llamando al *779, opción 8.
Friday, October 14, 2011
Salesforce - Using Custom Objects
References:
[1] Introduction to Visualforce
http://wiki.developerforce.com/index.php/Force.com_Tutorial:_An_Introduction_to_Visualforce
[1] Introduction to Visualforce
http://wiki.developerforce.com/index.php/Force.com_Tutorial:_An_Introduction_to_Visualforce
Salesforce - List Custom Ojects
<apex:page standardController="External_Competitor__c" sidebar="false" showHeader="false" >
<apex:sectionHeader title="Engineering Change Order: ECO Details" />
<apex:PageMessages />
<apex:messages />
<apex:listViews type="External_Competitor__c" />
</apex:page>
<apex:sectionHeader title="Engineering Change Order: ECO Details" />
<apex:PageMessages />
<apex:messages />
<apex:listViews type="External_Competitor__c" />
</apex:page>
Thursday, October 06, 2011
Friday, September 30, 2011
Visual Studio 2008 plugin
highlights substrings that are currently selected
http://code.google.com/p/wordlight/
http://code.google.com/p/wordlight/
Thursday, September 29, 2011
Postgres Backup guide
if you use pg_dump ppp > xxx.tar, then you get error, use standard format for big databases.
references:
[1] http://sparcki.blogspot.com/2010/11/copias-de-seguridad-y-recuperacion-en.html
[2] http://www.rolandovera.com/2008/07/09/forma-correcta-de-sacar-un-respaldo-backup-en-postgresql/
references:
[1] http://sparcki.blogspot.com/2010/11/copias-de-seguridad-y-recuperacion-en.html
[2] http://www.rolandovera.com/2008/07/09/forma-correcta-de-sacar-un-respaldo-backup-en-postgresql/
Alternative WLM Clients - Messenger
emesene, works fine without logout at using www.hotmail.com
digsby( not yet tested)
trillian ( not yet tested)
References:
[1] http://alternativeto.net/software/windows-live-messenger/
[2] http://blog.emesene.org/p/downloads.html
digsby( not yet tested)
trillian ( not yet tested)
References:
[1] http://alternativeto.net/software/windows-live-messenger/
[2] http://blog.emesene.org/p/downloads.html
Wednesday, September 28, 2011
Track visitors using ASP.NET & C#
References:
[0]Getting The Real IP Of Your Users
http://thepcspy.com/read/getting_the_real_ip_of_your_users/
[1] How to track visitors to your site in ASP.NET & C#
http://www.mycsharpcorner.com/Post.aspx?postID=27
[2] Server variables http://www.aspnetcenter.com/cliktoprogram/asp/serverVariables.asp
[0]Getting The Real IP Of Your Users
http://thepcspy.com/read/getting_the_real_ip_of_your_users/
[1] How to track visitors to your site in ASP.NET & C#
http://www.mycsharpcorner.com/Post.aspx?postID=27
[2] Server variables http://www.aspnetcenter.com/cliktoprogram/asp/serverVariables.asp
Labels:
C#,
Web.Developer,
Windows.Developer
Tuesday, September 27, 2011
Thursday, September 22, 2011
Dynamic Java Web Start App (JNLP) Using Servlet
Remember sign jar files main and libraries before publish/upload
set path=%path%;c:\J2EE\Java\jdk1.6.0\bin
keytool -genkey -keystore OlvaKeys -alias Olva
jarsigner -keystore OlvaKeys vsislocal.importer.jar Olva
jarsigner -keystore OlvaKeys postgresql-8.4-701.jdbc4.jar Olva
Notes:
The jardiff tool, jnlp-servlet.jar file, and jnlp.jar file http://www.blogger.com/img/blank.gifcan be found in the samples directory of the JDK.
reference:
[1] http://download.oracle.com/javase/1.4.2/docs/guide/jws/downloadservletguide.html
[2] http://portal.krypthonas.de/2010/10/11/passing-dynamically-parameters-to-a-java-web-start-app-jnlp/
[3] Distribute JWS Application http://www1.oan.es/informes/archivos/IT-OAN-2006-8.pdf
[4] Automatically Signing http://ezzatron.com/2009/09/29/automatically-signing-jar-files-in-netbeans/
[5] Netbeans + Webstart + Auto-signing http://netbeans-org.1045718.n5.nabble.com/Webstart-High-Learning-Curve-td2912653.html
set path=%path%;c:\J2EE\Java\jdk1.6.0\bin
keytool -genkey -keystore OlvaKeys -alias Olva
jarsigner -keystore OlvaKeys vsislocal.importer.jar Olva
jarsigner -keystore OlvaKeys postgresql-8.4-701.jdbc4.jar Olva
Notes:
The jardiff tool, jnlp-servlet.jar file, and jnlp.jar file http://www.blogger.com/img/blank.gifcan be found in the samples directory of the JDK.
reference:
[1] http://download.oracle.com/javase/1.4.2/docs/guide/jws/downloadservletguide.html
[2] http://portal.krypthonas.de/2010/10/11/passing-dynamically-parameters-to-a-java-web-start-app-jnlp/
[3] Distribute JWS Application http://www1.oan.es/informes/archivos/IT-OAN-2006-8.pdf
[4] Automatically Signing http://ezzatron.com/2009/09/29/automatically-signing-jar-files-in-netbeans/
[5] Netbeans + Webstart + Auto-signing http://netbeans-org.1045718.n5.nabble.com/Webstart-High-Learning-Curve-td2912653.html
Tuesday, September 20, 2011
Saturday, September 17, 2011
ASP.NET:: Maestro Detalle
Referencias:
[1] http://tydw.wordpress.com/2008/02/14/asp-net-formulario-maestro-detalle-aplicable-a-vb-y-c/
[2] http://sqlserversamples.codeplex.com/
[3]http://www.asp.net/data-access/tutorials/using-the-formview-s-templates-cs
[1] http://tydw.wordpress.com/2008/02/14/asp-net-formulario-maestro-detalle-aplicable-a-vb-y-c/
[2] http://sqlserversamples.codeplex.com/
[3]http://www.asp.net/data-access/tutorials/using-the-formview-s-templates-cs
Wednesday, September 14, 2011
Creating .XLS and .XLSX with C#
Code samples:
Visual Studio 2008 C# ASP.NET MVC Web Application
http://sites.google.com/site/leniel/blog/ExcelWriterMvcProject.zip
References:
ExcelPackage: Office Open XML Format file creation
http://excelpackage.codeplex.com/
ExcelPackage binaries download
http://excelpackage.codeplex.com/Release/ProjectReleases.aspx
NPOI
http://npoi.codeplex.com/
Visual Studio 2008 C# ASP.NET MVC Web Application
http://sites.google.com/site/leniel/blog/ExcelWriterMvcProject.zip
References:
ExcelPackage: Office Open XML Format file creation
http://excelpackage.codeplex.com/
ExcelPackage binaries download
http://excelpackage.codeplex.com/Release/ProjectReleases.aspx
NPOI
http://npoi.codeplex.com/
Manual del Conductor
http://www.drtcsanmartin.gob.pe/documentos/manual_conductor/
http://www.mtc.gob.pe/portal/normas_transito/BALOTARIO.pdf
http://www.touringperu.com.pe/info/codigo_transito/balotario.pdf
Accidente Rey latino Bateas Caylloma
https://www.hbanoticias.com/arequipa-volcadura-de-bus-rey-latino-deja-un-fallecido-y-29-heridos-en-caylloma-relacion-de-heridos/
http://www.mtc.gob.pe/portal/normas_transito/BALOTARIO.pdf
http://www.touringperu.com.pe/info/codigo_transito/balotario.pdf
Accidente Rey latino Bateas Caylloma
https://www.hbanoticias.com/arequipa-volcadura-de-bus-rey-latino-deja-un-fallecido-y-29-heridos-en-caylloma-relacion-de-heridos/
Friday, September 09, 2011
Wednesday, September 07, 2011
Saturday, September 03, 2011
ASP.NET::Error de la validación del estado de vista MAC.
Agregar en el archivo web.config lo siguiente:
<pages enableviewstatemac="false">
<pages enableviewstatemac="false">
Friday, September 02, 2011
Tuesday, August 30, 2011
Bakup SQL Server 2008 to SQL Server 2005
http://www.hyper-v-mart.com/HowTo/Convert_SQL_Server_2008_to_SQL_Server_2005.aspx
Resources:
[1]Microsoft SQL Server 2005 Express Edition Toolkit (223.9 MB)
http://go.microsoft.com/fwlink/?LinkId=65111
Resources:
[1]Microsoft SQL Server 2005 Express Edition Toolkit (223.9 MB)
http://go.microsoft.com/fwlink/?LinkId=65111
Saturday, August 20, 2011
Wednesday, August 10, 2011
Power Builder::Tips
DropDown ListBox
http://kell-developer.blogspot.com/2009/09/cargar-una-tabla-un-dropdownlistbox-de.html
Clear datawindow
long ll_i, ll_rc
ll_rc = dw_1.RowCount()
for ll_i = 1 to ll_rc
dw_1.deleterow(1)
next
dw_1.AcceptText()
dw_1.Update(True, True)
--or--
dw_1.Reset() //will never delete the rows from DB, It will just clear the datawindow buffers.
Work with dates
========================================================
dt_today = today()
li_maand = month(dt_today )
li_jaar = year(dt_today )
li_dag = day(dt_today )
apply filter
========================================================
ls_filtro = "columna1 > 100 and columna2 > 30"
dw_1.SetFilter(ls_filtro)
dw_1.Filter( )
references
[0] http://powerbuilder-undiaalavez.blogspot.com/
[1] Tutorial Power Builder 9.0 http://edyovando.galeon.com/INICIO.HTML
[2] Trucos datawin
http://infolenguajes.galeon.com/datawin.htm
[3] http://kell-developer.blogspot.com/2009/09/cargar-una-tabla-un-dropdownlistbox-de.html
[4] List of Functions Available in Datawindow Expressions
http://pbbraindump.wordpress.com/2008/05/15/list-of-functions-available-in-datawindow-expressions/
[5] http://solocodigofuente.com/ejemplos-de-codigo-fuente-en-visual-basic-net/uso-del-control-dropdownlistbox-listbox-listview-de-power-builder/
[6] http://powerbuilder-undiaalavez.blogspot.com/2011_02_01_archive.html
http://ingpcastillo.com/personal/Manual/MANUAL_DE_POWER_BUILDER.pdf
http://sergioor.blogspot.com/2008/02/funciones-principales-de-un-datawindows.html
http://www.todoexpertos.com/categorias/tecnologia-e-internet/programacion/power-builder/respuestas/2317534/datawindows-avanzado
http://sergioor.blogspot.com/2008/02/funciones-principales-de-un-datawindows.html
http://es.scribd.com/doc/6878574/Powerbuilderuso-de-Cursores
http://groups.google.com/group/sybase.public.powerbuilder.database/browse_thread/thread/159c2bf7ef4f114e?pli=1
http://kell-developer.blogspot.com/2009/09/cargar-una-tabla-un-dropdownlistbox-de.html
Clear datawindow
long ll_i, ll_rc
ll_rc = dw_1.RowCount()
for ll_i = 1 to ll_rc
dw_1.deleterow(1)
next
dw_1.AcceptText()
dw_1.Update(True, True)
--or--
dw_1.Reset() //will never delete the rows from DB, It will just clear the datawindow buffers.
Work with dates
========================================================
dt_today = today()
li_maand = month(dt_today )
li_jaar = year(dt_today )
li_dag = day(dt_today )
apply filter
========================================================
ls_filtro = "columna1 > 100 and columna2 > 30"
dw_1.SetFilter(ls_filtro)
dw_1.Filter( )
references
[0] http://powerbuilder-undiaalavez.blogspot.com/
[1] Tutorial Power Builder 9.0 http://edyovando.galeon.com/INICIO.HTML
[2] Trucos datawin
http://infolenguajes.galeon.com/datawin.htm
[3] http://kell-developer.blogspot.com/2009/09/cargar-una-tabla-un-dropdownlistbox-de.html
[4] List of Functions Available in Datawindow Expressions
http://pbbraindump.wordpress.com/2008/05/15/list-of-functions-available-in-datawindow-expressions/
[5] http://solocodigofuente.com/ejemplos-de-codigo-fuente-en-visual-basic-net/uso-del-control-dropdownlistbox-listbox-listview-de-power-builder/
[6] http://powerbuilder-undiaalavez.blogspot.com/2011_02_01_archive.html
http://ingpcastillo.com/personal/Manual/MANUAL_DE_POWER_BUILDER.pdf
http://sergioor.blogspot.com/2008/02/funciones-principales-de-un-datawindows.html
http://www.todoexpertos.com/categorias/tecnologia-e-internet/programacion/power-builder/respuestas/2317534/datawindows-avanzado
http://sergioor.blogspot.com/2008/02/funciones-principales-de-un-datawindows.html
http://es.scribd.com/doc/6878574/Powerbuilderuso-de-Cursores
http://groups.google.com/group/sybase.public.powerbuilder.database/browse_thread/thread/159c2bf7ef4f114e?pli=1
Friday, August 05, 2011
SQL Server::Collation
SQL Server::Identificar versión y edición
Cómo determinar la versión de SQL Server
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
SELECT @@VERSION
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
SELECT @@VERSION
Friday, July 22, 2011
Wednesday, July 20, 2011
Obtener operador al cual pertenece el número telefónico (fijo)
Obtener operador al cual pertenece el número telefónico (fijo)
Lima
http://www.mtc.gob.pe/portal/comunicacion/concesion/registros/numeracion/fija/lima.pdf
Provincias
http://www.mtc.gob.pe/portal/comunicacion/concesion/registros/numeracion/fija/prov.pdf
Obtener cantidad de numeros por DNI (Claro moviles)
http://www.claro.com.pe/wps/portal/pe/pc/hogar/movil/prepago
Lima
http://www.mtc.gob.pe/portal/comunicacion/concesion/registros/numeracion/fija/lima.pdf
Provincias
http://www.mtc.gob.pe/portal/comunicacion/concesion/registros/numeracion/fija/prov.pdf
Obtener cantidad de numeros por DNI (Claro moviles)
http://www.claro.com.pe/wps/portal/pe/pc/hogar/movil/prepago
Saturday, July 16, 2011
Wednesday, July 13, 2011
php photo gallery::without database
http://phpgraphy.sourceforge.net/
http://www.sgal.org/
http://sourceforge.net/projects/ifoto/
http://yapig.sourceforge.net/
http://qdig.sourceforge.net/
http://www.sgal.org/
http://sourceforge.net/projects/ifoto/
http://yapig.sourceforge.net/
http://qdig.sourceforge.net/
Subscribe to:
Posts (Atom)
-
Resources: [1] Hela https://ome.grc.nia.nih.gov/iicbu2008/hela/index.html
-
Sunedu Renacyt 1) https://ctivitae.concytec.gob.pe/appDirectorioCTI/ 2) http://regina.concytec.gob.pe 3) https://www.gob.pe/9648-ser-p...
-
en inglés se llama “A potentially dangerous Request.Form value was detected from the client”. varias páginas indican dos cosas: 1. agrega...
Running apps
Runtastic (I uninstalled because force to update your device - Internet connection problems) Runkeeper (Wrong GPS tracking) Strava (Curr...