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
 Pete Sass
 To: Gerzon
  Where is Gerzon?
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.


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


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