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 |