main logo
Subject: Re: cursor not returning result of query - [V4MD] v 1.9.6 MAC
Author: "Mathew Ray"
Posted: 2002/12/30 13:16:00
 
View Entire Thread
New Search


Thanks Gunnar,

Found the problem....

For some reason my director movie on the mac would not open valentina
database files created on the PC. So, using vApp, I recreated the tables on
the mac and imported a txt file containing my data. Now the database opens
fine on the mac...have yet to see how it does on the pc.

~Mathew

----- Original Message -----
From: "Gunnar Swan" <GunnarSwan .at. PracticeToPass DO.T com>
To: "Subscribers of Valentina" <valentina@lists.macserve.net>
Sent: Monday, December 30, 2002 1:08 PM
Subject: Re: cursor not returning result of query - [V4MD] v 1.9.6 MAC


> You are creating an instance of the cursor xtra.
> Then you have to do CursorInstance.GetRecords()
>
> 12/30/02 8:41:35 AM, "Mathew Ray" <mathew .at. iqtv DO.T com> wrote:
>
> >Hi All,
> >
> >For some reason, this select statement works fine on PC and not on the
MAC:
> > sqlQuery = "SELECT playorder FROM spottypes WHERE code = 'blah'
> > queryResults = new( xtra "VCursor", GetRef(gDB), sqlQuery )
> >
> >The database looks fine on the mac using ViSQL and the query returns the
> >proper result.
> >
> >I am using the release builds of Valentina 1.9.6 from the Paradigma
website.
> >
> >Anyone have an idea why on the mac the queryResults would be -2147483645
> >instead of an instance of the vCursor xtra? Also, while debugging, I
> >confirmed that gDB is an instance of vDatabase.
> >
> >Many Thanks,
> >Mathew J. Ray
> >..................................
> >Interactive Developer
> >IQ Television Group
> >
> >tel: 404.255.3550
> >fax: 770.956.8014
> >..................................
> >
> >
> >
> >
> >-------------------------------------------------------------
> >The Valentina mailing list is brought to you by MacServe.net
> >For info on lists services, see http://www.macserve.net/lists.html
> >
>
>
> ------------------------------------
> Gunnar Swan
> Practice To Pass
> Built For Statutory Courses
> ------------------------------------
>
>
>
> -------------------------------------------------------------
> The Valentina mailing list is brought to you by MacServe.net
> For info on lists services, see http://www.macserve.net/lists.html
>




-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html


 
©2002 Mathew Ray
<-- Prior Message New Search Next Message -->