From: valerbru on
I'm trying SQLite and MySql with Vo2Ado 2.6 (VO 2.6).
Append is OK
Modify is ok
browsing is ok
Delete Record
self: oClienti: Delete ()
give error code 33 error
Function: => STRING
Argument: NIL
Requested type: STRING

Why? What am I doing wrong?

Thanks in advance
From: Geoff Schaller on
Can you give us some more information please?

(try not to put so many spaces in your code - recipe for mistakes)

However, most us only work with VO2Ado for 2.7 and up and it is not know
what else is behind the Delete() method. A full calling stack right back
into the VO2Ado source would be more useful or the exact block of code
where this occurs.

Geoff



"valerbru" <valerbru(a)tiscali.it> wrote in message
news:34d5f0ba-3adc-4d50-9483-466381038fe7(a)f14g2000vbn.googlegroups.com:

> I'm trying SQLite and MySql with Vo2Ado 2.6 (VO 2.6).
> Append is OK
> Modify is ok
> browsing is ok
> Delete Record
> self: oClienti: Delete ()
> give error code 33 error
> Function: => STRING
> Argument: NIL
> Requested type: STRING
>
> Why? What am I doing wrong?
>
> Thanks in advance

From: valerbru on
On 4 Giu, 00:46, "Geoff Schaller" <geo...(a)softxwareobjectives.com.au>
wrote:
> Can you give us some more information please?
>
> (try not to put so many spaces in your code - recipe for mistakes)
>
> However, most us only work with VO2Ado for 2.7 and up and it is not know
> what else is behind the Delete() method. A full calling stack right back
> into the VO2Ado source would be more useful or the exact block of code
> where this occurs.
>
> Geoff
>
> "valerbru" <valer...(a)tiscali.it> wrote in message
>
> news:34d5f0ba-3adc-4d50-9483-466381038fe7(a)f14g2000vbn.googlegroups.com:
>
>
>
> > I'm trying SQLite and MySql with Vo2Ado 2.6  (VO 2.6).
> > Append is OK
> > Modify is ok
> > browsing is ok
> > Delete Record
> > self: oClienti: Delete ()
> > give error code 33 error
> > Function: => STRING
> > Argument: NIL
> > Requested type: STRING
>
> > Why? What am I doing wrong?
>
> > Thanks in advance- Nascondi testo citato
>
> - Mostra testo citato -

OK!

Method DeleteRecord() class MyWindow
self:oClienti:Delete()
Return self

but record is be deleted anyway



From: Geoff Schaller on
That didn't help <g>.

I understand that even though you get an error, the delete takes place.

What I wanted to see was oClienti:Delete() and the source code to this
method. You should step into this with your debugger or at very least,
get a full calling stack.

Alternately, just wrap the error so that the user does not get a
message and continue on.

Geoff



"valerbru" <valerbru(a)tiscali.it> wrote in message
news:c042b240-fb95-4175-9872-55c743d2b2c9(a)x21g2000yqa.googlegroups.com:

> On 4 Giu, 00:46, "Geoff Schaller" <geo...(a)softxwareobjectives.com.au>
> wrote:
>
> > Can you give us some more information please?
> >
> > (try not to put so many spaces in your code - recipe for mistakes)
> >
> > However, most us only work with VO2Ado for 2.7 and up and it is not know
> > what else is behind the Delete() method. A full calling stack right back
> > into the VO2Ado source would be more useful or the exact block of code
> > where this occurs.
> >
> > Geoff
> >
> > "valerbru" <valer...(a)tiscali.it> wrote in message
> >
> > news:34d5f0ba-3adc-4d50-9483-466381038fe7(a)f14g2000vbn.googlegroups.com:
> >
> >
> >
>
> > > I'm trying SQLite and MySql with Vo2Ado 2.6 (VO 2.6).
> > > Append is OK
> > > Modify is ok
> > > browsing is ok
> > > Delete Record
> > > self: oClienti: Delete ()
> > > give error code 33 error
> > > Function: => STRING
> > > Argument: NIL
> > > Requested type: STRING
> >
> > > Why? What am I doing wrong?
> >
> > > Thanks in advance- Nascondi testo citato
> >
>
> > - Mostra testo citato -
>
>
> OK!
>
> Method DeleteRecord() class MyWindow
> self:oClienti:Delete()
> Return self
>
> but record is be deleted anyway

From: valerbru on
***********************ERROR********************************
CA-Visual Objects (Version 2.6.0, Build 1151), Version 2.6
04/06/2010 11.29.24
Application: F:\CAVO26\bin\DemoSql.DBG

Error message:
--------------
Error Code: 33 [ DATA TYPE ERROR ]
Subsystem: BASE
Function: =>STRING
Argument: NIL
Requested type: STRING
CallStack:
MYWINDOW:DELETERECORD (Line: 12)
APP:START (Line: 9)

Error Object created:
--------------------
SubSystem :BASE
SubCode :0
GenCode :Data type error
OsCode :0
ArgType :NIL
FuncPtr :0x00504AB3
ArgNum :0
FuncSym :=>STRING
Severity :0
CanDefault :.F.
CanRetry :.F.
CanSubstitute :.T.
Operation :
Description :
FileName :
Tries :0
FileHandle :0
SubCodeText :
Arg :NIL
ArgTypeReq :STRING
MaxSize :0
SubstituteType :STRING
CallFuncSym :
--------------------