RE: [RBASE-L] - A "null" variable image

[Bruce Chitiea]

No selecting-out null records from the data set before generating report?

Bruce A. Chitiea
SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 USA
(909) 238-9012 m |
rby...@safesectors.com
On Nov 10, 2022, 14:53 -0800, javier.valen...@vtgonline.com, wrote:
> I am trying to figure out how where the picture names/links are stored.
> How do you know how many picture placeholders to assign in the report?
> If you have a record in Table1 and the corresponding picture names are stored 
> in Table2 on a 1 to many relationships, which I believe would the recommended 
> approach, then you can create a parent and a child table in your report, and 
> I will print only pictures that are available and not display blank 
> placeholders.
> I will guess that your application is probable different
> You can always create a blank picture that is basically a blank, thin sliver 
> and then, when you get your variables run something like this:
> IF vFilename3 IS NULL THEN
>   SET VAT vFilename3 = ‘c:\BlankPic.jpg’
> ENDIF
> This will display the blank picture that should not take much space.
> I am not sure how your data is structured in you application and hopefully, 
> the above is of help.
>
> Javier,
>
> Javier Valencia, PE
> 913-915-3137
>
> From: 'Karen Tellef' via RBASE-L 
> Sent: Thursday, November 10, 2022 1:46 PM
> To: rbase-l@googlegroups.com
> Subject: Re: [RBASE-L] - A "null" variable image
>
> I'm guessing I have to go with a "null" image to display.  Certainly easier 
> than the code to make the images visible or invisible.
>
> I do not have to collapse the space, only one part prints on a page and the 
> photos are at the bottom
>
> Karen
>
>
>
>
> -Original Message-
> From: Robert Thompson 
> To: rbase-l@googlegroups.com
> Sent: Thu, Nov 10, 2022 2:28 pm
> Subject: RE: [RBASE-L] - A "null" variable image
> Not sure about a setting, perhaps someone else is.
>
> But if not, you might consider a "default" image that is  a simple white or 
> transparent square.  Then predefine all 4 variables to "Default.jpg" (or what 
> ever).
>
> Then if you do not assign an actual image,  the default will always display.  
>  No real code changes other than the variable filename predefault.
>
> This would also allow you to display a default image for information or some 
> other nice option.
>
> However if you are wanting to collapse the print space when both image 3 & 4 
> are null, this would not help.
>
> And as you stated, the make invisible code would work as well.
>
>
>
> Robert Thompson
> TTC Inc.
> 219-363-7441
>
>
>  Original message 
> From: 'Karen Tellef' via RBASE-L 
> Date: 11/10/22 1:53 PM (GMT-05:00)
> To: rbase-l@googlegroups.com
> Subject: [RBASE-L] - A "null" variable image
>
> Hopefully I can explain this.   I have attached a print-screen because my 
> embedded images don't show in the list emails.
>
> Each part we print on this report can have unlimited (or no) photos saved on 
> disk.  We will print no more than 4 on the page, so I am pulling 4 random 
> photos into my text variables (vfilename1, 2, 3, 4), and Variable Images are 
> located.
>
> Works great except when I have null variables.  As shown on the attached, 
> vFilename1 and vFilename2 have values and print the photos just fine.  But 
> variables vFilename3 and vFilename4 are NULL (as shown below, my null setting 
> is actually ' ' when printing but I changed to -0- to show you the list).
>
> The null ones have that weird white/red thing.  I'm wondering if I am missing 
> a setting for these.  I know I can write code to make controls invisible, but 
> I was hoping I'm missing something simple.
>
> Any clues for me?
>
> Karen
>
> Variable   = Value    Type
> --   --   
> ---
> vFilename1 = F:\Quality\123773-A.jpg  TEXT
> vFilename2 = F:\Quality\123773-B.jpg  TEXT
> vFilename3 = -0-  TEXT
> vFilename4 = -0-  TEXT
>
> --
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/1588128635.1982897.1668106391324%40mail.yahoo.com.
> --
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+unsubscr...@googlegroups.com.
> To view this discussion 

Re: [RBASE-L] - A "null" variable image

['Karen Tellef' via RBASE-L]

Javier:
We don't store the filenames in the database at all.  They are all stored in a 
directory with the unique ID as the beginning characters of the filename.  My 
examples were shortened as an example, but for example for CARLogID 5800, I 
would do a Dir /B of files that start with "5800-".  So we do a DIR and load 
into a temp table.  That way the users can add and delete files outside of 
RBase, and the database isn't involved at all.
So my program loads the dir into a temp table called tmpCARPhotos.  It would 
usually load for several CARLogIDs at a time.  The temp table has an 
autonumbered CARPhotoID column.

In the report, I now have this in the report's Break Header (on CARLogID) 
Before Generate EEP.  Works great now!

 SET VAR vfilename1 TEXT = “BlankJPG.JPG”,vfilename2 TEXT = “BlankJPG.JPG”, +
  vfilename3 TEXT = “BlankJPG.JPG”,vfilename4 TEXT = “BlankJPG.JPG”
  
SET VAR vMin INT = 0, vMax INT = 0

SELECT (MIN(CARPhotoID)), (MAX(CARPhotoID)) INTO vMin, vMax FROM tmpCARPhotos +
  WHERE CARLogid = .vPCARLogid
IF vMin > 0 THEN
  SET VAR vCount = (.vMax - .vMin + 1)
  SET VAR vCount = (IFGT(.vCount, 4, 4,.vCount))
  SET VAR vLoop = 1
  WHILE vLoop <= .vCount THEN
    SET VAR vText =("vFilename" + CTXT(.vLoop))
    SELECT CARFilename INTO  tmpCARPhotos WHERE CARLogID = 
.vPCARLogID +
  AND CARPhotoID = .vMin
    SET VAR vLoop = (.vLoop + 1), vMin =(.vMin + 1)
  ENDWHILE
ENDIF
 

Karen

-Original Message-
From: javier.valen...@vtgonline.com
To: rbase-l@googlegroups.com
Sent: Thu, Nov 10, 2022 5:52 pm
Subject: RE: [RBASE-L] - A "null" variable image

I am trying to figure out how where the 
picture names/links are stored.How do you know how many picture placeholders to 
assign in the report?If you have a record in Table1 and the corresponding 
picture names are stored in Table2 on a 1 to many relationships, which I 
believe would the recommended approach, then you can create a parent and a 
child table in your report, and I will print only pictures that are available 
and not display blank placeholders.I will guess that your application is 
probable differentYou can always create a blank picture that is basically a 
blank, thin sliver and then, when you get your variables run something like 
this:IF vFilename3 IS NULL THEN  SET VAT vFilename3 = 
‘c:\BlankPic.jpg’ENDIFThis will display the blank picture that should not take 
much space.I am not sure how your data is structured in you application and 
hopefully, the above is of help.  Javier,  Javier Valencia, PE913-915-3137  
From: 'Karen Tellef' via RBASE-L  
Sent: Thursday, November 10, 2022 1:46 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - A "null" variable image  I'm guessing I have to go 
with a "null" image to display.  Certainly easier than the code to make the 
images visible or invisible.  I do not have to collapse the space, only one 
part prints on a page and the photos are at the bottom  Karen        
-Original Message-
From: Robert Thompson 
To: rbase-l@googlegroups.com
Sent: Thu, Nov 10, 2022 2:28 pm
Subject: RE: [RBASE-L] - A "null" variable imageNot sure about a setting, 
perhaps someone else is.  But if not, you might consider a "default" image that 
is  a simple white or transparent square.  Then predefine all 4 variables to 
"Default.jpg" (or what ever).  Then if you do not assign an actual image,  the 
default will always display.   No real code changes other than the variable 
filename predefault.  This would also allow you to display a default image for 
information or some other nice option.  However if you are wanting to collapse 
the print space when both image 3 & 4 are null, this would not help.  And as 
you stated, the make invisible code would work as well.      Robert ThompsonTTC 
Inc.219-363-7441     Original message From: 'Karen Tellef' via 
RBASE-L  Date: 11/10/22 1:53 PM (GMT-05:00) To: 
rbase-l@googlegroups.com Subject: [RBASE-L] - A "null" variable image   
Hopefully I can explain this.   I have attached a print-screen because my 
embedded images don't show in the list emails.  Each part we print on this 
report can have unlimited (or no) photos saved on disk.  We will print no more 
than 4 on the page, so I am pulling 4 random photos into my text variables 
(vfilename1, 2, 3, 4), and Variable Images are located.  Works great except 
when I have null variables.  As shown on the attached, vFilename1 and 
vFilename2 have values and print the photos just fine.  But variables 
vFilename3 and vFilename4 are NULL (as shown below, my null setting is actually 
' ' when printing but I changed to -0- to show you the list).    The null ones 
have that weird white/red thing.  I'm wondering if I am missing a setting for 
these.  I know I can write code to make controls invisible, but I was hoping 
I'm missing something simple.  Any clues for me?  Karen  Variable   
    = Value    Type
--   

RE: [RBASE-L] - A "null" variable image

[javier.valencia]

I am trying to figure out how where the picture names/links are stored.
How do you know how many picture placeholders to assign in the report?
If you have a record in Table1 and the corresponding picture names are stored 
in Table2 on a 1 to many relationships, which I believe would the recommended 
approach, then you can create a parent and a child table in your report, and I 
will print only pictures that are available and not display blank placeholders.
I will guess that your application is probable different
You can always create a blank picture that is basically a blank, thin sliver 
and then, when you get your variables run something like this:
IF vFilename3 IS NULL THEN
  SET VAT vFilename3 = ‘c:\BlankPic.jpg’
ENDIF
This will display the blank picture that should not take much space.
I am not sure how your data is structured in you application and hopefully, the 
above is of help.
 
Javier,
 
Javier Valencia, PE
913-915-3137
 
From: 'Karen Tellef' via RBASE-L  
Sent: Thursday, November 10, 2022 1:46 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - A "null" variable image
 
I'm guessing I have to go with a "null" image to display.  Certainly easier 
than the code to make the images visible or invisible.
 
I do not have to collapse the space, only one part prints on a page and the 
photos are at the bottom
 
Karen
 
 
 
 
-Original Message-
From: Robert Thompson mailto:ttc@comcast.net> >
To: rbase-l@googlegroups.com  
Sent: Thu, Nov 10, 2022 2:28 pm
Subject: RE: [RBASE-L] - A "null" variable image
Not sure about a setting, perhaps someone else is.
 
But if not, you might consider a "default" image that is  a simple white or 
transparent square.  Then predefine all 4 variables to "Default.jpg" (or what 
ever).
 
Then if you do not assign an actual image,  the default will always display.   
No real code changes other than the variable filename predefault.
 
This would also allow you to display a default image for information or some 
other nice option.
 
However if you are wanting to collapse the print space when both image 3 & 4 
are null, this would not help.
 
And as you stated, the make invisible code would work as well.
 
 
 
Robert Thompson
TTC Inc.
219-363-7441
 
 
 Original message 
From: 'Karen Tellef' via RBASE-L mailto:rbase-l@googlegroups.com> > 
Date: 11/10/22 1:53 PM (GMT-05:00) 
To: rbase-l@googlegroups.com   
Subject: [RBASE-L] - A "null" variable image 
 
Hopefully I can explain this.   I have attached a print-screen because my 
embedded images don't show in the list emails.
 
Each part we print on this report can have unlimited (or no) photos saved on 
disk.  We will print no more than 4 on the page, so I am pulling 4 random 
photos into my text variables (vfilename1, 2, 3, 4), and Variable Images are 
located.
 
Works great except when I have null variables.  As shown on the attached, 
vFilename1 and vFilename2 have values and print the photos just fine.  But 
variables vFilename3 and vFilename4 are NULL (as shown below, my null setting 
is actually ' ' when printing but I changed to -0- to show you the list).  
 
The null ones have that weird white/red thing.  I'm wondering if I am missing a 
setting for these.  I know I can write code to make controls invisible, but I 
was hoping I'm missing something simple.
 
Any clues for me?
 
Karen
 
Variable   = ValueType
--   --   
---
vFilename1 = F:\Quality\123773-A.jpg  TEXT  
  
vFilename2 = F:\Quality\123773-B.jpg  TEXT  
  
vFilename3 = -0-  TEXT  
  
vFilename4 = -0-  TEXT  
  
 
-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1588128635.1982897.1668106391324%40mail.yahoo.com
 

 .
-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com 
 .
To view this discussion on the web visit 

Re: [RBASE-L] - A "null" variable image

['Karen Tellef' via RBASE-L]

I'm guessing I have to go with a "null" image to display.  Certainly easier 
than the code to make the images visible or invisible.
I do not have to collapse the space, only one part prints on a page and the 
photos are at the bottom
Karen
 
 
 
-Original Message-
From: Robert Thompson 
To: rbase-l@googlegroups.com
Sent: Thu, Nov 10, 2022 2:28 pm
Subject: RE: [RBASE-L] - A "null" variable image

Not sure about a setting, perhaps someone else is.
But if not, you might consider a "default" image that is  a simple white or 
transparent square.  Then predefine all 4 variables to "Default.jpg" (or what 
ever).
Then if you do not assign an actual image,  the default will always display.   
No real code changes other than the variable filename predefault.
This would also allow you to display a default image for information or some 
other nice option.
However if you are wanting to collapse the print space when both image 3 & 4 
are null, this would not help.
And as you stated, the make invisible code would work as well.


Robert ThompsonTTC Inc.219-363-7441

 Original message From: 'Karen Tellef' via RBASE-L 
 Date: 11/10/22 1:53 PM (GMT-05:00) To: 
rbase-l@googlegroups.com Subject: [RBASE-L] - A "null" variable image 
Hopefully I can explain this.   I have attached a print-screen because my 
embedded images don't show in the list emails.
Each part we print on this report can have unlimited (or no) photos saved on 
disk.  We will print no more than 4 on the page, so I am pulling 4 random 
photos into my text variables (vfilename1, 2, 3, 4), and Variable Images are 
located.
Works great except when I have null variables.  As shown on the attached, 
vFilename1 and vFilename2 have values and print the photos just fine.  But 
variables vFilename3 and vFilename4 are NULL (as shown below, my null setting 
is actually ' ' when printing but I changed to -0- to show you the list).  

The null ones have that weird white/red thing.  I'm wondering if I am missing a 
setting for these.  I know I can write code to make controls invisible, but I 
was hoping I'm missing something simple.
Any clues for me?
Karen
Variable   = Value    Type
--   --   
---
vFilename1 = F:\Quality\123773-A.jpg  TEXT  
  
vFilename2 = F:\Quality\123773-B.jpg  TEXT  
  
vFilename3 = -0-  TEXT  
  
vFilename4 = -0-  TEXT  
  
-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1588128635.1982897.1668106391324%40mail.yahoo.com.
-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/636d510f.810a0220.9f9d.04b8SMTPIN_ADDED_BROKEN%40gmr-mx.google.com.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1444136802.2005358.1668109576636%40mail.yahoo.com.

RE: [RBASE-L] - A "null" variable image

[Robert Thompson]

Not sure about a setting, perhaps someone else is.But if not, you might 
consider a "default" image that is  a simple white or transparent square.  Then 
predefine all 4 variables to "Default.jpg" (or what ever).Then if you do not 
assign an actual image,  the default will always display.   No real code 
changes other than the variable filename predefault.This would also allow you 
to display a default image for information or some other nice option.However if 
you are wanting to collapse the print space when both image 3 & 4 are null, 
this would not help.And as you stated, the make invisible code would work as 
well.Robert ThompsonTTC Inc.219-363-7441
 Original message From: 'Karen Tellef' via RBASE-L 
 Date: 11/10/22  1:53 PM  (GMT-05:00) To: 
rbase-l@googlegroups.com Subject: [RBASE-L] - A "null" variable image 

Hopefully I can explain this.   I have attached a print-screen because my 
embedded images don't show in the list emails.




Each part we print on this report can have unlimited (or no) photos saved on 
disk.  We will print no more than 4 on the page, so I am pulling 4 random 
photos into my text variables (vfilename1, 2, 3, 4), and Variable Images are 
located.




Works great except when I have null variables.  As shown on the attached, 
vFilename1 and vFilename2 have values and print the photos just fine.  But 
variables vFilename3 and vFilename4 are NULL (as shown below, my null setting 
is actually ' ' when printing but I changed to -0- to show you the list).  





The null ones have that weird white/red thing.  I'm wondering if I am missing a 
setting for these.  I know I can write code to make controls invisible, but I 
was hoping I'm missing something simple.




Any clues for me?




Karen




Variable   = Value    Type
--   --   
---
vFilename1 = F:\Quality\123773-A.jpg  TEXT  
  
vFilename2 = F:\Quality\123773-B.jpg  TEXT  
  


vFilename3 = -0-  TEXT  
  
vFilename4 = -0-  TEXT  
  





-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1588128635.1982897.1668106391324%40mail.yahoo.com.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/636d510f.810a0220.9f9d.04b8SMTPIN_ADDED_BROKEN%40gmr-mx.google.com.

Re: [RBASE-L] - A "null" variable image

['Karen Tellef' via RBASE-L]

Jason:  You know what, I remember using that exact thing years ago for 
something.  So yeah, if there isn't something simple, I'll do that.  Thanks for 
the reminder!
Karen
 
 
 
-Original Message-
From: Kramer, Jason 
To: rbase-l@googlegroups.com 
Sent: Thu, Nov 10, 2022 1:58 pm
Subject: RE: [RBASE-L] - A "null" variable image

You could create a blank image and name it 
something like NoImage.png and then use IFNULL in your query to load it in 
place of nulls.  SELECT …(IFNULL(fieldname,’NoImage.png’,fieldname))….  This 
does not directly solve your problem but it is a low effort way around it.  
   
Thanks, 
    Jason       
|   |

   
| Jason Kramer Computing Support Specialist II University Archives and Records 
Management 002E Pearson Hall, 125 Academy St, Newark DE 19716-4399 University 
of Delaware 302-831-3127 |  fax:302-831-6903  jjkra...@udel.edu  |

      From: 'Karen Tellef' via RBASE-L 
Sent: Thursday, November 10, 2022 1:53 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - A "null" variable image    Hopefully I can explain this.   
I have attached a print-screen because my embedded images don't show in the 
list emails.    Each part we print on this report can have unlimited (or no) 
photos saved on disk.  We will print no more than 4 on the page, so I am 
pulling 4 random photos into my text variables (vfilename1, 2, 3, 4), and 
Variable Images are located.    Works great except when I have null variables.  
As shown on the attached, vFilename1 and vFilename2 have values and print the 
photos just fine.  But variables vFilename3 and vFilename4 are NULL (as shown 
below, my null setting is actually ' ' when printing but I changed to -0- to 
show you the list).     The null ones have that weird white/red thing.  I'm 
wondering if I am missing a setting for these.  I know I can write code to make 
controls invisible, but I was hoping I'm missing something simple.    Any clues 
for me?    Karen    Variable   = Value  
  Type
--   --   
---
vFilename1 = F:\Quality\123773-A.jpg  TEXT  
  
vFilename2 = F:\Quality\123773-B.jpg  TEXT  
   vFilename3 = -0-  
TEXT    
vFilename4 = -0-  TEXT  
      -- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
torbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1588128635.1982897.1668106391324%40mail.yahoo.com.
 -- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/PH7PR10MB62049AC319B990ABBFF57D41BA019%40PH7PR10MB6204.namprd10.prod.outlook.com.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1823449882.1985585.1668106846035%40mail.yahoo.com.

RE: [RBASE-L] - A "null" variable image

[Kramer, Jason]

You could create a blank image and name it something like NoImage.png and then 
use IFNULL in your query to load it in place of nulls.  SELECT 
…(IFNULL(fieldname,’NoImage.png’,fieldname))….  This does not directly solve 
your problem but it is a low effort way around it.

Thanks,

Jason


[University of Delaware]

Jason Kramer
Computing Support Specialist II
University Archives and Records Management
002E Pearson Hall, 125 Academy St, Newark DE 19716-4399
University of Delaware
302-831-3127  |  fax:302-831-6903
jjkra...@udel.edu


From: 'Karen Tellef' via RBASE-L 
Sent: Thursday, November 10, 2022 1:53 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - A "null" variable image

Hopefully I can explain this.   I have attached a print-screen because my 
embedded images don't show in the list emails.

Each part we print on this report can have unlimited (or no) photos saved on 
disk.  We will print no more than 4 on the page, so I am pulling 4 random 
photos into my text variables (vfilename1, 2, 3, 4), and Variable Images are 
located.

Works great except when I have null variables.  As shown on the attached, 
vFilename1 and vFilename2 have values and print the photos just fine.  But 
variables vFilename3 and vFilename4 are NULL (as shown below, my null setting 
is actually ' ' when printing but I changed to -0- to show you the list).

The null ones have that weird white/red thing.  I'm wondering if I am missing a 
setting for these.  I know I can write code to make controls invisible, but I 
was hoping I'm missing something simple.

Any clues for me?

Karen

Variable   = ValueType
--   --   
---
vFilename1 = F:\Quality\123773-A.jpg  TEXT
vFilename2 = F:\Quality\123773-B.jpg  TEXT
vFilename3 = -0-  TEXT
vFilename4 = -0-  TEXT

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1588128635.1982897.1668106391324%40mail.yahoo.com.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/PH7PR10MB62049AC319B990ABBFF57D41BA019%40PH7PR10MB6204.namprd10.prod.outlook.com.

[RBASE-L] - Tip of the Day: Form Designer Productivity Tips

[A. Razzak Memon]

Thursday, November 10, 2022

Tip of the Day: Form Designer Productivity Tips
Product...: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.: 10.5.5.11013 or higher
Sections..: Forms

Below are valuable tips to help get the most productivity out of the 
R:BASE Form Designer:


 . When the Form Designer is launched the main menu bar includes 
options specific to the designer: Form, Edit, View, Layout, Table, and 
Variables.


 . When initially designing the form, you should create and place the 
objects within a form so that is suitable for users with various screen 
resolutions, preferable starting at 1024x768, as you never know the end 
users' preferences.


 . After objects are placed, and then is selected, small blue circles 
appear around the four corners and four sides; called handlebars. When 
more than one object is selected, red square handlebars are displayed. 
The handlebars are extremely useful for editing the properties of more 
than one object or moving more than one object. Hovering your cursor 
over the handlebars for an individual object changes the pointer to a 
double arrow. Holding down the left mouse button with the double arrow 
lets you stretch or shrink the object.


 . Multiple objects can be selected with the mouse cursor by lassoing 
objects. The lasso appears as a dotted line while you drag the mouse 
cursor. It works by starting in one corner of the work space, holding 
down the left mouse button, and dragging the cursor to the opposite 
corner. The lasso only needs to be touching the object in order to 
select it for editing. When lassoing multiple objects that are contained 
within a parent object, such as a panel, press and hold the [Ctrl] key 
to lasso the objects.


 . Right clicking on an object will display the context menu options. 
The context menu will vary based upon the selected object.


 . The properties for all field objects can be edited by right clicking 
on the object and selecting "Object Property" from the context menu, or 
by selecting the object and pressing the [F11] key on the keyboard. Each 
object's properties vary depending on the type of control.


 . Use the [Shift+Right Arrow], [Shift+Left Arrow],[Shift+Up Arrow] or 
[Shift+Down Arrow] key combinations to increase width, decrease width, 
increase height or decrease height of any individual control or group of 
selected controls.


 . Use the [Ctrl+Right Arrow], [Ctrl+Left Arrow],[Ctrl+Up Arrow] or 
[Ctrl+Down Arrow] key combinations to accurately move any individual 
control or group of selected controls.


 . You can cut, copy and paste one or more form controls at a time, 
either in the same form or between different forms. It is important to 
note that when using copy and paste for form objects, the control being 
copied will retain the Top, Left, Height and Width coordinates. This 
logic is in place by design for the purpose of moving a control from one 
form to another, where the control will appear in the same location with 
the same size. This means when you copy an object that is is defined 
with 800 pixels as the Left value, and paste it into a small Panel with 
a 400 pixel width, the newly pasted object is another 400 pixels beyond 
the panel's border, and not visible. Pressing the [Ctrl+Left Arrow] keys 
will place the object where it is visible.


 . You can paste external content (text, rich text, images) directly 
into the Form Designer from the Windows clipboard.


 . When adding several of the same type of object, select the "Sticky 
Control" on the "Settings" toolbar. This will allow you to add the same 
type of control until the "Sticky Control" is un-selected, preventing 
several mouse click steps.


 . Tables can be added and removed from forms by selecting "Tables: 
Add/Remove Tables" from the main menu bar. Table relationships and 
settings may be altered in the area as well.


 . You can test how your form will look by running it right from the 
designer. From the menu bar, choose "Form: Run Form". Press the [Esc] 
key to return to the designer, as long [Esc] is not disabled within the 
form's properties.


 . The order in which you place objects on a form is the tab order in 
which the focus moves when pressing [Tab]/[Enter] when running the form. 
After making design changes to a form, check the tab order by choosing 
"Layout: Change Tab Order" on the menu bar. The "Tab Order Settings" 
dialog will appear with the objects on the form listed by "Control Type" 
and the field properties.


 . The Display Format window allows users to customize the Display 
Format Mask for Database (DB) Controls. To add/modify an object's 
display format, choose "Tables: Display Format..." from the menu bar.


 . The Default Values window allows users to specify a default value 
for the field when the form is used in the enter mode for Database (DB) 
Controls. The value #DUP can also be placed in the Current Default Value 
field to duplicate the value when entering