Sorry, my mistake in not explaining in details
I have problem on 'Multiple-step operation generated errors. Check
each status value'. when i use Visual Basic ADODC OCX to addnew. This is
the sample of my source code. The problem crop up when the bookmark value > 1.
againxxx1:
Form1.DtaOut.Recordset.AddNew
' MsgBox Form1.DtaOut.Recordset.Bookmark
If Form1.DtaOut.Recordset.Bookmark > 1 Then
Form1.DtaOut.Recordset.CancelUpdate
Form1.DtaOut.Recordset.Close
Form1.DtaOut.Recordset.Open
Form1.DtaOut.RecordSource = "Select * from " & GblOutDB & "
Where id = 1"
Form1.DtaOut.Refresh
GoTo againxxx1
'Form1.DtaOut.Recordset.Bookmark = 1
End If
Form1.DtaOut.Recordset("aDate") = Format(Date, "mm/dd/yyyy") &
" " & Format(Time, "hh:mm:ss ampm")
Form1.DtaOut.Recordset("method") = "2"
Form1.DtaOut.Recordset("sp") = Gblsp
Form1.DtaOut.Recordset("mobile") =
Form1.DtaIn.Recordset("Sender")
Form1.DtaOut.Recordset("Sender") =
Form1.DtaIn.Recordset("Sender")
Form1.DtaOut.Recordset("try") = "0"
Form1.DtaOut.Recordset("member") = GblMember
Form1.DtaOut.Recordset("Serviceid") = GblServiceID
Form1.DtaOut.Recordset("msgid") =
Form1.DtaIn.Recordset("msgid")
Form1.DtaOut.Recordset("Priority") = GblPriority
Form1.DtaOut.Recordset("Status") = "Normal"
Form1.DtaOut.Recordset("smstype") = Gblsmstype
Form1.DtaOut.Recordset("aMT") = GblaMT
Form1.DtaOut.Recordset("smsfile") =
Form1.DtaIn.Recordset("smsfile")
Form1.DtaOut.Recordset("msg") = GblError1
Form1.DtaOut.Recordset.Update
At 06:03 AM 5/17/2002 -0500, Gerald R. Jensen wrote:
>Bookmarking?!
>
>No, MySQL does not support bookmarking ... it is relational database
>manager, not a word processor. All you have to do is save the query you run,
>and it will return the same results.
>
>----- Original Message -----
>From: "SB Lim" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, May 17, 2002 5:42 AM
>Subject: BookMark
>
>
>
>
>I am using VB6 with MYSQL,
>
>Is MYSQL support Bookmarking ?
>How can I implement that on the MYSQL ?
>
>Regards
>SB Lim
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
