Printing question

[Dave Herndon]

Hi, 
I am having an interesting problem.  Recently one of the computers on my 
network started getting a "Sorry for the Inconveniance but Revolution must shut 
down." message while attempting to execute the print code shown below on 
several printers available from that workstation.  The print job worked fine 
for the 6 months prior. The print process works fine on the computer in the 
adjacent work station on each of the available computers.  A reboot and closing 
all open applications does not help.  We are printing from a standalone built 
in rev 2.7.3 on windows PC's.  What do you think guys?  

answer printer
set the printmargins to 20,20,20,20 -- 2" on top and bottom
set the printScale to .75
print this card

I am stumped.
Dave
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Help. How do you insert a custom icon into your standalone?

[Dave Herndon]

I have searched all over the internet and tried choosing an icon in the 
standalone settings screen but of all the hundreds of icons that I have found 
none have passed the criteria of Rev.  Is there an easy way to choose an Icon 
so I don't have to use the blank square of an Icon I get from Rev ?  There has 
to be an easy way to do this.

Dave
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Trouble with sub stacks

[Dave Herndon]

I have a mainstack that serves as the main view of my database and I edit the 
database by hiding and showing modal substacks.  When I hide the substack I am 
able to use the command.
  on mouseUp
  hide stack "EditWindowSubstack" 
  go to card 1 of stack "mainstack"
  PerformRefreshDbHandlerInStackScript
  end mouseUp
   
  However when I open a modal substack as a secondary view of the database  say 
"secondViewSubstack" and then open the same "EditWindowSubstack" as an edit 
tool on top ot it when it closes it wont alow me to use the 
  go to card 1 of stack "secondViewSubstack"  OR
  send a mouseup command to the "secondViewSubstack"
  I am not closing the "EditWindowSubstack" I am just hiding it and I can't use 
the set defaultstack because to ends up in an endless loop asking me if I want 
to purge the old one before opening the new one.  I tried using the 
lockmessages command still no good.  Any ideas ?  I just want to run a handler 
to refresh the screen once I edit the database.  I have to physicaly click on 
the screen to activate a send mouseup message of a go to message on that open 
substack once I close the other one.
  Thanks Dave
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Getting data prepped for database entry.

[Dave Herndon]

  This script pretty much gets the job done.  Stripps unwanted spaces before 
and aft, changes mixed or small caps to ALL CAPS, and makes ready the data for 
SQL data entry by wrapping the list items with 'singlequotes'  
   
  on mouseUp
  put field "data" into MyList
  repeat with x = 1 to the number of items of MyList
  put word 1 to -1 of item x of Mylist into item x of Mylist
  put "'" & item x of Mylist & "'" into item x of mylist
  end repeat
  put the toUpper of Mylist into MyList
  put Mylist into field "recip"
  end mouseUp
  the script changes 
  davo, davo , davo Herndon , davo,davo,davo , davo , davo, 
   TO
  'DAVO','DAVO','DAVO HERNDON','DAVO','DAVO','DAVO','DAVO','DAVO',
   
  Now if I can just check to see if the item is a number or a date and not do 
the single quote operation on those items I will be set.  As a work around I  
have beem carefull to leave those items as the last items in the list and do a 
partial operation, say there are 6 items in the list to be added to a database 
record and the last two items are dates. 
   
  as in varchar1,varchar2,varchar3,varchar4,date1,date2
   
  repeat with x = 1 to 4
  put "'" & item x of Mylist & "'" into item x of mylist
  end repeat
  returns 'varchar1','varchar2','varchar3','varchar4',date1,date2
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Subject: Re: Stripping blank spaces before and after a word. Help

[Dave Herndon]

Thanks Mark,
  I settled on this and it works SWT !  Thanks For your help.  Now to 
finish it up.  Anybody have a good way to convert all text in a list to ALL 
CAPS?  It would be nice to get a consistent look in the database.  Here is the 
script I settled on.
   
  repeat with x = 1 to the number of items of MyList
  put word 1 to -1 of item x of Mylist into item x of Mylist
  end repeat
   
  Then I run another script to turn MyList containing mydata1,mydata2,mydata3, 
into 'mydata1','mydata2','mydata3' for entry int the databse.  Perhaps I can do 
it all in the same repeat loop.  Get rid of the spaces, change the text to all 
caps and then wrap the data in 'single quotes' for SQL data entry if the data 
is not a number or a date.  Anybody wanna throw down on this one?
   
   
  Mark Wrote Dave,
I think you are looking for something like this

repeat for each item myVar in "var1,var2,var2"
   do "put word 1 to -1 of" && myVar && "into" && myVar
end repeat

or

repeat for each line myLine in fld 1
   put (word 1 to -1 of myLine) & cr after myList
end repeat
put word 1 to -1 of myList into fld 1

Best,

Mark

> Does anyone have a handy little script that could be put in a  
> repeat loop to evaluate either the contents of several fields, or a  
> comma delimitered list of variables, and strip any blank spaces  
> that may or may not exist from before and after the contents. To  
> ready the data for insertion into a database.  I am having an issue  
> with data being entered with spaces before of after the words,  and  
> then not showing up in a data query because of that.
>   I usualy insert the datra from several fields into a list such as
>   var1,var2,var3, etc before entering it into a database.
>   Thanks
>   Dave



___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Stripping blank spaces before and after a word. Help

[Dave Herndon]

Does anyone have a handy little script that could be put in a repeat loop to 
evaluate either the contents of several fields, or a comma delimitered list of 
variables, and strip any blank spaces that may or may not exist from before and 
after the contents. To ready the data for insertion into a database.  I am 
having an issue with data being entered with spaces before of after the words,  
and then not showing up in a data query because of that.  
  I usualy insert the datra from several fields into a list such as
  var1,var2,var3, etc before entering it into a database.
  Thanks
  Dave
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

my Variable watcher no longer appears in debug mode

[Dave Herndon]

This has got me bugging.  Two or three days now and I havent been able to bring 
up the VW window in debug mode. (v2.73) I am thinking of re-downloading rev to 
see if that helps.  Any ideas?  It just is no where to bee seen!  Wierd.
  Dave
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

RE Loading a button with Time

[Dave Herndon]

WOW !  John Craig's script made mine look STINKY !!  I made a couple changes to 
it to suit my needs.  It now formats the contents to load dirrectly into a 
cascading style pull down button so it is easy to select the time you want.  I 
reformated the script to span 24 hours and maintain a military 0800 style 
format.  This will make it easy to quickly change the increments.  Some 
agencies round to the quarter hour and others to the 5 or 10 minute mark so 
very cool.  Thanks John !  Here is the revised script. Uses three fields to 
spec the operation and a pull down menu button which gets loaded with 288 lines 
of time increments spanning from  to 2400 hrs . 
  Field "Start1" = 0:05 AM, "end1" = 11:55 pm , "Int1" = 5
  the pull down menu is "Time Menu"
  Put the script below into the "Load" button script
   
  on mouseUp
  put fld "start1" into tStart
  put fld "end1" into tEnd
  put fld "int1" into tInterval 
  put empty into tData 
  convert tStart to dateItems 
  convert tEnd to dateItems
  put item 4 of tStart * 60 + item 5 of tStart into tStartSecs
  put item 4 of tEnd * 60 + item 5 of tEnd into tEndSecs
  put tStartSecs into tSecs
  repeat while tSecs <= tEndSecs
  put tSecs into tTime
  convert tTime from seconds to dateItems
  put item 5 of tTime into tHour
  put item 6 of tTime into tMin
  if tdata <> empty then put return after tdata
  if the number of chars of tHour < 2 then put "0" & tHour into tHour
  if tMin is "00" then put tHour & ":" & format ("%02d", tMin) & return after 
tdata
  put tab & tHour & ":" & format ("%02d", tMin) after tData
  add tInterval to tSecs
  end repeat
  put return & tab & "24:00" after tData
  put tData into button "Time Menu"
  end mouseUp 
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re Subject: Adding Time

[Dave Herndon]

  Regarding >
  >Can anyone steer me in the correct direction for this?  What I need to
>o is populate a list box with times at specific intervals.  i.e.
 >
>I have a input box for the start time say 8:00 A.M.
>I have a input box that has a stop time say 5:00 P.M.
>I have a input box that has an interval say 5 minutes.
 
>What I want to do is populate a list box with:
 
>8:00 A.M.
>8:05 A.M.
>8:10 A.M.
>etc.
>etc.
The script below worked for me.  It returns the format below for a 24 hour 
period at 15 min intervals.  I had to do some minor editing to it to get 
perfect before I inserted it as the contents of a button.  I'm not proud of the 
script but it got the job done for me.  If you need the script that compares 
the difference between two of these numbers and compares them against a 24 hour 
period let me know.  Comparing say 0800 and 1315 and returning 5.25 Hrs.  I am 
a Firefighter and we work 24 hour shiftso I use the script often.
  script returns...
  
  0015
  0030
  0045
  0100
  0100
  0115
  0130
  0145
  0200
  0200
  0215
  up to 2400 hrs
   
  on mouseUp
  put 0 into daTime
  put "" into line 1 of field "hr select"
  repeat with x = 2 to 119
  put daTime + 15 into DaTime
  if DaTime is "60" then
  put "100" into daTime
  put DaTime into line x of field "hr Select"
  add 1 to x
  put tab & DaTime into line x of field "hr Select"
  next repeat
  end if
  if the number of chars of daTime < 4 then
  if char 2 to 4 of DaTime is "60" then
  put "00" into char 2 to 4 of DaTime
  put char 1 of daTime + 1 into char 1 of daTime
  end if
  else
  if char 3 to 5 of DaTime is "60" then
  put "00" into char 3 to 5 of DaTime
  if char 2 of daTime is "9" then
  put "2000" into daTime
  put DaTime into line x of field "hr Select"
  add 1 to x
  put tab & DaTime into line x of field "hr Select"
  next repeat
  end if
  put char 2 of daTime + 1 into char 2 of daTime
  end if
  end if
  if the number of chars of daTime > 2 then
  if char 2 to 3 of DaTime is "00" then
  put DaTime into line x of field "hr Select"
  add 1 to x
  put tab & DaTime into line x of field "hr Select"
  next repeat
  end if
  end if
  if the number of chars of daTime > 3 then
  if char 3 to 4 of DaTime is "00" then
  put DaTime into line x of field "hr Select"
  add 1 to x
  put tab & DaTime into line x of field "hr Select"
  next repeat
  end if
  end if
  put tab & DaTime into line x of field "hr Select"  puts all the times 
into a field called hr select
  end repeat
  end mouseUp
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

managing sqlight3 permissions help

[Dave Herndon]

I have developed some powerfull database editing features in my revolution 
front end.  I realize that the find and replace feature that I set up in one of 
my substacks could if used in properly alter the database in a huge way.  So 
now I am wondering if I should just limit access to that sub stack via the ask 
password clear command or set permissions for all users as they connect to the 
database.  I would like to say limit a bulk of the users to just the SELECT 
command, give others use of the INSERT and UPDATE command etc.  Can I do this 
by setting one of the parameters in the connect string on log in ?  I just 
added a password column to my staffing table and may be experimenting with a 
script to check and change this value.  Any ideas?  
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

RE Print problem

[Dave Herndon]

I havent run across your exact problem however I have had a problem with fields 
that have the text baseline feature selected in the table objects section of 
the field preferences.  When I have print problems I create a new blank stack 
and run my print commands on it.  If the blank stack prints ok then  I start 
stripping fields and buttons off a copy of the stack in question and past them 
for later use into the new blank stack I keep selecting print until i get it to 
print.  Then I start adding the felds and buttons back on until it no longer 
prints again.  Throught the process of elimination I find the problem and it 
usualy only takes about 15 min.  You may be having a code problem that rev has 
a hard time with.  hope this helps
  Dave
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Trouble setting a substack to topstack Help please.

[Dave Herndon]

Situation.  Three stacks.  A MainStack and two SubStacks.  MainStack queries 
data from the dabase on start up.  Substack1 is a small stack that is hidden.  
It is called from the mainstack with the modal SubStack1, show SubStack1 
commands. It pops up data is then manipulated and then re-inserted back into 
the database.  Before Substack1 is hidden it calls a handler in the mainstack 
to refresh the main stack's screen with another database query.  Everything 
works sweet.  
   
  Now look at a similar situation.  Mainstack calls substack2 with the modal 
substack2, show substack2 commands.  Substack2 is a bit larger window that pops 
on top of the mainstack and rup runs a different query to show a different view 
of the same data.  Substack2 now calls substack1 with the modal substack1, show 
substack1 commands because it wants to edit the data.  It pops up fine and data 
is re-inserted into the database. Now comes the problem...  I cant get the 
screen in substack2 to refresh with the same method as the mainstack.  Sending 
mouseup to the refresh button in substack2 or calling a handler in the stack 
script of substack2 cant be done because the topstack reverts back to the 
mainstack as soon as substack1 is hidden. Setting the topstack to substack2 
only works if i use the path 
  ( set the topstack to "substack2 of stack mainstack.rev" )
  which is immediatly followed by a message that says "before you open 
"mainstack.rev" what do you want to do with "mainstack" ?  Purge,save or 
cancel.  I havent had any luck with placing the refresh screen handler in the 
mainstacks script either.  Any ideas.  I have been farting around with this 
from every angle for about 4 hours.  If you click on the refresh button in 
substack2 after every change it works fine but I'm sure their is a way to get 
this to refresh automaticly.  Also I have a database dissconect script in the 
mainstack and when I close the stack it gets executed three times.  One time 
for each one of the three stacks.  This causes an error.
  Thanks
  Dave
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Printing Problem with Rev HELP

[Dave Herndon]

I converted over some stack from  rev 1.1 to 7.3 and I went through a process 
of slowly stripping down the stack until I could get it to print.  The culprit 
seemed to be fields with the table object feature chosen and the Baseline text 
feature chosen.  It would bomb revelution every time.  Once removed it prints 
no problem.  Then I went to the clients network loaded the stacks on the file 
server with my standalone engine on the local HD.  Print command bombs rev 
every time.  I am thinking it may be the printscale .50 command or ?  It prints 
on my laptop fine and it prints on another clients network no problem. Any 
sugestions. 
   
   Also. I have had a problem which I have worked around now for a couple years 
now.  Same set up with files on server and standalone on each local hard drive. 
 I can't save the files to the server.  I have to set the defaultfolder to the 
hard drive, save the file there and then rename it back to the file server 
location.  If I try and save it on to the folder on the file server it times 
out.  Do ya think its looking for the engine ?
   
  Your help appreciated
  Dave
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

MS SQL Connectivity ?

[Dave Herndon]

Anyone know of a way to open a database connection with a MS SQL server 
database from within revolution ?  The same string that works for SQlight which 
includes the username, password, etc doesn't work for MS SQL Server.  I have 
however obtained success by entering my username and password in the ODBC 
settings in the Windows administrative tools control pannel.  Then the 
connection string works.  But I would rather not have to mess with this on 
every client computer.
  Any answers ?
  Dave
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Simple question

[Dave Herndon]

What is the best way to open a "splash style " stack from a standalone to load 
some global variable info  for use by the standalone.  I used the open stack 
"splash" command from the standalones openStack handler and then close stack 
"splash"  after a couple seconds but the first time I use a pull down button in 
the standalone that contains the contents of the global variable  it launches 
the splash stack again for a few seconds.  Just wondering what the cleanst way 
to do this is ?  Do i need to purge the splash stack after closing it ?
   
  Dave
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Button Icons wont show up when powered by my standalone

[Dave Herndon]

Hi
  Little help here.  I am developing a fire department application in rev 
2.7.3.  I realy liked the haz mat barrel button icon in the metacard icons 
listed.  When I build my standalone in windows the icons show up black when I 
open the file with my standalone.  I have been racking my brains trying to 
figure out where in the standalone settings I can make sure that resource gets 
added to the standalone.  Little help ?
  Dave
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution