Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Works in Command Window but not when running form
Message
From
02/12/2014 15:00:50
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Works in Command Window but not when running form
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01611698
Message ID:
01611698
Views:
133
I have the following query
Select csrBOM_1.*, pUniq_Key As Assy_uniq, pAssyNo As assy_no, pAssyRev As Assy_Rev, pAssyDesc As Assy_Desc, ;
				pCustAssy As Cust_Assy, lnLevel As nLevel, pUniq_Key As Bom_Parent ;
				FROM csrBOM_1 Where (PART_SOURC IN('PHANTOM', 'MAKE')) Or ;
				(PART_SOURC = 'MAKE' And PHANT_MAKE) Into Cursor csrBOM_Two Readwrite
When it runs in a compiled app it gives an error "Function Arguement value, type, or count is invalid"

If I run the application in VFP and put it in Debug mode it will error when that line is encountered

If I cut and paste the line into the command window it executes properly.

I changed the query to
Select csrBOM_1.*, pUniq_Key As Assy_uniq, pAssyNo As assy_no, pAssyRev As Assy_Rev, pAssyDesc As Assy_Desc, ;
				pCustAssy As Cust_Assy, lnLevel As nLevel, pUniq_Key As Bom_Parent ;
				FROM csrBOM_1 Where PART_SOURC IN ('PHANTOM', 'MAKE') Or ;
				(PART_SOURC = 'MAKE' And PHANT_MAKE) Into Cursor csrBOM_Two Readwrite
( Removed a set of parens and added a space after the IN parameter)

and now the query runs in the app and command window.

Is there something about the extra parens and/or the missing space that could cause this?????

Thanks........Rich
Next
Reply
Map
View

Click here to load this message in the networking platform