mungkin connector ODBC anda tidak mensupport cursor dengan type
dynamic. coba tambahkan option untuk membolehkan cursor tipe dynamic
dengan cara menambahkan 32 pada option anda sehingga menjadi 3+32
ini saya tampilkan option untuk connector ODBC biar jelas
1 If the client wants the real width of the column.
2 The client can't handle that MySQL returns the true value of
affected rows. If this flag is set then MySQL returns 'found rows'
instead. One must have MySQL 3.21.14 or newer to get this to work.
4 Make a debug log in c:\myodbc.log. This is the same as putting
MYSQL_DEBUG=d:t:O,c::\myodbc.log in `AUTOEXEC.BAT' - Enabled only
in debug mode
8 Don't set any packet limit for results and parameters
16 Don't prompt for questions even if driver would like to prompt
32 Enable or disable the dynamic cursor support. This is not allowed
in MyODBC.
64 Ignore use of database name in `database.table.column'.
128 Force use of ODBC manager cursors (experimental).
256 Disable the use of extended fetch (experimental)
512 Pad CHAR fields to full column length.
1024 SQLDescribeCol () will return fully qualified column names
2048 Use the compressed server/client protocol
4096 Tell server to ignore space after function name and before '('
(needed by PowerBuilder). This will make all function names keywords!
8192 Connect with named pipes to a mysqld server running on NT.
16384 Change LONGLONG columns to INT columns (Some applications can't
handle LONGLONG).
32768 Return 'user' as Table qualifier and Table owner from SQLTables
(experimental)
65536 Read parameters from the client and odbc groups from `my.cnf'
131072 Add some extra safety checks (should not bee needed but...)
262144 Disable transactions
524288 Write all queries to `c:\myodbc.sql` (`/tmp/myodbc.sql`)
Enabled only in debug mode
1048576 Do not cache the results locally in the driver, instead read
from server (`mysql_use_result`). This works only for forward-only
cursor types. This option is very important in dealing with large
tables when one doesn't want the driver to cache the entire result set.
2097152 Force the use of 'Forward-only' cursor type.
Semoga ini bisa membantu anda
Terima Kasih
Salam,
^Aiska Henda^
--- In [email protected], "acholyte_rbo" <[EMAIL PROTECTED]>
wrote:
>
> Salam utk semua anggota milis
>
> Saya punya koding seperti ini
>
> If sRec.State = adStateOpen Then sRec.Close
> sComm.CommandText = "select * from exim_beacukai_trc_bc23 where no
> ='" & Text1(23).Text & "'"
> sComm.ActiveConnection = sConn
> sRec.Open sComm, , adOpenDynamic, adLockOptimistic
>
> If Not sRec.EOF Then
> sRec("kode") = Text1(24).Text
> srec.update
> end if
>
> tetapi muncul message update failed because row to update not found,
> kok bisa yah, padahal didatabase ada, dan saya sudah debug ( F8 )
> query diatas, tapi saat mau update muncul message itu lagi, kadang
> kalau saya develop program, kadang muncul kasus seperti ini, kadang
> tidak muncul di program lainnya, apakah hal ini dipengaruhi oleh
> banyaknya field dalam tabel tersebut ??
>
> please advicenya, karena repot sekali jika saya harus ganti koding
> menjadi query 'update bla bla bla...'
>
> Please advicenya, anggota milis
>
> saya pakai vb 6, cr 9 + mysql + mysqlodbc versi 3.5
>
> Best Regard's
>
> Benny
>
