1. How to convert values
- Posted by sixs at ida.net Apr 18, 2003
- 417 views
This is a multi-part message in MIME format. ------=_NextPart_000_0082_01C3052A.E8C648A0 charset="iso-8859-1" I was wondering if there is documentation that identifies how to change = data. 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. Jim ------=_NextPart_000_0082_01C3052A.E8C648A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY style=3D"COLOR: #000000; FONT-FAMILY: " bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I was wondering if there is = documentation that=20 identifies how to change data.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I have a value in sql for a key = value that is=20 integer. When I retrieve the key value. from a list I show a value of = 155. When=20 I use dbgui to access the edb database created in sql, It shows my value = of=20 667.That is what i entered, but I can't convert it.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I thought there might be a document = that show what=20 changes data. I know there is a difference of single quotes and double = quotes=20 but I would a cheat sheet to refer to the methods used to enter data and = retrieve it.</FONT></DIV> ------=_NextPart_000_0082_01C3052A.E8C648A0--
2. Re: How to convert values
- Posted by "Carl W." <euphoria at cyreksoft.yorks.com> Apr 22, 2003
- 376 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 ]