Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cyberbiker
  • Order by date
  1. cyberbiker

    DbGrid control Unbound Mode

    I truly appreciate your help on this. I learned a lot (mostly what not to try). I used DBgrid several years ago in bound mode and it worked quite well for those apps. I realize I could use it in unbound mode as well, but, as it turned out, not for this situation unless I used a UNION query as...
  2. cyberbiker

    DbGrid control Unbound Mode

    I did just discovered that I can edit the list View control with 2 single clicks on the item (qty) That is much better for my needs. I did put in the pop up as well if they double click which should make everybody happy Terry (cyberbiker)
  3. cyberbiker

    DbGrid control Unbound Mode

    This may clear up my problem a bit. I need to read 1 record from an inventory table display that record read another record display that along with the first and so on and so on Each record is selected according to a unique key in the database The user may then edit the quantity column and...
  4. cyberbiker

    DbGrid control Unbound Mode

    Oops that was application defined or Object defined error Terry (cyberbiker)
  5. cyberbiker

    DbGrid control Unbound Mode

    Bob, I need the ability to work unbound and edit the grid directly which is why I chose DBrid control. I may need to choose a different method though. I am thinking of just adding text boxes at run time and "faking" a grid. Hugh, This line fails for me when maxrow is not 0. DBgrid1.row =...
  6. cyberbiker

    DbGrid control Unbound Mode

    I have been swamped today with unrelated issues so am really just starting with this. I am uncertain if I am even going about this in the right way. Simply put, I am developing an application where either they scan a bar code or enter a part number manually. I want to display this data...
  7. cyberbiker

    DbGrid control Unbound Mode

    Thanks Bob, I am looking at it now and experimenting to see if it gives me what I want. Terry (cyberbiker)
  8. cyberbiker

    DbGrid control Unbound Mode

    I have been experimenting with this and still have 2 problems. I can fill each column fine as Bob showed. But when I try to add a second row, I overwrite the columns in the first row. I just cannot seem to add a second row (etc) through code. Additionally, I cannot clear the grid though...
  9. cyberbiker

    DbGrid control Unbound Mode

    Very much so. I did discover I had to specify the row first. I left the code at work but I think it was something like DbGrid1.row = (SomeInteger) then your code. Thanks a lot Terry (cyberbiker)
  10. cyberbiker

    DbGrid control Unbound Mode

    It has been a very long time since I worked with the DBGrid control and I could use some help. I need to use the control in the unbound mode. Does any one happen to remember how to address a given cell. Ie: set column 0 row 3 = somevalue. Thanks Terry (cyberbiker)
  11. cyberbiker

    Binary to int conversion

    I might perhaps do it using SQL but I think the best for this situation might be a small stand alone utility that would pass the binary to an SQL stored procedure as an input argument where I then convert and store the values to be used when needed Upon success, I would display a "You did it!"...
  12. cyberbiker

    Binary to int conversion

    First: these will be a limited number of values that will remain "constant". second: Time is critical since I am delaying the engineer writing the ladder logic. (Of course, they are out relaxing and I am working over a holiday weekend) I took my motorcycle out for a 300 mile trip...
  13. cyberbiker

    Binary to int conversion

    Thank you very much for your help. Your stored procedure code has been a big help. I have experimented with it and have shown that my origional conversions seem to have been correct, which was my big question. Based on what I have been reading storing the value as 33588736 should give what is...
  14. cyberbiker

    Binary to int conversion

    Darn it. I never inserted the commas, just looked at it and thought I was looking at 6 billion, not 671 million. My close eyesight is not so good. I know that, but cannot seem to adjust. However 2,181,072,384 is too large (as well as 3 additional values out of 15 or so that I converted.) My...
  15. cyberbiker

    Binary to int conversion

    Maybe I need to go back to square one. A single bit can be on or off, correct? Thus the value is 1(on) or 0 (off) This should be a binary representation of a 32 bit piece of data (4 Bytes each byte consiting of 8 bits) 00101000000000000010100000000000: Which I convert to a DWord which I...
  16. cyberbiker

    Binary to int conversion

    from BOL int Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). Storage size is 4 bytes. The SQL-92 synonym for int is integer. My conversion gives: 2181072384 which cannot be stored as a 4 byte field in SQL Server Additionally, my largest value(at...
  17. cyberbiker

    Binary to int conversion

    Basically, a PLC control will be using this value. It will be looking for (and I quote) "A 32-bit integer" I need to find some old code I worked with and refresh my memory as to exactly what will be being done with the value stored in the database field. My confusion here is that I have never...
  18. cyberbiker

    Binary to int conversion

    E-Squared Your suggestion did show my calculations were correct and thank you for pointing out the fact that bigint is signed integer is also signed and that is my problem I think. This project is very difficult to explain, but simply put, Each bit stored in a 32-bit field has a particular...
  19. cyberbiker

    Running SQL script

    SQLBill, That little piece of info just opened up a whole new outlook for me in ref to MSDE. Thanks Terry (cyberbiker)
  20. cyberbiker

    Binary to int conversion

    BigInt is 64 bit is it not? I am also thinking of the sql_variant datatype, but BOL says that sql_variant is "Not fully supported" with ODBCwhich may be a problem I was thinking that I have not converted the value properly. It has been some time since I have done any binary to integer...

Part and Inventory Search

Back
Top