Moving rows in list boxes?
|
View:
New views
13 Messages
—
Rating Filter:
Alert me
|
 |
Moving rows in list boxes?
by Bill Weale
::
Rate this Message:
Do I understand correctly from the docs that you can reorder listbox
rows using the mouse (drag/drop) if the data source is arrays but not if it is a selection of records? Thanks, Bill William W. Weale, III Business Owners Support, LLC. Operations Analysis MIS Advising Decision Support Systems ********************************************************************** Get the speed and power of 4D v11 SQL before upgrade prices increase - http://www.4d.com 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4D.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4D_Tech-Unsubscribe@... ********************************************************************** |
|
|
Re: Moving rows in list boxes?
by Kenneth Spence-2
::
Rate this Message:
Yes, that is correct from my experience.
Ken On Nov 5, 2009, at 6:19 AM, Bill Weale wrote: > Do I understand correctly from the docs that you can reorder listbox > rows using the mouse (drag/drop) if the data source is arrays but > not if it is a selection of records? > > Thanks, > > Bill > > > > > William W. Weale, III > > Business Owners Support, LLC. > > Operations Analysis > MIS Advising > Decision Support Systems > > ********************************************************************** > Get the speed and power of 4D v11 SQL > before upgrade prices increase - http://www.4d.com > > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4D.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4D_Tech-Unsubscribe@... > ********************************************************************** ********************************************************************** Get the speed and power of 4D v11 SQL before upgrade prices increase - http://www.4d.com 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4D.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4D_Tech-Unsubscribe@... ********************************************************************** |
|
|
Re: Moving rows in list boxes?
by Chip Scheide
::
Rate this Message:
Sorry to hijack...
but... It would be nice if the feature set between array and selection based list boxes were consistent! Can/cant move rows, can/cant set text color (off the top of my head)... On Thu, 05 Nov 2009 07:44:45 -0700, Kenneth Spence wrote: > Yes, that is correct from my experience. > > Ken > On Nov 5, 2009, at 6:19 AM, Bill Weale wrote: > >> Do I understand correctly from the docs that you can reorder listbox >> rows using the mouse (drag/drop) if the data source is arrays but >> not if it is a selection of records? >> >> Thanks, >> >> Bill >> >> >> >> >> William W. Weale, III >> >> Business Owners Support, LLC. >> >> Operations Analysis >> MIS Advising >> Decision Support Systems >> >> ********************************************************************** >> Get the speed and power of 4D v11 SQL >> before upgrade prices increase - http://www.4d.com >> >> 4D Internet Users Group (4D iNUG) >> FAQ: http://lists.4d.com/faqnug.html >> Archive: http://lists.4D.com/archives.html >> Options: https://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:4D_Tech-Unsubscribe@... >> ********************************************************************** > > ********************************************************************** > Get the speed and power of 4D v11 SQL > before upgrade prices increase - http://www.4d.com > > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4D.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4D_Tech-Unsubscribe@... > ********************************************************************** > Get the speed and power of 4D v11 SQL before upgrade prices increase - http://www.4d.com 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4D.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4D_Tech-Unsubscribe@... ********************************************************************** |
|
|
Re: Moving rows in list boxes?
by Bill Weale
::
Rate this Message:
Thanks, Ken.
A way to provide this interface would be to do the LB with arrays from the records' field data while updating an "order by" field when the rows are moved? Am I missing another/better way? Bill On Nov 5, 2009, at 9:44 AM, Kenneth Spence wrote: > Yes, that is correct from my experience. > > Ken > On Nov 5, 2009, at 6:19 AM, Bill Weale wrote: > >> Do I understand correctly from the docs that you can reorder >> listbox rows using the mouse (drag/drop) if the data source is >> arrays but not if it is a selection of records? ********************************************************************** Get the speed and power of 4D v11 SQL before upgrade prices increase - http://www.4d.com 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4D.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4D_Tech-Unsubscribe@... ********************************************************************** |
|
|
Re: Moving rows in list boxes?
by Kenneth Spence-2
::
Rate this Message:
Bill,
What I have been doing is using an LB array as you describe and if I understand what you mean by "order by" field as being a priority then this is also what I do. I basically do the following in the On Row Moved event. $size:=Size of array(Order_ai) $count:=0 For ($x;1;$size) Order_ai{$x}:=$x GOTO RECORD([Changes_Fixes];RecID_ai{$x}) [Changes_Fixes]Order_Num:=$x SAVE RECORD([Changes_Fixes]) End for Ken On Nov 5, 2009, at 9:39 AM, Bill Weale wrote: > Thanks, Ken. > > A way to provide this interface would be to do the LB with arrays > from the records' field data while updating an "order by" field when > the rows are moved? > > Am I missing another/better way? > > Bill > > > > > > On Nov 5, 2009, at 9:44 AM, Kenneth Spence wrote: > >> Yes, that is correct from my experience. >> >> Ken >> On Nov 5, 2009, at 6:19 AM, Bill Weale wrote: >> >>> Do I understand correctly from the docs that you can reorder >>> listbox rows using the mouse (drag/drop) if the data source is >>> arrays but not if it is a selection of records? > > ********************************************************************** > Get the speed and power of 4D v11 SQL > before upgrade prices increase - http://www.4d.com > > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4D.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4D_Tech-Unsubscribe@... > ********************************************************************** ********************************************************************** Get the speed and power of 4D v11 SQL before upgrade prices increase - http://www.4d.com 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4D.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4D_Tech-Unsubscribe@... ********************************************************************** |
|
|
Re: Moving rows in list boxes?
by Kenneth Spence-2
::
Rate this Message:
Chip,
I sure agree with you on this. Ken On Nov 5, 2009, at 9:15 AM, Chip Scheide wrote: > Sorry to hijack... > but... > > It would be nice if the feature set between array and selection based > list boxes were consistent! > Can/cant move rows, > can/cant set text color > (off the top of my head)... > > On Thu, 05 Nov 2009 07:44:45 -0700, Kenneth Spence wrote: >> Yes, that is correct from my experience. >> >> Ken >> On Nov 5, 2009, at 6:19 AM, Bill Weale wrote: >> >>> Do I understand correctly from the docs that you can reorder listbox >>> rows using the mouse (drag/drop) if the data source is arrays but >>> not if it is a selection of records? >>> >>> Thanks, >>> >>> Bill >>> >>> >>> >>> >>> William W. Weale, III >>> >>> Business Owners Support, LLC. >>> >>> Operations Analysis >>> MIS Advising >>> Decision Support Systems >>> >>> ********************************************************************** >>> Get the speed and power of 4D v11 SQL >>> before upgrade prices increase - http://www.4d.com >>> >>> 4D Internet Users Group (4D iNUG) >>> FAQ: http://lists.4d.com/faqnug.html >>> Archive: http://lists.4D.com/archives.html >>> Options: https://lists.4d.com/mailman/options/4d_tech >>> Unsub: mailto:4D_Tech-Unsubscribe@... >>> ********************************************************************** >> >> ********************************************************************** >> Get the speed and power of 4D v11 SQL >> before upgrade prices increase - http://www.4d.com >> >> 4D Internet Users Group (4D iNUG) >> FAQ: http://lists.4d.com/faqnug.html >> Archive: http://lists.4D.com/archives.html >> Options: https://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:4D_Tech-Unsubscribe@... >> ********************************************************************** >> > ********************************************************************** > Get the speed and power of 4D v11 SQL > before upgrade prices increase - http://www.4d.com > > > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4D.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4D_Tech-Unsubscribe@... > ********************************************************************** ********************************************************************** Get the speed and power of 4D v11 SQL before upgrade prices increase - http://www.4d.com 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4D.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4D_Tech-Unsubscribe@... ********************************************************************** |
|
|
4d color to rgb
by Salow, John
::
Rate this Message:
Is there a way to calculate the rgb values for the 4d palette colors with generic 4d code?
thx ********************************************************************** Get the speed and power of 4D v11 SQL before upgrade prices increase - http://www.4d.com 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4D.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4D_Tech-Unsubscribe@... ********************************************************************** |
|
|
Re: Moving rows in list boxes?
by Arnaud de Montard
::
Rate this Message:
Le 5 nov. 09 à 14:19, Bill Weale a écrit : > Do I understand correctly from the docs that you can reorder listbox > rows using the mouse (drag/drop) if the data source is arrays but > not if it is a selection of records? I use this: Case of : (Form event=On Drag over) $0:=0 : (Form event=On Drop) DRAG AND DROP PROPERTIES ($srcObject;$srcElem;$srcProcess) $DstElem:=Drop position LONGINT ARRAY FROM SELECTION([aTable];$arr) array_switchLines ($srcElem;$DstElem;->$arr) CREATE SELECTION FROM ARRAY([aTable];$arr) End case -- Arnaud de Montard ********************************************************************** Get the speed and power of 4D v11 SQL before upgrade prices increase - http://www.4d.com 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4D.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4D_Tech-Unsubscribe@... ********************************************************************** |
|
|
Re: 4d color to rgb
by Arnaud de Montard
::
Rate this Message:
Le 5 nov. 09 à 22:48, Salow, John a écrit : > Is there a way to calculate the rgb values for the 4d palette colors > with generic 4d code? $1 is 4D color palette: CT COLOR TO RGB (CT Index to color ($1+1);$R;$G;$B) $R:=$R >> 8 `8 bits 0..255 $G:=$G >> 8 $B:=$G >> 8 $0:=($R << 16)+($G << 8)+($B) `color for SET RGB COLORS -- Arnaud de Montard ********************************************************************** Get the speed and power of 4D v11 SQL before upgrade prices increase - http://www.4d.com 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4D.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4D_Tech-Unsubscribe@... ********************************************************************** |
|
|
Re: 4d color to rgb
by Peter Bozek-2
::
Rate this Message:
On Thu, Nov 5, 2009 at 10:48 PM, Salow, John <john@...> wrote:
> Is there a way to calculate the rgb values for the 4d palette colors with generic 4d code? `help routine for converting indexed to RGB color `help routine for converting indexed to RGB color C_LONGINT($1;$0) `$1 indexed color between 0 and 255 C_LONGINT($l4;$l5;$l6;$offset) C_BLOB($o) GET RESOURCE("pltt";1010;$o) $offset:=($1+1)*16 $l4:=BLOB to integer($o;Macintosh byte ordering ;$offset) $l5:=BLOB to integer($o;Macintosh byte ordering ;$offset) $l6:=BLOB to integer($o;Macintosh byte ordering ;$offset) $0:=(($l4 & 0xFF00) << 8)+($l5 & 0xFF00)+(($l6 & 0xFF00) >> 8) -- Peter Bozek ********************************************************************** Get the speed and power of 4D v11 SQL before upgrade prices increase - http://www.4d.com 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4D.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4D_Tech-Unsubscribe@... ********************************************************************** |
|
|
Re: Moving rows in list boxes?
by Bill Weale
::
Rate this Message:
Interesting...
By using the record numbers are you using a "natural" tendency to order themselves? I've never really confirmed that always happened. I do have a use for the absolute numerical values of an "order by" field in each selection, though. Thanks, Bill On Nov 5, 2009, at 6:10 PM, arnaud wrote: > > Le 5 nov. 09 à 14:19, Bill Weale a écrit : > >> Do I understand correctly from the docs that you can reorder >> listbox rows using the mouse (drag/drop) if the data source is >> arrays but not if it is a selection of records? > > I use this: > > Case of > : (Form event=On Drag over) > $0:=0 > : (Form event=On Drop) > DRAG AND DROP PROPERTIES ($srcObject;$srcElem;$srcProcess) > $DstElem:=Drop position > LONGINT ARRAY FROM SELECTION([aTable];$arr) > array_switchLines ($srcElem;$DstElem;->$arr) > CREATE SELECTION FROM ARRAY([aTable];$arr) > End case > > -- > Arnaud de Montard > ********************************************************************** Get the speed and power of 4D v11 SQL before upgrade prices increase - http://www.4d.com 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4D.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4D_Tech-Unsubscribe@... ********************************************************************** |
|
|
Re: Moving rows in list boxes?
by Bill Weale
::
Rate this Message:
Thanks, Ken. I ended up using GOTO SELECTED RECORD() as I was using a
LB to shadow an included form on a different tab. It's used for drivers to arrange stops on a delivery route so the stops number fields could get their values from the LB order_ai array, keeping the included records in synch with the LB. Bill On Nov 5, 2009, at 3:51 PM, Kenneth Spence wrote: > Bill, > > What I have been doing is using an LB array as you describe and if I > understand what you mean by "order by" field as being a priority > then this is also what I do. > > I basically do the following in the On Row Moved event. > > $size:=Size of array(Order_ai) > $count:=0 > For ($x;1;$size) > Order_ai{$x}:=$x > GOTO RECORD([Changes_Fixes];RecID_ai{$x}) > [Changes_Fixes]Order_Num:=$x > SAVE RECORD([Changes_Fixes]) > End for > > Ken ********************************************************************** Get the speed and power of 4D v11 SQL before upgrade prices increase - http://www.4d.com 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4D.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4D_Tech-Unsubscribe@... ********************************************************************** |
|
|
Re: Moving rows in list boxes?
by Arnaud de Montard
::
Rate this Message:
Le 6 nov. 09 à 15:28, Bill Weale a écrit : > Interesting... > > By using the record numbers are you using a "natural" tendency to > order themselves? I've never really confirmed that always happened. If you sort on this record number, records will be ordered in this "natural" order (position in data). But what I meant is ordering LB selection with mouse. For example, when mouse drag & drop must update a "sorting field": A 1 B 2 C 3 drag B down, set field in column 2 A 1 C 2 B 3 -- Arnaud de Montard ********************************************************************** Get the speed and power of 4D v11 SQL before upgrade prices increase - http://www.4d.com 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4D.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4D_Tech-Unsubscribe@... ********************************************************************** |
| Free embeddable forum powered by Nabble | Forum Help |
