Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TAG() returns value but will not insert into table
Message
From
14/02/2006 15:55:04
 
 
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:
01096312
Views:
14
>Hi everyone,
> 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?

You need the name of the cdx file not the alias in TAGCOUNT("indexfile.cdx") or TAGCOUNT() by itself for the currently selected table.

Ed
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform