tag:blogger.com,1999:blog-5312323737638682362026-08-09T15:08:56.088+07:00How to operating computerEverything concerning daily activity on operating computerChoirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.comBlogger135125tag:blogger.com,1999:blog-531232373763868236.post-17213237945249982812014-10-31T08:27:00.002+07:002014-10-31T08:27:27.284+07:00How to implode array in delphi
As in the previous post how to explode some string in delphi, we can also make the reverse, it is implode. In delphi we can make implode function as in php.
Below is the function:
//////////////////////////////////////////////////////////////////////////
// Procedure - implode
// Author - Ronald Buster
// Remarc - PHP like implode function
//
// Returns a string containing a string Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-11692481838898485012014-09-26T08:39:00.000+07:002014-10-08T09:27:30.909+07:00How to explode some string in delphi
How to explode some string in delphi
In delphi, you can make a function explode as in php, copy the code below to do that :
function explode(const separator, s: string; limit: Integer = 0): TDynStringArray;
var
SepLen: Integer;
F, P: PChar;
begin
SetLength(Result, 0);
if (S = '') or (Limit < 0) then
Exit;
if Separator = '' then
begin
SetLength(Result, 1);
Result[Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-82718836164567370932014-09-25T08:34:00.000+07:002014-10-08T08:35:17.358+07:00How to remove line breaks in delphi
How to remove line breaks from text in Delphi?
You can use stringreplace function.
function StringReplace (const SourceString, OldPattern, NewPattern : string; Flags : TReplaceFlags) : string;
The StringReplace function replaces the first or all occurences of a substring OldPattern in SourceString with NewPattern according to Flags settings. The changed string is returned.
Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-27433355300068586312014-09-24T08:28:00.000+07:002014-10-08T08:29:22.799+07:00How to load sql file to ado command
Here is script to load sql file to adocommand at runtime.
var
f:TFileStream;
s:string;
begin
f:=TFileStream.Create('sql_commands.sql',fmOpenRead);
try
SetLength(s,f.Size);
f.Read(s[1],f.Size);
finally
f.Free;
end;
ADOCommand1.CommandText:=s;
Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-59392238283721359982014-09-23T15:08:00.000+07:002014-09-23T15:08:04.725+07:00How to set SQL Server Database Option
Dear Reader,...
Sometimes we need to set SQL Server database option because there is error related on it based on purpose. In this article, we will discuss about how to SQL Server Database Option.
For the first time, you need to query the options of database as below
SELECT
database_id,
name,
is_ansi_nulls_on,
is_ansi_padding_on,
is_ansi_warnings_on,
is_arithabort_on,Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-55288798938463579392014-08-14T17:50:00.000+07:002016-03-21T17:31:41.403+07:00How to create local repositoy RHEL 6
As in the post How to create local repositoy SLES 10 we also can do the same thing on RHEL (Redhat Enterprise Linux) 6 using yum. Here are the steps :
Install the createrepo package:
Copy all of the packages into one directory, such as /home/choirul/local_repo/
Run the createrepo --database command on that directory:
createrepo --database /home/choirul/local_repo
Create a new file in /Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-30041097095802808822014-08-13T11:23:00.000+07:002014-08-13T11:27:04.404+07:00How to query data with date in mssql
It come from simple question. what is the syntax for query data with date/time filter in ms access?.
Here we will show you how to do that. It simply using query like example below :
SELECT SNo
FROM Staff
WHERE Format([ComplaintDate],"yyyy-mm-dd")>='2014-08-10'
Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-35494850426627623462014-03-19T13:43:00.000+07:002014-03-19T13:43:00.069+07:00How to create database link in oracle
What is database link?
A database link is a schema object in one database that
enables you to access objects on another database. The other database
need not be an Oracle Database system.
How to create a database link in
Oracle?
To create database link you must specify the database link name, the remote user to
connect to, the password for the remote user and the TNS serviceChoirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-79879023256216153782014-03-18T11:09:00.001+07:002014-03-18T11:12:21.721+07:00How to set ORACLE_HOME in Windows Environment Variable
What is ORACLE_HOME used for?
The ORACLE_HOME is an environment variable which is used to set and define the path of Oracle Home (server) Directory.
What is ORACLE_BASE used for?
* The ORACLE_BASE is also an environment variable to
define the base/root level directory where you will have the Oracle
Database directory tree - ORACLE_HOME defined under the ORACLE_BASE
directory.
HowChoirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com386tag:blogger.com,1999:blog-531232373763868236.post-48004519045450935572014-02-18T14:59:00.000+07:002014-08-13T09:15:03.984+07:00How to resolve error TNS:listener does not currently know of service requested in connect descriptor
This time we would like to look at one of problem in oracle, especially “ORA-12514: TNS:listener does not currently know of
service requested in connect descriptor”.
The vast majority of the time, this error results from an incorrectly
specified connect descriptor in the tnsnames.ora file. Let’s look at a
very typical example then diagnose and fix it. After that we will dig
in to how the Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-79995501792369612862014-02-06T09:03:00.002+07:002014-02-06T09:06:21.925+07:00How to extract files in linux
compressed files
In linux operating system, there are some kinds of compressed files. Here they are:
tar.bz2.
Below are the steps to extract .tar.bz2 file :
Open a terminal
type command "tar xvjf filename.tar.bz2"
tar.gz.
Below are the steps to extract .tar.gz file :
Open a terminal
type command "tar xvzf filename.tar.gz"
Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-35207561440737025972013-12-09T17:01:00.001+07:002013-12-09T17:01:06.053+07:00How to copy file between host using scp
How to copy file between host using scp
What is Secure Copy?
scp(Secure copy) allows files to be copied to, from, or between different hosts. It uses ssh for data transfer and provides the same authentication and same level of security as ssh.
Below are the example syntax of scp :
Copy the file "foobar.txt" from a remote host to the local host
$ scp your_username@Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-55469040306502603572013-12-08T11:05:00.000+07:002013-12-08T11:05:00.812+07:00How to X Forwarding with Putty
Unix machines have been able to run software on a remote machine and display the GUI locally.
Linux and Mac OS X support X Forwarding with no extra software.
Any terminal on Linux should do X Forwarding.
For Mac users need to run "Applications > Utilities > XTerm".
In a command line terminal run "ssh -Y user@server virtualbox" and you'll be running matlab on "server" but seeing it on your Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-67152888303093332252013-12-07T09:32:00.000+07:002013-12-07T09:32:00.618+07:00How to configure vnc server on linux
How to configure vnc server on linux
This post will discuss about How to configure vnc server on linux completely. For this experiment, we will user rhel (redhat enterprise linux) 6.
Here are the steps to configure vnc server on rhel :
Install tigervnc-server
# yum install tigervnc-server
Edit the "/etc/sysconfig/vncservers" file to configure the required displays. The Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-84851896025009580322013-12-06T08:31:00.003+07:002013-12-06T08:32:08.548+07:00How to reconfigure oracle dbconsole
How to reconfigure oracle dbconsole
If the IP address and/or hostname changes for a system running
Oracle, we need to reconfigure oracle dbconsole correctly.
This post will discuss about How to reconfigure oracle dbconsole :
drop oracle dbconsole repository
cd $ORACLE_HOME/bin
./emca -deconfig dbcontrol db -repos drop
recreate oracle dbconsole repository
./emca -config dbcontrolChoirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-15851434019311629582013-11-30T04:43:00.000+07:002013-11-30T04:45:05.276+07:00How to resolve too many declarations of 'TO_CHAR' match this call
Have you ever got message
"ORA-06550: line 3, column 9:PLS-00307: too many declarations of 'TO_CHAR' match this callORA-06550: line 3, column 2:PL/SQL: SQL Statement ignored" ?
If so, it is the right place for you :). This post will discuss about "How to resolve too many declarations of 'TO_CHAR' match this call" in oracle.
The problem is that your pl/sql is selecting something like '0' Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-27721878452566846832013-11-28T17:23:00.003+07:002013-11-28T17:23:41.649+07:00How to resolve can't mount backup path in android recovery
Sometimes, when we want to backup rom using CWM we get error message "can't mount backup path" in android recovery. This post will discuss about how to resolve can't mount backup path in android recovery.
To resolve error "can't mount backup path" in android recovery, do this steps below :
Enter in normal mode
Go to menu Setting > Storage > Erase SD Card
Shutdown your android and Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com2tag:blogger.com,1999:blog-531232373763868236.post-33849215983065078272013-11-18T16:58:00.000+07:002013-11-19T08:55:49.086+07:00How to upgrade evaluation version of windows server 2012
windows server 2012 standard
Most evaluation versions can be converted to full retail versions, but
the method varies slightly depending on the edition. This post will discuss about How to upgrade evaluation version of windows server 2012.
Before you attempt
to convert the version, verify that your server is actually running an
evaluation version. To do this, do either of the following:
Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com1tag:blogger.com,1999:blog-531232373763868236.post-9000803600515968592013-11-18T13:40:00.002+07:002013-11-18T14:05:55.361+07:00How to autoshutdown windows in spesific tiime
You can schedule task to shutdown at specific time, follow steps below to schedule autoshutdown task:
Go to Start > Control Panel > System and Security > Administrative Tools and click on the Task Scheduler.
From the Action menu in Task Scheduler, click "Create Basic Task..."
In the "Create Basic Task Wizard" windows that pops up, Type in a title and a description. Something basicChoirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-24414686197413278012013-11-14T06:28:00.000+07:002013-11-14T06:28:00.716+07:00How to use vlookup in excel
VLOOKUP is one of Excel most useful functions, and it’s also one of the least understood. In this article, we will discuss about how to use VLOOKUP in excel.
So what is VLOOKUP? Well, of course it’s an Excel function. This article will assume that the reader already has a passing understanding of Excel functions, and can use basic functions such as SUM, AVERAGE, and TODAY.Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-90210926840264746042013-11-13T11:55:00.000+07:002013-11-13T11:59:05.584+07:00How to replace string in power builder
In this post we will discuss about how to replace string in power builder using our custom routine. This routine works generically for any string.
For example, if old_str = "red" and new_str = "green", all occurrences of "red" inside of mystring will be replaced with "green".
Here is the script :
long ll_StartPos = 1
ll_StartPos = Pos(arg_str, arg_search, ll_StartPos)
DO WHILE Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-12559446679378387712013-11-12T10:29:00.003+07:002013-11-12T10:29:32.908+07:00How to create tablespace in oracle
There are some types of tablespace in oracle. This post will discuss about how to create tablespace in oracle using syntax.
Permanent Tablespace
create tablespace ts_test
logging
datafile '/datafiles/ts_test.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
Temporary Tablespace
create temporary tablespace temp_test
tempfile '/datafiles/temp_test.dbf'
size 32m
Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-89219313657978140182013-11-11T15:54:00.001+07:002013-11-11T15:54:28.302+07:00How to install .net framework 3.5 in windows server 2012
If you want to install .NET Framework 3.5 in windows server 2012, you will most likely see this error message when installing the feature:
“Do you want to specify an alternate source path? One or more installation selections are missing source files…”
To solve this, you can follow this steps :
Go to a command prompt and enter this:
dism /online /enable-feature /featurename:NetFX3 /all /Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-83714813356811578182013-11-09T10:34:00.000+07:002013-11-09T10:34:00.346+07:00How to show prompt dialog in delphi
In this post we will discuss about How to show prompt dialog in delphi that will ask user to input some string to be processed. In delphi we can use inputbox function.
The InputBox function displays a simple dialog box with the given Caption and Prompt message. It asks the user to enter data in a text box on the dialog. A Default value is displayed in the text box.
If the user presses OK, Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com0tag:blogger.com,1999:blog-531232373763868236.post-85712134178115232782013-11-08T08:50:00.000+07:002013-11-08T08:50:00.681+07:00How to Add Paging Widget For BloggerIn this post we will provide you tips to add page navigation for your blogger blog. Blogger default navigation shows only Older Posts and Newer Posts, many blogger want to change this into numbered page navigation.
In this post We will discuss step by step the guide of how to add paging widget to replace the blogger old navigation.
How to Add Paging Widget For Blogger
Follow the steps Choirul Ihwanhttp://www.blogger.com/profile/12032281672983779778noreply@blogger.com2