Search results for query: *

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...

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)

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...

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

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 =...

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...

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

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...

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)

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)

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!"...

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...

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...

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...

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...

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...

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...

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...

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

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...