Re: How to convert values
- Posted by "Carl W." <euphoria at cyreksoft.yorks.com> Apr 22, 2003
- 393 views
sixs at ida.net wrote: > I have a value in sql for a key value that is integer. When I > retrieve the key value. from a list I show a value of 155. When I use > dbgui to access the edb database created in sql, It shows my value of > 667. That is what i entered, but I can't convert it. > I thought there might be a document that show what changes data. I > know there is a difference of single quotes and double quotes but I > would a cheat sheet to refer to the methods used to enter data and > retrieve it. I'm not familiar with the data formats used in EDB, but it looks to me like you're only extracting the low byte of an integer. Note that 667 = 2*256 + 155. You will probably have difficulty 'converting' this number, since _any_ number with a low byte of 155 will appear to be 155 if you use the same method to access it. i.e. 411, 667, 923, 1179, 1435, etc. would all become 155, and it is impossible to tell which one it was in the first place. Maybe there's a different function call you can use to extract the right data? Carl -- [ Carl R White == aka () = The Domain of Cyrek = ] [ Cyrek the Illogical /\ www.cyreksoft.yorks.com ]