[V4MD] Probem with a simple query

[info at vallemediatime.com]

----- Original Message -----
From: "Frank Schima" <macsforever2000 at goodeast.com>
To: "Valentina Developers" <valentina at lists.macserve.net>
Sent: Thursday, October 06, 2005 12:01 AM
Subject: Re: [V4MD] Probem with a simple query


> Hi Paolo,
>
>
> On Oct 5, 2005, at 3:34 PM, <info at vallemediatime.com> wrote:
>
> > this simple query not works, why?
> >
> > query = "SELECT RecID, * from Person WHERE fPerson_ID = 1001"
> >
> > -- Table Person is:
> > on CreateTable_Person
> > Person = gDb.createTable("Person")
> > Person.createShortField("fPerson_ID", [#fUnique])
> > Person.createStringField("fPerson_Name", 20)
> > Person.createByteField("fPersonType_Ref")
> > end
>
> That is certainly valid SQL. Have you tried the SQL in ViSQL or
> VStudio? Can you be more specific about what does not work?

query = "SELECT RecID, * from Person WHERE fPerson_ID = 1001"
put gCursor.recordCount
-- 0

if in the same script I write
query = "SELECT RecID, * from Person WHERE fPersonType_Ref = 1"
gCursor = gDb.sqlSelect(query, #kServer, gLockType, #kRandom)
put gCursor.recordCount
-- 104

both value (1001 and 1) exist in relative table.fields

Tomorrow I can try with VStudio or VStudio

Thanks
Paolo



> Best regards,
> Frank Schima
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.11.9/115 - Release Date: 29/09/2005
>
>