Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find all values in Display Library
Message
 
 
To
04/01/2018 11:54:45
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01656928
Message ID:
01656951
Views:
35
>>
>>First, thank you.
>>
>>I have seen this type of designation (e.g. '0h####') before but never could understand it. So you are saying that the first two characters (0h) means that it is a hexadecimal and the next 3 numbers are '01', '00', and '33'. What I don't understand is why '33' is "translated" to "3" in your equation?
>
>The 0h## format is used to represent binary information, and it uses hexadecimal because it's a safe way to represent byte-based binary data (each byte uses two hexadecimal digits).
>
>In the ASCII character tables, codes 0h30 to 0h39 (48 to 57 in decimal) represent the digits "0" to "9". So, CHR(0h33) == "3", in the same way that ? CAST("3" AS Q) will result in 0h33.
>
>But, Dmitry, what I know about the database container structure is guesswork. If it results in what you're needing, then great, probably I'm guessing right. But it might me advisable to wear a helmet...

Antonio, what you know about the database container is quite a lot. And your code (in the initial message) was very helpful for me to do what I needed. Now I was just trying to understand how it works "under the hood". Of course I know that most likely I will forget about it in a short time. But for now, I am happy :).
Thank you!
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform