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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.