Erwin Fransiscus's Blog

Android: How To Backup Your App to Your Media Card for Non Rooted Phone

Posted by: Erwin Fransiscus on: October 30, 2011

image

Hello, simply said, backup apps in your non-rooted android is easy.
Thats true. It is easy.
If u do wipe phone or reset to factory setting.
Eventhough the application saved data does not backed up, at least the application .apk is backed up so u don’t have to redownload all application you have previously.

First, before u do wipe, download “Astro File Manager” from Android Market. It is free.

Install it.

When you open Astro File Manager for the first time, there will be splash screen (pop up window) for you to choose which features you want to use.

Select Application Backup.

At this window you should choose application you want to backup.
You can also select all application too.
After you check (choose) the app(s), just press the backup button and it will start working on backup your app(s).

Easy? True.

To restore your apps after you wipe the device, you have to install the Astro File Manager first. There’s two way.
First, you can open default file manager, open sdcard, select backup/apps/, and find ‘com.metago.astro’ and install it. If there’s pop up about cannot install, select first button on the left, and tick the ‘Unknown Sources’. After that, you can try install it again.
Second, download and install it from Android Market.

After that, when you open Astro File Manager, there will be splash screen (pop up window) for you to choose which features you want to use. Select ‘Application Backup’, and the ‘Backup’ tab.

You should know what to do from here, just like before, select apps you want to restore, and after selection you just need to press ‘Restore’ button.

Hope it useful for you.

p.s. There’s also a way to access the Application Backup feature from insidr of Astro. Just press Menu>Tools>Application Backup

List of Radio Station All Over Indonesia

Posted by: Erwin Fransiscus on: February 23, 2011

>> Bandung
Rase FM Bandung (102.3 FM) [1]
Radio Paramuda Bandung (93.7 FM)
Radio Ardan Bandung (105.9 FM)
KLCBS (100.4 FM) [2]
Oz Radio Bandung (103.1 FM) [3]
99ers Radio Bandung (100 FM) [4]
Buzz FM (89.7 FM) [5]
Maestro FM (92.5 FM)
B Radio (95.6 FM)
Radio Maraghita (FM 106.7)
MQ FM (102.7 FM) [6]
K-Lite FM (107.1 FM)
Radio Global–Radio Elshinta relay station (89.3 FM)
GRG Radio (100.8 FM) Majalaya
Swa[ra]dio (107.9 FM) Jatinangor
Hard Rock FM Bandung (87.7 FM) [7]
Prambors Radio Bandung (98.4 FM) [8]
Pop FM Bandung (106.3 FM)
U-FM Bandung (104.3 FM)
Radio Dangdut TPI Bandung (99.6 FM) Cimahi

>>> Batam
BiGS104.7FM
100.7 BATAM FM
ZOO FM 101.5

>>> Bintan
Radio Club FM (103.9 FM) Tanjung Pinang – Kepri [9]

>>> Bogor
Radio Komunitas Agri FM 107,9 Mhz [10]

>>> Balikpapan
Radio SBI 102,1 Mhz

>>> Berastagi
GUNDALING FM 95.7

>>> Gorontalo
SeLeBes (101 FM)
SKFM (99,1 FM
SMeK (95,5 FM)
DMQFM (87,6 FM) Aktif April 2006

>>> Jakarta
Hardrock FM: 87.6 MHz [11]
Mustang FM: 88.00 MHz [12]
Arief Rahman Hakim (ARH-Global Radio): 88.40 MHz
RRI Jakarta Pro 3: 88.80 MHz [13]
Metro Jaya Kartika (Radio 68H): 89.20 MHz [14]
I-Radio: 89.60 MHz [15]
Elshinta: 90.00 MHz [16]
Cosmopolitan FM: 90.40 MHz [17]
Suara Gema Pembangunan Utama (SP FM): 90.80 MHz
RRI Jakarta Pro 1: 91.20 MHz [18]
Indika Milenia (Indika FM): 91.60 MHz [19]
Radio Sonora: 92.00 MHz [20]
PASS FM: 92.40 MHz
RRI Jakarta Pro 4: 92.80 MHz [21]
Sentra Komedi: 93.20 MHz
Gaya: 93.60 MHz
Mercy FM: 93.90 MHz
Garda Asia Bumi (Woman Radio): 94.30 MHz
U FM (Agustina Yunior): 94.70 MHz [22]
KIS FM: 95.10 MHz [23]
Asy Syafiiyah (RAS FM): 95.50 MHz
Smart FM: 95.90 MHz [24]
Radio Pelita Kasih (RPK FM): 96.30 MHz [25]
Swara Rhadana Dunia (Radio A): 96.70 MHz [26]
Radio Dangdut-TPI: 97.10 MHz
AutoMotion Radio: 97.50 MHz
Radio Kayumanis: 97.90 MHz [27]
Cakrawala Gita Swara: 98.30 MHz
Attahiriyah (ER Radio): 98.70 MHz
Delta FM: 99.10 MHz [28]
Female Radio: 99.50 MHz [29]
Classical, News and Jazz (CNJ Radio): 99.90 MHz [30]
Radio El-Gangga: 100.30 MHz
Heartline FM: 100.60 MHz [31]
Radio One: 101.00 MHz [32]
Trax FM: 101.40 MHz [33]
Bahana: 101.80 MHz
Prambors: 102.20 MHz [34]
Camajaya Surya Nada (Radio Camajaya): 102.60 MHz
Ria Pop FM: 103.00 MHz
Taman Mini (T Radio): 103.40 MHz
Pesona Gita Anindita (Pesona FM): 103.80 MHz
MS Tri FM: 104.20 MHz
Trijaya FM: 104.60 MHz [35]
RRI Jakarta Pro 2 (Pro 2 FM): 105.00 MHz [36]
Niaga Chakti Bhudi Bhakti (CBB): 105.40 MHz
Ramako FM: 105.80 MHz [37]
Bens Radio: 106.20 MHz
Sabda Sosok Sohor (Radio Muara): 106.60 MHz
Radio Dakta: 107.00 MHz
Star FM: 107.30 MHz
Music City (MC): 107.50 MHz
Suara Metro (Polda Metro Jaya): 107.80 FM

>>> Malang
Radio MAS FM 104,5 [38]
Kalimaya Baskara FM
Andalus FM
Cakra Buwana FM
KDS 8 FM
M-FM
Pionir FM
Senaputra
TT 77
Gita FM
Puspita FM

>>> Medan
La Femme FM 88
Satya Bhakti FM 88.4
RRI Pro 3 FM 88.8
Pasopati FM 89.2
Visi FM 89.60
Q FM 90
Teladan FM 90.4
Mix FM 90.8
Umsu FM 91.60
RRI Pro 2 FM 92.4
Lite FM 92.8
Radio Elshinta FM 93.2
RRI Pro 1 FM 94.3
Suara Medan FM 94.7
Prapanca FM 95.1
Citra Buana FM 95.50
City Radio FM 95.9
Rodhesa FM 96.3
Radio Dangdut TPI FM 96.7
Sikamoni FM 97.1
Prambors FM 97.5
Narwastu FM 97.9
Kosa FM 98.3
Most FM 99.1
Istana FM 99.9
Binuang FM 101
Roris FM 101.4
Mesra FM 101.8
Bonsita FM 102.2
Alnora FM 102.6
Ditra Nuansa FM 103
Simfoni FM 103.4
Gita FM 103.8
Mitra FM 104.2
Star FM 104.6
Kiss FM 105
Delta FM 105.8
Kardopa FM 106.2
Sonya FM 106.6
Lips Radio FM 107.3
sumber: mdwpro

>>> Pangkalpinang
El John FM 96,8 FM
Live FM 90,8 FM
Radio SONORA Bangka 101,1 FM
Radio Prima 105,9 FM
Radio Palupi 96,8 FM

>>> Pati
Pesantenan FM 95.90 Mhz
Pas FM 101.00 Mhz
Pragola FM 94.30 Mhz
Pop FM 90.80 Mhz
Boswin FM 99.90 Mhz ???
Harbos FM 102.60 Mhz
Jalesveva FM Juwana 87.60 Mhz

>>> Pematang Siantar
Cas FM 89.4
Mora FM 96.1
Cek FM 101.2
RBS FM 102
Boss FM 102.8

>>> Kudus
Manggala FM 100.40 Mhz
Muria AM 1440 Khz
Suara Kudus FM (RSPD) 88.00 Mhz
Pop kudus FM 93.70 Mhz
Gelora FM 107.10 Mhz
Pamira FM 93.00 Mhz
RTK FM 106.30 Mhz ??
UMK Radio FM 94.6 Mhz

>>> Pekanbaru
Cendana FM 102,6 MHz ( El John Group )
Soreram 1044 AM
IKMI FM 90,8 Mhz (Radio Suara Ikatan Mesjid Indonesia)

>>> Inhil
Gemilang FM
Kilas FM
Senada

>>> Ponorogo
Romansa FM
GOONG FM
Radio Gema Surya
Radio Duta Nusantara
Gress FM
AVIDA FM
Suara Gontor FM

>>> Purwokerto
Dian Swara FM: 98.2 Mhz
RGM FM
RRI Pro 2 FM: 99.0 Mhz
Cipta Muda Binangkit FM: 99.8 Mhz
Paduka Dirgantara FM: 100.6 Mhz
Swara Mitra Nusantara FM: 104.9 Mhz
Gema Mahasiswa UNSUD FM: 105.7 Mhz
Tara Valaria FM: 106.5 Mhz
RRI Pro 3 FM: 107.3 Mhz

>>> Salatiga
Pesona FM : 88.40 MHz
Swara Salatiga FM : 106.60 Mhz
ZENIT FM : 97.20 MHz

>>> Semarang
RRI Pro-1 FM: 89.0 Mhz
TOP FM: 89.4 Mhz
TRAX FM Semarang: 90.2 Mhz
RRI Pro-2 FM: 90.6 Mhz
Elshinta FM: 91.0 Mhz
Smart FM: 93.4 Mhz
Female FM: 96.1 Mhz
Suara Semarang FM: 96.9 Mhz
Pro Alma FM: 97.7 Mhz
Merci FM: 98.9 Mhz
Radiks FM: 99.3 Mhz
RCTFM: 101.2 Mhz
IBC FM: 101.6 Mhz
Prambors FM: 102.0 Mhz [39]
GajahMada FM: 102.4 Mhz
Jatayu FM: 102.8 Mhz
Kis FM: 103.2 Mhz
IMELDA: 104.4 Mhz
Sesanti Suarasakti FM: 105.2 Mhz
Rasika FM: 105.6 Mhz
Pass FM: 106 Mhz
Rasika FM: 105.6 Mhz
Borobudur
Lusiana
Kalimasada
DJ FM 94.80 Mhz [djfm.co.id]
Colors FM 87.70 Mhz
Delta FM 96.80 Mhz
Suara Surabaya FM 100.00 Mhz [40]
Kosmonita FM 92.50 Mhz
Global FM 90.90 Mhz
Wijaya FM 103.30 Mhz
Smart FM 88.90 Mhz
Hard Rock FM 89.70 Mhz
Mercury FM 96.00 Mhz
Metro Female FM 88.30 Mhz
COP FM 104.00 Mhz
EBS FM 105.9 Mhz
Sonora Surabaya FM 98,0 Mhz [41]

>>> Surakarta (SOLO)
Prambors Radio 99.2 MHz [42]
Solo Radio FM (Ardan Group)
PTPN Rasitania FM
SAS FM
PAS FM
GSM FM
Suara Slenk FM
MQ FM
Hizbullah FM
Imanuel FM
JPI FM
Pro1 FM
Pro2 FM
Swara Graha FM
Suara Karavan FM
Mentari FM
Ria FM Female Radio
Kharisma FM
Metta FM
Solopos FM
Suara Bening Ati FM
UMS FM
UNS FM
Unisri FM
Ramakusala FM
Radio Komunitas Global Etnik STSI FM

>>> Yogyakarta
Arma Sebelas FM 87.9 MHz
Q Radio FM 88.3 MHz
I Radio FM 88.7 MHz
Fantasy FM 89.1 MHz
Rasia Lima FM 89.5 MHz [43]
Sasando FM 90.3 MHz
PTDI Medari FM 90.7 MHz
RRI Pro 1 FM 91.1 MHz
Budaya Swara Yogya FM 91.9 MHz
Swa FM 92.3 MHz
MBS FM 92.7 MHz [44]
Swara Argo Sosro FM 93.2 MHz
Rama FM 93.5 MHz
Adhikarta FM 93.8 MHz
Radio Persatuan Bantul FM 94.2 MHz
Kotaperak FM 94.6 MHz
Masdha FM 95.0 MHz
Yashika FM 95.4 MHz
Prambors FM 95.8 MHz [45]
Ista FM 96.2 MHz
Trijaya FM 97.0 MHz [46]
Sonora FM 97.4 MHz [47]
EMC FM 97.8 MHz
Pop FM Yogya FM 98.2 MHz
GCD FM 98.6 MHz
Vedac FM 99.0 MHz
Retjo Buntung FM 99.4 MHz [48]
Swara Adhiloka FM 99.9 MHz
Prima FM 100.2 MHz
Andalan Muda FM 100.5 MHz
Channel 5 FM 100.9 MHz
Star FM 101.3 MHz
Swaragama FM 101.7 MHz [49]
Eltira FM 102.1 MHz [50]
RRI Pro 2 FM 102.5 MHz
RRI Pro 3 FM 102.9 MHz
FeMale Radio FM 103.7 MHz
Ardhia FM 104.1 MHz
Unisi FM 104.5 MHz
Rakosa FeMale Radio FM 105.3 MHz [51]
Petra FM 105.7 MHz
Geronimo FM 106.1 MHz [52]
UTY FM 106.9 MHz
Suara Indrakila FM 107.2 MHz
Global FM 107.6 MHz
Parangtritis FM 100.00 MHz

>>> Indramayu
KC-10 87.9 FM

>>> Cimahi
AR 92.9 FM

Nokia Will Use Windows Phone 7 to Beat Android

Posted by: Erwin Fransiscus on: February 17, 2011

Well, as some of us may know, Nokia will use Windows Phone 7 for its smartphones. That’s a good step, I think, eventhough also use Android maybe could boost up Nokia’s marketshare just like old times. However, the competition of Android, Apple iOS, and Windows Phone 7 seems to be fun with Nokia’s participation, at least, us, as customer, could choose more variety of smartphone based on our needs and what we want.

Hope Nokia sales could be better by using Windows Phone, eventhough I don’t really think it will beat Android’s and Apple iOS immediately, well, maybe later, but really not in a short time.

Site to find the .apk games and application (cracked) for android

Posted by: Erwin Fransiscus on: February 15, 2011

you can try :

http://www.appplanet.com/

or

http://www.blapkmarket.com/

Hope you find good .apk :)

Hide Windows Partition

Posted by: Erwin Fransiscus on: January 27, 2010

Sometimes when we need to hide some file/files to others, we usually don’t put it in the hard drive instead we just put it to other removable drive like flash player or burn it to CD, but what if we need to hide the whole partition like a whooping 80GB drive partition? No problem, you can still hide that by not using your flash player or your CDs but by using the traditional “cmd” Command Prompt.

Here’s how:

1. First open Command Prompt (Start>Run>Type “cmd” without the quotes)

2. On the flushing cursor type “diskpart” (again without the quotes) Note: Wait for the Diskpart> and the flushing cursor to appear, usually it takes 5 seconds.

3. After the Diskpart> appears, type “list volume” (no quotes ok). It will then show all the drive in your computer including optical drives.

4. Select the drive you like to hide, for example using my system configuration, I want to hide drive d: then I’ll just type “select volume 3” (excluding the quotes). This varies depending on your system configuration.

5. After that, type “remove letter D” (again without the quotes). Then exit command prompt.

Your drive now is hidden, don’t worry its not been deleted of formatted, we just hide it. So if you want to see your drive again just follow the following.

To unhide the partition, repeat the steps 1-4 and on step 5 type “assign drive D” (ok again without the quote).

That’s all; your drive now is not hidden

Cari Uang Lewat Internet : Bisnis 5 Miliar

Posted by: Erwin Fransiscus on: August 24, 2009

Siapa yang tidak perlu uang? Saya rasa semua orang perlu uang dengan bermacam tujuan. Uang bisa dicari dengan cara susah, bisa juga dengan gampang, itu sangat relatif, tergantung apa dan bagaimana usaha kita.

Ketika mendengar “Bisnis 5 Milyar” jangan sekali-kali kita tergiur dengan judul programnya yang bombastis/muluk-muluk, atau menuduhnya tidak masuk akal atau penipuan. Kita telusuri dan pelajari dulu sistemnya dengan perlahan dan teliti. Jadi, tidak perlu buru-buru menghakimi bisnis ini!

“Bisnis 5 Milyar” merupakan sebuah judul/tajuk program yang dipakai untuk menarik minat orang atau pangsa pasar atau target untuk ikut bergabung dan menjalankan sistemnya. Namun jika sistem itu dijalankan dengan benar, maka kemungkinan 5 Milyar bisa masuk ke rekening kita. Hal ini tergantung kemampuan setiap orang untuk menjalankan usaha dan sistem ini. Jadi bisnis ini bukan ongkang-ongkang kaki, menunggu uang jatuh dari langit. Perlu ketekunan, keluasan jaringan, kemampuan melobi, kemampuan humas, kemampuan presentasi dan beragumentasi.

“Bisnis 5 Milyar” banyak dicaci maki orang. Namun lebih banyak lagi digandrungi orang. Memang selalu akan muncul pro dan kontra terhadap setiap usaha yang kita jalankan. Tentu juga ada resiko dan konsekuensi yang harus dihadapi dengan kesadaran penuh. Itulah yang namanya memutuskan sebuah pilihan. Dalam setiap bisnis apa pun selalu berlaku hukum untung-rugi. Dan saya rasa setiap pelaku bisnis telah sadar sepenuh hati dengan segala resiko yang mesti ditanggung jika bisnisnya bangkrut, sekecil apa pun resiko itu.

Saya telah mengikuti bisnis ini. Dan setelah itu saya mencari data-data bisnis ini di Google. Dan memang banyak pro dan kontra yang saya dapatkan. Ada yang bilang bisnis ini penipuan, tidak masuk akal, tidak halal, kaya di atas derita orang lain, dsb-nya. Namun ada juga yang membela bisnis ini sebagai suatu yang bermanfaat dan banyak orang telah membuktikan kebenarannya, termasuk saya pribadi.

Bisnis ini memang menjadi tidak masuk akal jika kita hanya terpaku pada kata “5 Milyar”. Tapi, akan masuk akal dan menguntungkan (seberapa pun besar untungnya) jika kita mengabaikan atau melupakan kata iklan “5 Milyar” itu.

Hanya dengan modal Rp.180 ribu, kita sudah dapat produk yang bermanfaat berupa sejumlah buku elektronik yang bisa diunduh di web bisnis ini. Jadi anggap saja kita membeli sejumlah buku, dan wawasan kita jadi bertambah jika kita mau membacanya.

Kalau mau balik modal dan sedikit untung, kita cukup mencari dan mengajak 4 orang member untuk bergabung di bisnis ini. Jika 4 member kita juga mencari masing-masing 4 member dengan motivasi agar bisa balik modal, dan begitu seterusnya sampai Level ke-5, maka kita sebagai Level ke-1 sudah bisa menikmati uang yang masuk ke rekening kita sekitar Rp 50 juta lebih.

Uang lumayan besar tsb bisa kita peroleh dalam hitungan minggu atau bulan. Tergantung keuletan dan ketekunan serta kesabaran kita mempromosikan program ini ke siapa saja yang kita kenal atau pun tidak kita kenal. Kita bisa menggunakan banyak cara untuk melakukan promosi baik di internet ataupun di dunia nyata. Bisa lewat milis, iklan-iklan gratis, web/blog pribadi, sms, brosur, dan cara lain yang memungkinkan.

Jadi, hanya dengan modal Rp.180 ribu, berdasarkan hitungan 4 member tadi, modal kita sudah balik, dan kita pun bersiap-siap jadi jutawan! Tidak perlu muluk-muluk jadi milyader dulu. Namun, kalau mau benar-benar ingin jadi milyader, maka silakan coba cari 10 member atau lebih. Data dan hitung-hitungan lebih lengkap bisa dibaca di sini: http://www.program5milyar.com/?id=efransiscus

Untuk hemat waktu, silakan copy paste atau save as semua halaman dan data di web di atas. Setelah itu pelajari baik-baik dan teliti tanpa cemas pulsa internet tersedot banyak. Setelah itu, keputusan ada pada diri sendiri!

Ketika diminta mentransfer uang sebesar Rp.180 ribu, jangan takut seluruh dana di rekening amblas dibajak orang. Toh, program ini TIDAK meminta nomer PIN, hanya nomer Rekening saja! Bisnis ini tidak pakai sistem hipnotis. Yang diperlukan adalah kesadaran dan kemauan.

Atau kalau masih ragu dan cemas uang amblas, silakan buat rekening baru untuk bisnis ini dan isilah saldo awal secukupnya saja. Kalau bisnis ini dijalankan dengan benar, maka rekening kita akan penuh dengan uang Rp.50 ribu dan Rp.10 ribu, kiriman dari member lain di bawah kita.

Bisnis ini memang menganut sistem MLM, namun jelas masuk akal. Dan kita tidak perlu jadi “sales”, jualan kosmetik, sabun, kopi, herbal, dll sambil mulut berbusa-busa menjelaskan sistem MLM di dunia nyata, yang tujuannya sama: jualan produk dan cari member.

Di program “Bisnis 5 Milyar” kita cukup bermain di dunia maya lewat email, web/blog, face book, fs, dll-nya. Jadi luangkan waktu setiap hari selama satu jam aja di internet, lakukan promosi secara kontinyu dengan web replika yang kita dapat setelah bergabung di bisnis ini. Tentu ada banyak trik dan tips untuk melakukan promosi. Cara itu bisa ditemukan sendiri seiring pengalaman, atau berdiskusi dengan member yang sudah sukses.

Bisnis model begini sangat banyak di dunia maya (internet), baik berasal dari dalam negeri maupun luar negeri. Namun tentu tidak ada salahnya mempelajari dan mencoba yang satu ini. Silakan KLIK di:

http://www.program5milyar.com/?id=efransiscus

INGAT: Pelajari dulu baik-baik sistemnya. Selamat mencoba! Dan mari berdoa sama-sama: Semoga Sukses!!!

Tutorial : Using MySQL ODBC Connector with Foxpro 9 and MySQL

Posted by: Erwin Fransiscus on: March 15, 2009

Yesterday, I got a project to handle with MySQL and Visual Foxpro. I’m used to MySQL, and so does with Visual Foxpro. The trouble is that I’ve never work on both of them in the same time. Usually I’m using Foxpro integrated DBMS when using Visual Foxpro, and MySQL used to be a DBMS when I’m using PHP, C#, or ASP.Net.
I got a little problem on connecting those software, but after multiple tries, it did works.
How that happen? here’s the simple tutorial:

Note : I’m using Microsoft Windows XP SP 3, Visual Foxpro 9, and WAMP server 1.7.3, I’m working on a single desktop pc. I’m sorry i didn’t include the images example on doing this, hope with just the texts you would understand how it works.

First, create a database on MySQL. The database is quite important, because when you install and configure ODBC, there’s an option of which databases you want to use. I’m also using PHPmyadmin for the GUI of the database application. here’s for example.

> CREATE DATABASE dbfarmasi
> CREATE TABLE `dbfarmasi`.`tb_brg` (`kdbrg` CHAR( 6 ) NOT NULL ,`nmbrg` VARCHAR( 50 ) NOT NULL , PRIMARY KEY ( `kdbrg` )) ENGINE = INNODB
> INSERT INTO `dbfarmasi`.`tb_brg` (`kdbrg` ,`nmbrg`) VALUES ( ’00001′, ‘First item’ );
> INSERT INTO `dbfarmasi`.`tb_brg` (`kdbrg` ,`nmbrg`) VALUES ( ’00002′, ‘Second item’ );

i’m named the database “dbfarmasi” and the table “tb_brg”. So here, we got a database and a table, rock!

Then you download a software called MySQL ODBC Connector. I’m using mysql-connector-odbc-3.51.25-win32.exe, which is free, and can be downloaded by visit mysql site. You can try to google it.

Install. After installation has done, you should go to “Control Panel” > “Administrative Tools” > “Data Sources (ODBC)”. And then there’s pop-up window of ODBC. In “User DSN” tab, right side, press “Add” button”, and select “MySQL ODBC 3.51 Driver” as the data source, and “Finish”.

Another windows will appear, it is a configuration window for ODBC. Try this :

Data source name : koneksi
Description : connect foxpro and mysql
Server : localhost
User : root
Database : dbfarmasi

The DSN name is up to you, so does the description.
The default Server is localhost, ’cause I’m not using remote database.
Default user name is root, as the first super user name in mysql.
I’m using no password on mysql (it is set to none by default when you’re install WAMP)
and the database I’m using is dbfarmasi, as i’ve created before.

Ta-da. The connection has been made.

Now, for the visual foxpro. here is a simple one :
Create a project, whatever the name is, save it. on “Project Manager” window, choose “Code” tab.
Press “New” on Program.
Here is the code:

PUBLIC P1
STORE SQLCONNECT(‘koneksi’, ‘root’) TO P1

close and save it to name :  ”setdatabase

now, back to “Project Manager” window, choose “Document” tab, press “New” button to create a new form, and pick the “New Form”, not the “Form Wizard” thing.
After that, an empty form will appear. create a two Textboxs.
named the first textbox to : txtkdbrg and the second textbox to : txtnmbrg.
Add a grid to form. named it as gridContainer. 

Now double-click the form,  select the object form1 and the procedure init, and add this code:

DO setdatabase
thisform.gridContainer.RecordSource=”"
SQLEXEC(P1,”select * from tb_brg”,”tb_brg”)
IF NOT USED(“tb_brg”)
USE tb_brg ALIAS tb_brg
ENDIF 
SELECT tb_brg
thisform.gridContainer.RecordSource=”tb_brg”

Save the form and run it. TA-DA. It works, its connected. The content of table “tb_brg” is showed by the form by the gridContainer.

It means that the ODBC works. Here the connection thing :
do setdatabase
SQLEXEC(P1,”select * from tb_brg”,”tb_brg”)
means :
run program code “setdatabase” (which we’ve created before, for connection)
select P1 as ODBC connection DNS, (connection name variable in setdatabase (replace SQLCONNECT(bla bla bla))
“select * from tb_brg”, the sql query, select all from table tb_brg
“tb_brg”, is a cursor in visual foxpro, that used for alias.

So, with SQLEXEC([connection name],”[sql query]“,[cursor name]), you can do sql command: SELECT. Don’t forget to add cursorname/alias when you’re using SELECT.

You don’t have to add cursorname if you’re using INSERT or DELETE query.
example :

SQLEXEC(P1,”insert into tb_brg (kdbrg,nmbrg) values (‘”+thisform.txtkdbrg.value+”‘,’”+thisform.txtnmbrg.value+”‘)”)

means you insert value from textbox (txtkdbrg and txtnmbrg).
for delete command example :

SQLEXEC(P1,”delete from tb_brg where kdbrg =’”+thisform.txtkdbrg.Value+”‘”)

Once again, i’m sorry i’m not using images for this tutorial.
Hope you understand what i meant in this simple tutorial, and hope it help you.

Download Dota Ai+ 6.59b

Posted by: Erwin Fransiscus on: February 23, 2009

You’re waiting for Dota Ai+ 6.59b ?
I found this link for map download..
Just try it.. good luck

download here

Download Google Chrome Full

Posted by: Erwin Fransiscus on: February 23, 2009

If you want to download Google’s new web browser “Chrome”, you’ll need to download a small 474 KB installer from its official website and then it’ll download the required files of approx. 7 MB from Google server.

Its annoying and painful when you want to install Chrome in more than one computer. You’ll have to download the required setup files in each system.

Now no need to worry, Google is providing a standalone installer which doesn’t require net connection while installing the browser. So you can download it once and then install it in as many systems as you want without any problem.

Download Full Standalone Offline Installer for Latest Google Chrome

http://dl.google.com/chrome/install/154.36/chrome_installer.exe

There is also another benefit in downloading this standalone installer. It doesn’t contain the Google Update EXE file.

Dota Ai+ 6.58b Revision 1 Download

Posted by: Erwin Fransiscus on: February 6, 2009

Hi pal, I got the map yesterday, and now want to share… just download it here

Download

Don’t forget to share this blog’s post or URL to your friends, ok ?

Efransiscus blog

welcome to my blog. hope you like what I wrote :)

Efransiscus Blog Stats

  • 40,847 hits

 

January 2012
M T W T F S S
« Oct    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Archives

My Twitter

Follow

Get every new post delivered to your Inbox.