Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TAG() returns value but will not insert into table
Message
 
 
To
14/02/2006 15:38:17
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Novell 4.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01096302
Message ID:
01096309
Views:
12
Try to follow TAG() function syntax. BTW, a TAG name cannot be longer than 10 characters.
		INSERT INTO orderList( cTagName, tagExpression ) VALUES ;
			(TAG("", nTagCount, cAliasName), KEY("", nTagCount, cAliasName))
> In the code below, I added the line
? TAG(cAliasName, nTagCount)
as a debugging measure to try to figure out why my cTagName field was coming up empty everytime I ran this code. To my surprise, I was getting the TAG names written out to my VFP screen, but I still was getting nothing inserted into my table. Notice I'm trimming the value that I'm inserting, and none of the tag names are greater than the 50 character field width.
>
>
>LPARAMETERS cAliasName
>LOCAL nTagCount
>
>nTagCount = 1
>
>CREATE CURSOR orderList ( cTagName C(50), tagExpression C(200) )
>
>if TAGCOUNT(cAliasName) > 0
>	for nTagCount = 1 to TAGCOUNT(cAliasName)
>                  ? TAG(cAliasName, nTagCount)
>		INSERT INTO orderList( cTagName, tagExpression ) VALUES ;
>			(alltrim(TAG(cAliasName, nTagCount)), SYS(14, nTagCount, cAliasName))
>	endfor
>endif
>
>
>BTW, y'all are getting the "Thundering Train" version of the code here whereas I'm just trying to get the tags into the cursor for now & will put all proper precautions in place later. Thoughts anyone?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform