Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to alter length value of a DBC Property
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Need to alter length value of a DBC Property
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01108649
Message ID:
01108649
Views:
50
I have some code that inserts two characters into some of a DBC's records, in the Properties field. Specifically, if the record defines a numeric field in a view definition, I am inserting a comma and the number of decimals into the DataType property. For example, if the value of the DataType property is MB(8), I am changing it to MB(8,4), with the number of decimals picked up from a metadata table. After doing that, I need to increase the property's length. From Doug Hennig's excellent article in FoxTalk a while back, which included his FixDBC utility, I know that the first four characters of the seven character string of low-order binary data preceding the property value store the length of the property. I know the length will never become more than 15 characters, so I think I can just add 2 to the first character. If so, how do I do that? Have not done much binary bit twiddling or binary addition in FoxPro (and assembler was waaaaaay too long ago to remember).

Thanks in advance for any advice.
Next
Reply
Map
View

Click here to load this message in the networking platform