Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: Gerzon
  Where is Gerzon?
 Yogyakarta
 Indonesia
 Gerzon
 Tags
Subject: RE: Invalid call issued SQLMORERESULT()
Thread ID: 345335 Message ID: 345340 # Views: 31 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Tuesday, May 22, 2012 6:19:19 PM         
   


> hi expert,
>
> I use SPT for parsing Query to SQL Server 2000 on Windows 7 Ultimate Version and Get an Error after executing an SQL Statement in
> SQLEXEC(.....) Function as Follow :
>
> Invalid Call Issued White Executing a SQLMORERESULTS()Sequences.
>
> what's wrong with my program..., I run this in WIndows XP Mechine and get No Problem at all. need your advise...
>
> Thanks in Advanced.


Hi Gerzon,
Add code to assign True to BatchMode after you get a successful connection handle and before you try SPT selection. Where gnConnHandle is the memvar for your initial connection handle.

nSet=sqlsetprop(gnConnHandle,"batchmode",.T.)


Let me know if your error goes away?
Pete "the IceMan", from the Great White North of Canada.
www.marathongriffincomputers.com

ENTIRE THREAD

Invalid call issued SQLMORERESULT() Posted by Gerzon @ 5/22/2012 5:42:28 PM
RE: Invalid call issued SQLMORERESULT() Posted by Borislav Borissov @ 5/22/2012 6:12:27 PM
RE: Invalid call issued SQLMORERESULT() Posted by Pete Sass @ 5/22/2012 6:19:19 PM