Re: Balasan: [Programmer-VB] Mo Tanya nih ?

Tue, 18 Jul 2006 01:25:12 -0700

An top draw programmer is one who can Visualize a complete Application, end to end, and equipped with the relevant skills, is able to lay down the steps and
processes for developing a complete application. Our aim with the "Application Series" of Books is to make this possible for you. We have sought to do this by imparting the skills in a capsule form, so that you will master a set of major concepts at a time, gain the expertise and become a Complete Programmer.
Each book of the series has a set of objectives. The title "Develop an Inventory Management Application using VB" sets out to teach how Object Oriented Programming can be used to drastically reduce code and optimize a Database Application. User Interface design which is based on OOPs enables code reuse and facilitates a compact design and set of forms and code, enabling you to handle large projects with minimal room for errors.

Madhav



Ade Aan Wirama <[EMAIL PROTECTED]> wrote:
Tipe replikasinya apa?
 
Idenya:
1. Tambahkan field baru misal fieldA dengan panjang yang diinginkan
2. Terus copy isi fieldB (field lama yang pendek) ke fieldA
3. Hapus fieldA
4. Create ulang fieldA
5. Copy balik fieldB ke fieldA
6. Hapus fieldB
 
Perintahnya:
exec sp_repladdcolumn @source_object = 'tableferr'
, @column = 'FieldB'
, @typetext = 'nvarchar(100) NULL'
, @publication_to_add = 'test'
 
update tableferr set FieldB = FieldA
 
exec sp_repldropcolumn @source_object = 'tableferr'
, @column = 'FieldA'
 
exec sp_repladdcolumn @source_object = 'tableferr'
, @column = 'FieldA'
, @typetext = 'nvarchar(100) NULL'
, @publication_to_add = 'test'
 
update tableferr set FieldA = FieldB
 
exec sp_repldropcolumn @source_object = 'tableferr'
, @column = 'FieldB'
 
Semoga membantu

Ferrr_xls <[EMAIL PROTECTED]> menulis:
Mao Tanya biasa tidak gimana caranya kalau kita mao ubah panjang field yang ada di SQL 2000
Yang sudah di sambung di buatkan replikasi ke antar cabang ? tanpa putusin replikasinya ?
Saya punya server di jakarta yang di replikasi di tangerang
Tolong ya please ! kalau biasa gimana caranya ya Teman-2 ?
Best rgd
Ferry_xls

__________________________________________________
Apakah Anda Yahoo!?
Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik terhadap spam
http://id.mail.yahoo.com

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com __._,_.___

Wahana Programmer Groups Links

<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
    http://wahanaprogrammer.net

<*> Untuk menghubungi owner milis ini, kirim email ke:
    [EMAIL PROTECTED]

<*> Konsultasi pemrogramman bisa chat disini:
    Yahoo! Messenger: wahanaprogrammer



YAHOO! GROUPS LINKS



__,_._,___

Kirim email ke