[V4MD] Probem with a simple query

[Frank Schima]

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?


Best regards,
Frank Schima