pake sql, syntaxnya :

---Bikin Table nya---
conn.execute "Create Table TempTable (KODE char(1),
BANYAK int)"

---Ambil Recordset nya---
set rsTemp= New Connection

rsTemp.open "Select * from TempTable", conn,
adOpenDynamic, adLockOptimistic

rgds


--- yurika erliani <[EMAIL PROTECTED]> wrote:

> halo friends, bantuin aku ya....
> 
> 1. Ada gak perintah membuat table temprory di VB
> lengkap dengan struktur field & type-nya. 
> 
> 2. misal saya punya table sbb :
> 
>  kode     banyak
> ----------------
>   a         5
>   b         4
>   c         7
>   d         8
> ----------------
> Bagaimana melakukan operasi penjumlahan/perkalian
> pada
> baris2 record tsb. misalnya saya mau menambahkan
> record baris pertama dg baris kedua (5 + 4), baris
> ketiga dg keempat (7+8) dst ! 
> 
> thanks
> 
> 
>               
> __________________________________ 
> Do you Yahoo!? 
> Yahoo! Mail - Find what you need with new enhanced
> search. 
> http://info.mail.yahoo.com/mail_250
> 


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


Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/Programmer-VB/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Kirim email ke