Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to suppress ODBC client driver error dialogs?
Message
De
14/02/2016 19:19:24
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
12/02/2016 02:56:34
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Virtual environment:
VirtualBox
Divers
Thread ID:
01631344
Message ID:
01631447
Vues:
64
>Yes, the help says that if the return value is more than 1, it represents the number of "result sets" returned. But it looks pretty kludgy to get more than 1 result back from a single SQLEXEC(). Have you ever needed to do that?

Between six and twenty, for big batch jobs. I actually made it a bit more flexible by including a special field in the beginning of each, so I would have meaningful aliases for them:

select '+' as crsMyCursorName, ....fields...

then I'd have a realias() function which would do this
*	PROCEDURE ReAlias(tcFrom, tcTo)
*[2007/05/04 00:51:49] dragan - JUST reopens the passed ALIAS AGAIN
		tcTo = EVL(tcTo, FIELD(1, tcFrom))
		IF USED(tcFrom)
			USE IN SELECT(tcTo)
			USE DBF(tcFrom) IN 0 ALIAS (tcTo) AGAIN
			USE IN SELECT(tcFrom)
		ENDIF

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform