Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec and Select...
Message
From
11/03/2004 21:03:58
 
 
To
11/03/2004 06:26:24
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00885079
Message ID:
00885463
Views:
18
Hi, (olá) Erik,

I try but no luck, if i retrive the data with a RS and then convert it to dbf, and then do the select,it works ok, but if i call it with SQLEXEC, it shows the error,
		lcAliasTmp=LOWER(SYS(2015))
		IF .cTipoLigacao='ADO'
			*// Procura Dados
			.oDocFac.NovoCab(.oRS99)
			.oDocFac.lst_VendasGerais(.oRS99,'1', ldDataI,ldDataF, lcCliI, lcCliF, lcArmI,lcArmF,TDoc,'ADO')
			.RS2DBF(.oRS99,lcAliasTmp)
		ENDIF
		IF .cTipoLigacao='SQLEXEC'
			.oDocFac.lst_VendasGerais(.oRS99,'1', ldDataI,ldDataF, lcCliI, lcCliF, lcArmI,lcArmF,TDoc,'SQLEXEC')
			=SQLEXEC(.cSQLEXECCon,.oDocFac.cSQLQuery,lcAliasTmp)

		ENDIF
		 
		lcAliasMapa=LOWER(SYS(2015))			
		SELECT * FROM (m.lcAliasTmp) INTO TABLE '.\tmp\'+m.lcAliasMapa READWRITE

		ALTER TABLE &lcAliasMapa ADD COLUMN DataI d(8)
		ALTER TABLE &lcAliasMapa ADD COLUMN DataF d(8)
		ALTER TABLE &lcAliasMapa ADD COLUMN CliI  c(5)
		ALTER TABLE &lcAliasMapa ADD COLUMN CliF  c(5)
João Batista

PS: Erick podes responder em Porugues. :)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform