RE: [EXTERNAL] [RBASE-L] - EXPORT bmp FROM rbase TO EXTERNAL FOLDER

ursor1 CLS Dan Goldberg From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> Sent: Tuesday, July 2, 2024 6:24 AM To: RBase Maillist mailto:rbase-l@googlegroups.com>> Subject: [EXTERNAL] [RBASE-L] - EXPORT bmp FROM rbase TO EXTERNAL FOLDER How can I export BMP

[RBASE-L] - EXPORT bmp FROM rbase TO EXTERNAL FOLDER

How can I export BMP files within RBASE to a folder on my hard drive? The gatway export does not have the BMP as an option when exporting using that app. I see one can save each individual BMP to an outside location as a BMP, but that is manual and very time consuming. Any help would be

[RBASE-L] - temp view error

I create a temp view (uses two tables with common columns) that is used as the driving table in a report. In the past, I never had this error show up. These are var created within the report. [A screenshot of a computer Description automatically generated] I use a var that bring up a DATE and

RE: [RBASE-L] - email novice problems

Jim, Try adding a line for the attachment. You may want to set the attachment as a variable with the complete location. Example: Set var vfilename TEXT = 'complete location_1031.PDF' |EMAIL_ATTACHMENTS Try something like this and see what happens. Jim From: 'jim schmitt' via RBASE-L Sent:

RE: Re[2]: [RBASE-L] - Printing spreadsheets

Karen, Try this. GATEWAY EXPORT XLSW + .. set up location of your file here xlsx + SELECT * FROM (table you created with the info) + OPTION COL_NAMES ON + |SHEET_INDEX 1 + |RAW_GEN ON + |BLANK_IF_NULL ON + |BLANK_IF_ZERO OFF + |SHOW_PROGRESS ON + |MERGE_DATA ON + |TAB_NAME ( name of tab in

RE: Re[4]: [RBASE-L] - GATEWAY IMPORT Fail

| SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 | USA +011 (909) 238-9012 m | rby...@safesectors.com<mailto:rby...@safesectors.com> -- Original Message -- >From "'Jim Belisle' via RBASE-L" >mailto:rbase-l@googlegroups.com>> To "rbase-

RE: Re[2]: [RBASE-L] - GATEWAY IMPORT Fail

The file path set to a var is normally better because you do not have to worry about spaces, etc. At least that has helped me with my RGW spec code. James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D92676.6DA979C0] From: rbase-l@googlegroups.com On

RE: Re[2]: [RBASE-L] - GATEWAY IMPORT Fail

Bruce, I set my file to be used in a variable then use this code. GATEWAY IMPORT CSV + APPEND tdaytable OPTION SPECIFICATION_FILE_NAME daytemp.RGW This should work for you. James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D92676.44AFAB20] From:

RE: [RBASE-L] - weird form situations

: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> To: RBase Maillist mailto:rbase-l@googlegroups.com>> Sent: Thu, Jan 12, 2023 9:06 am Subject: [RBASE-L] - weird form situations I do not think this is specifically an RBASE problem but it is affecting RBASE and I am trying

RE: [RBASE-L] - weird form situations

SCRATCH setting is within RBase. What do you have that set to in your app? I would check to make sure that that setting is still accurate Karen -Original Message- From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> To: RBase Maillist mailto:rbase-l@googlegrou

[RBASE-L] - weird form situations

I do not think this is specifically an RBASE problem but it is affecting RBASE and I am trying to get ideas from you about what our IT people should look for. Last night the IT company we use did a server reboot. This morning we are now experiencing strange behavior with some of our forms,

[RBASE-L] - Gateway

I am trying to Export information with Gateway to an Excel file from temp files created in RBASE. When I create a temp table for the order header information, these columns are primarily TEXT, INTEGER and a few NUMERIC, things go well and all information exports properly. All the columns are in

RE: [RBASE-L] - Timing of Evaluations of Variables Defined By Expression Builder

Jim, I would think that if you ran the form in the trace mode and used the "watch variable" function, that would show you when the variables are evaluated and changed. I use that often to make sure things are working in the proper order. Jim -Original Message- From:

[RBASE-L] - Export to a specific sheet in Excel

Is there a way to export RBASE info into a specific sheet within an Excel file? James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D7F732.74A031C0] -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this

RE: [RBASE-L] - Update on R:BASE Community Groups

Thank you, Razzak. James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D7F169.4A698B50] From: rbase-l@googlegroups.com On Behalf Of A. Razzak Memon Sent: Tuesday, December 14, 2021 8:21 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Update on R:BASE

RE: [RBASE-L] - Announcement: R:BASE "Community" Facebook Group

Thanks, Bill. That is a great link. But I think that some of the list are not sure that using a Facebook group will be as user friendly when it comes to saving threads into folders like you can do with an email account. And as someone already pointed out, some do not want to have Facebook on

RE: [RBASE-L] - X.5E Upgrade woes

ached a screen snip from the form and my variables, then one from the formatting of the field, then one of my eep. The eep doesn't work because my dashes are not in vssnum. On Saturday, December 4, 2021, 12:24:13 PM EST, 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> w

RE: [RBASE-L] - X.5E Upgrade woes

esn't have to enter it. But it suddently has no dashes until after we hit save. On Saturday, December 4, 2021, 11:39:03 AM EST, 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> wrote: Patti, Some questions: 1. Is the entry person entering the info using just the numerical S

RE: [RBASE-L] - X.5E Upgrade woes

Patti, Some questions: 1. Is the entry person entering the info using just the numerical SS#. Ex. I enter 123456789 but the form is formatted so it shows 123-45-6789. 1. Does the table field where the SS# is saved also have the same format so the info will always show the numerals with

RE: [RBASE-L] - Comparing R:Base Tables

] - Comparing R:Base Tables Jim, Thanks for the response. Myron and Jim From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> Sent: November 16, 2021 7:25 AM To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> Subject: RE: [RBASE-L] - Comparing R:Base Tables If you wa

RE: [RBASE-L] - Comparing R:Base Tables

If you want to browse the info in table1 you could use BROWSE * FROM table1 WHERE 'fieldname' NOT IN (SELECT 'fieldname' FROM table2) That should give you what you want. James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D7DAC3.26FCD260] From:

RE: [RBASE-L] - Exporting to Excel

. However you probably can avoid this error using the option 'Without using Excel' The advantage of this option is that the availabilty of Excel is not needed anymore and it is also very fast. Tony Op 11-11-2021 om 05:14 schreef 'Jim Belisle' via RBASE-L: Has anyone run into a problem when

RE: [RBASE-L] - Moving variables between reports

Javier, I followed Razzak’s instructions and was able to copy ALL the var to a new report with no problem at all. This below was the original report variables. I used the copy icon in the expression builder. [cid:image001.png@01D7AE49.E57AE0C0] [cid:image002.png@01D7AE49.E57AE0C0] Less than 15

RE: [RBASE-L] - R:Mail question

Tony, Did you have to download a newer version (TLS 1.2) from the Internet? I still have my CFG file set to TSL 1 James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D78321.443A2660] From: rbase-l@googlegroups.com On Behalf Of Tony Luck Sent: Tuesday, July

[RBASE-L] - RE: scrolling region property commands

that take the place of a component ID when using a DB grid. James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D774D1.62EB1780] From: 'Jim Belisle' via RBASE-L Sent: Friday, July 9, 2021 9:20 AM To: rbase-l@googlegroups.com Subject: [RBASE-L] - scrolling region

[RBASE-L] - scrolling region property commands

For years code I use in the on after start EEP of a form has worked in setting focus to the scrolling region and a specific field in the scrolling region when certain criteria has been met. The code uses PROPERTY commands to perform this task. Earlier this year all of a sudden this code

RE: [RBASE-L] - RBGX5E Server Requirements

I agree with Javier about using the compiled application. We use the compiler and run anywhere from 20 to 30 users at any one time during the busy work day (down to less than 10 in the evenings). We have had speed issues in the past as many on this list know if you have followed my questions.

RE: [RBASE-L] - edit table using aliases

SSAGES ON And see what error you get and go from there. Javier, Javier Valencia, PE javier.valen...@vtgonline.com<mailto:javier.valen...@vtgonline.com> O: 913-829-0888 C: 913-915-3137 From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> Sent: Thursday, March 4, 2021 5

RE: [RBASE-L] - edit table using aliases

From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> mailto:rbase-l@googlegroups.com>> Sent: Thu, Mar 4, 2021 5:16 am Subject: RE: [RBASE-L] - edit table using aliases I tried all the suggestions, removed t

RE: [RBASE-L] - edit table using aliases

+ |COLUMN_WIDTH[3] 50 + |COLUMN_WIDTH[4] 50 ..and it should work…I think.  Javier, Javier Valencia, PE javier.valen...@vtgonline.com<mailto:javier.valen...@vtgonline.com> O: 913-829-0888 C: 913-915-3137 From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> Sent: Wednes

[RBASE-L] - edit table using aliases

I am using the syntax given in the help in an attempt to edit a table using alias column names. This is the syntax I am using. EDIT + model# AS `Model Number`, + kprsellpw AS `KPR List Price`, + proddesc AS `Product Description`, + modelwgtpw AS `Weight`, + sortonepw AS `Prod Line`, + sorttwopw

RE: [RBASE-L] - Table browsing

Do you have a date field where you can DELETE based on the date? James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D6FA49.C9823A80] From: rbase-l@googlegroups.com On Behalf Of IT Man Sent: Wednesday, February 3, 2021 4:20 PM To: rbase-l@googlegroups.com

RE: Jan [RBASE-L] - Help - first time sending report via email

get them a new database, probably something other Healthy Start sites are using, though they are terrible, I'm starting a different thread with a new question, printing to a URL on OneDrive. Patti On Friday, January 29, 2021, 10:44:04 PM EST, 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegrou

RE: [RBASE-L] - Help - first time sending report via email

We have office 365 and use RMAIL. It took a little trial and error but we got it to work. We use version X5E. James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D6F687.D906D5D0] From: 'Karen Tellef' via RBASE-L Sent: Friday, January 29, 2021 10:54 AM To:

RE: [RBASE-L] - new to drag and drop

depending on what process you need to carry out. Hope this helps out.. On Tue, Jan 19, 2021 at 9:04 AM 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> wrote: Okay. I was able to do that with this code GETPROPERTY comp_pneed VISIBLEROWCOUNT 'vcr' Then I want to SELECT values (7 o

RE: [RBASE-L] - new to drag and drop

on the unique ID i.e. APPEND tablerow TO newtable where uniqueID = .Vvariable This will DROP the row to the other table. Use the property commands to refresh table or list depending on what process you need to carry out. Hope this helps out.. On Tue, Jan 19, 2021 at 9:04 AM 'Jim Belisle' via RBASE-L

RE: [RBASE-L] - new to drag and drop

be able to set a variable for the uniqueID row you click on. Then right your code as to what you want it to do From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> Sent: Monday, January 18, 2021 5:42 PM To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>

RE: [RBASE-L] - new to drag and drop

clicking on any links or opening attachments. Jim Right click on DBGrid then enable Drag and Drop should be near the bottom. You will see Start Drag (EEP) and Drop Drag (EEP) Buddy From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> Sent: Monday, January 18, 2021 5

[RBASE-L] - new to drag and drop

I am new to drag and drop so not sure how to "GRAB" a row from a DBGrid. The DBGrid is in the row select mode so I can grab a row. Also the record count on the left is on so I have the row number. How does one identify the specific row you want to grab? In RDOCS I do not find a PROPERTY command to

RE: [RBASE-L] - enhanced tab control

Yes. I will be signing off for now. Thanks for your suggestions and questions. From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: Monday, January 18, 2021 8:36 AM To: 'Jim Belisle' via RBASE-L Subject: RE: [RBASE-L] - enhanced tab control Is your 'PROPERTY' code in the 'tab change

RE: [RBASE-L] - enhanced tab control

, 2021 8:08 AM To: 'Jim Belisle' via RBASE-L Subject: RE: [RBASE-L] - enhanced tab control Jim, Are you using a temp table to display the data in the db-grid? If so, why not just drop the table, and reload it with only the rows you need. Jan From: "'Jim Belisle' via RBASE-L" mail

RE: [RBASE-L] - enhanced tab control

m: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: Monday, January 18, 2021 7:30 AM To: 'Jim Belisle' via RBASE-L Subject: Re: [RBASE-L] - enhanced tab control CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. Jim, This might be a l

[RBASE-L] - enhanced tab control

I am using the enhanced tab control for the first time. I want to use the var links editor to capture the tabs caption value. It is also the first time for me to use the links editor. [cid:image001.png@01D6ED64.ADDF1880] The value of vtabcap is not changing and I get an error saying the var has

[RBASE-L] - RE: enhanced DB grid

or opening attachments. Form setting has a checkbox to turn it off Dan Goldberg MIS Manager Lance Campers From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> Sent: Friday, January 15, 2021 8:36:09 AM To: rbase-l@googlegroups.com<mailt

[RBASE-L] - enhanced DB grid

Is there a PROPERTY command for the enhanced DB grid that prevents this box from coming up when you make a change in a row? [cid:image002.png@01D6EB2A.3C00D690] James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D6EB24.4CF47ED0] -- For group guidelines,

[RBASE-L] - RE: convert text to time data type

Try this. Use the strip function (SSTRIP(source, chars)) to strip the space and the AM or PM from the text. Ex. SET VAR vstrip TEXT = (SSTRIP(8:00 AM, ' APM')) Then set the next var to TIME this var. EX. SET VAR vtime TIME = .vstrip James Belisle Making Information Systems People Friendly

RE: [RBASE-L] - dbgrid not showing all rows

12:39 PM To: 'Jim Belisle' via RBASE-L Subject: Re: [RBASE-L] - dbgrid not showing all rows CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. James, I'm not going to say this correctly. If you have have 2 rows with a duplicated column, no rows

[RBASE-L] - dbgrid not showing all rows

I am sure I am missing something simple but here is the problem. I am adding a DB grid to a form based upon a temp table. When the grid is visible with a property command all that shows are the first two rows. When I look at the temp table, all rows are there. James Belisle Making Information

RE: [RBASE-L] - VAR LOOKUP LISTVIEW

, 2021 at 4:02 AM 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> wrote: I noticed there is an effect (on the variable list view control) of show check boxes. However I do not see the purpose of the check boxes. I see no EEP available that relates specifically to the checked boxes

[RBASE-L] - VAR LOOKUP LISTVIEW

I noticed there is an effect (on the variable list view control) of show check boxes. However I do not see the purpose of the check boxes. I see no EEP available that relates specifically to the checked boxes. 1. So what is the purpose of having the check boxes? 2. Is there a way to assign

RE: Re[2]: [RBASE-L] - autonum when creating

rby...@safesectors.com> --- +011 (909) 238-9012 c +011 (909) 912-8678 f -- Original Message -- From: "jan johansen" mailto:j...@jjcalibrations.com>> To: "'Jim Belisle' via RBASE-L" mailto:rbase-l@googlegroups.com>> Sent: 12/24

RE: [RBASE-L] - autonum when creating

To: 'Jim Belisle' via RBASE-L Subject: Re: [RBASE-L] - autonum when creating James, Sorry for not replying. However the sun was shining after days with a lot of rain. So I took my bike and went to the local river (The IJssel in Holland) to get some fresh air. Jan was right with autonum. What I

[RBASE-L] - task scheduler

I am new with the task scheduler. I added information to the temp table I am using for the scheduler. However when in the design mode and hit the RUN button, all the entries go back to 1899. I guess I have many questions on this but the first one is regarding the fields. 1. I have a date

RE: [RBASE-L] - autonum when creating

RBASE-L Subject: RE: [RBASE-L] - autonum when creating Jim, Yes. The AUTONUM is issued after the table is created and before you insert data. Jan From: "'Jim Belisle' via RBASE-L" mailto:rbase-l@googlegroups.com>> To: "rbase-l@googlegroups.com<mailto:

RE: [RBASE-L] - autonum when creating

. AUTONUM IN USINGNUM Tony Op 24-12-2020 om 14:27 schreef 'Jim Belisle' via RBASE-L: What is the proper syntax for creating a column within a temp table as an auto numbered column? James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D6D9C9.8695DAB0

[RBASE-L] - autonum when creating

What is the proper syntax for creating a column within a temp table as an auto numbered column? James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D6D9C6.3789D460] -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php ---

RE: [RBASE-L] - Query

23, 2020 11:44 AM To: 'Jim Belisle' via RBASE-L Subject: RE: [RBASE-L] - Query Duh, Thanks Jim. Merry Christmas! Jan From: "'Jim Belisle' via RBASE-L" mailto:rbase-l@googlegroups.com>> To: "rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>" mailto

[RBASE-L] - RE: out of sync

Subject: [RBASE-L] - RE: out of sync CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. RBSYNC dbname EXECUTE Dan Goldberg From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> Sent: Wednesday, December 23, 2020 9

[RBASE-L] - out of sync

We just had an Internet outage and it cause RBASE to get corrupted. Now the RX4 file is out of sync. I have RSCOPE and it shows an index error. How does one go about getting the RX4 file back in sync with the others. I cannot connect to the DB to do any kind of rebuild or pack. James Belisle

RE: [RBASE-L] - Query

BROWSE table1 WHERE common col info NOT IN (SELECT common col info FROM table2) James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D6D91F.AB633EF0] From: rbase-l@googlegroups.com On Behalf Of jan johansen Sent: Wednesday, December 23, 2020 11:33 AM To:

[RBASE-L] - drag and drop

I have a couple of questions about drag and drop. I have never used this feature. 1. Can you drag and drop between tables if both tables are associated on the same form? Or can you only drag within one table? 2. I have read the instructions on Drag and Drop but do not understand what

RE: [RBASE-L] - Creating DB Task Tracker Hints as Description

Razzak and Dan, Real nice layouts. We are looking at scheduling and these will give us more ways to look at what we want as an end product. I really like this thread. Very helpful. James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D6D850.8C9D4A30] From:

[RBASE-L] - pop up menu in DB Grid Tree

I did not see any choice for a pop up menu within a DB Grid Tree. Is there a property command that would give this option? This would be for individual cells within the DB grid. James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01D6D79D.00475340] -- For

RE: [RBASE-L] - using INNER JOINS?

<http://www.facebook.com/rbase> www.Razzak.com<http://www.Razzak.com> www.RazzakMemon.com<http://www.RazzakMemon.com> -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! ------ Original Message -- From: "'Jim Belisle' via RBA

RE: [RBASE-L] - using INNER JOINS?

nal Message -- From: "'Jim Belisle' via RBASE-L" mailto:rbase-l@googlegroups.com>> To: "rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>" mailto:rbase-l@googlegroups.com>> Sent: 12/18/2020 5:15:56 PM Subject: [RBASE-L] - using INNER JOINS? The followin

[RBASE-L] - using INNER JOINS?

The following code works and goes to the screen SELECT control#,transdate,model#,sortoneoh,remainqtyoh, + partnum,partpcspt,numpart,assypcsae + FROM ((topenorders t1 + INNER JOIN orderrows t2 ON t1.control# = t2.control#) J1 + INNER JOIN prodpart t3 ON j1.model# = t3.model#) J2 + INNER JOIN

RE: [RBASE-L] - proper code

with 2nd table) ENDWHILE ENDWHILE DROP CURSOR c1 DROP CURSOR C2 Karen -Original Message----- From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> mailto:rbase-l@googlegroups.com>> Sent: Mon, Dec 1

[RBASE-L] - Kudos for a form

A big Kudos to the Rbase dream team for the addition of the DBpivotgrid form. I just now started to discover all the flexibility of this form. I believe our shop team will like this for planning and scheduling purposes. I have been looking for how to use this Drill down feature for years. This

[RBASE-L] - EMAIL ANOMALY

Buddy, Thanks for the mention of the password. Though I never changed the password, the administrator checked the password and asked me to try a different one. Sure enough, the password he gave me worked. I have no idea where things got changed since I am the one who runs the configuration file

RE: [RBASE-L] - rmail anomaly

@comcast.net>> To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> Sent: Mon, Dec 7, 2020 12:38 pm Subject: RE: [RBASE-L] - rmail anomaly Jim I would think the user and/or password you are using to send from your applications has changed on the outlook server Buddy From: '

[RBASE-L] - rmail anomaly

We use RMAIL X5 and we installed the latest update. All has been going well. Then we ran into a glitch on Friday of last week, but ONLY for ONE area of my application. When doing the invoicing and trying to send the invoices out using the RMAIL, I got this error.

[RBASE-L] - RE: MAPI MAIL

Vous pouvez utiliser le BCC pour vous envoyer l'e-mail. Cela vérifierait que l'e-mail a été envoyé. James You could use the BCC to send yourself the email. This would verify the email was sent. From: rbase-l@googlegroups.com On Behalf Of Jean-Marc Massé Sent: Wednesday, December 2, 2020

RE: [RBASE-L] - Drag and drop

Most likely you have tried the below PROPERTY commands. PROPERTY TABLE tvpvalues 'REFRESH' PROPERTY Comp_vpchoice REFRESHLIST 'TRUE' However there are situations in which you have to CLOSE the table, do whatever and then OPEN the table. That code is below PROPERTY TABLE 'CLOSE' Do

RE: [RBASE-L] - Questions on Enhanced grids

Javier, About the footer for the dbgrid. In the enhanced options, use the show footer and navigation events on calculation. [cid:image001.png@01D6BD8A.46AEB6C0] Then in the column properties, choose which column you want to have your calculation. On this one, I want a sum based upon the

RE: [RBASE-L] - Questions on Enhanced grids

I use a simple PROPERTY command to bring up a sort box. Then you can choose any column or combination of columns. PROPERTY Comp_OPFgrid SHOWSORTDIALOG 'TRUE' RETURN [cid:image001.png@01D6BD89.5CDDFE70] James Belisle Making Information Systems People Friendly Since 1990

RE: [RBASE-L] - using choose in where clause

Dan, I believe Buddy’s example is the way to go. I use that all the time in my application. Simple and it works great. Jim From: rbase-l@googlegroups.com On Behalf Of Buddy Walker Sent: Friday, October 16, 2020 12:20 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - using choose in

[RBASE-L] - printing to the bypass tray

I installed the newest update of RBASE X.5 over the weekend and then compiled my application. For years we have used the below code to print a specific report to the bypass tray and it has worked flawlessly. PRINT kprshopwork WHERE transdateoh = .vtransdate ORDER BY control# + OPTION

RE: [RBASE-L] - using phone app w/ rbase

ot; or use Amazon, Microsoft, or Google cloud services. Once on the Cloud, you can access your secure application via web browser on any device using user credentials, etc., accordingly. Razzak At 10:52 AM 9/18/2020, 'Jim Belisle' via RBASE-L wrote: >Razzak, > >I figured I would have t

RE: [RBASE-L] - using phone app w/ rbase

the Web Browser. Very Best R:egards, Razzak At 10:17 AM 9/18/2020, 'Jim Belisle' via RBASE-L wrote: >If we wanted to use our phones to scan and enter part movements for >our RBASE application, would we have to build a cloud based application? >I have never created an application t

[RBASE-L] - using phone app w/ rbase

If we wanted to use our phones to scan and enter part movements for our RBASE application, would we have to build a cloud based application? I have never created an application to be used on the cloud. James Belisle Making Information Systems People Friendly Since 1990

RE: [RBASE-L] - Debug command while in application

is losing connection. Buddy From: 'Jim Belisle' via RBASE-L mailto:rbase-l@googlegroups.com>> Sent: Thursday, September 10, 2020 8:17 PM To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> Subject: [RBASE-L] - Debug command while in application I use the TRACE command quite reg

[RBASE-L] - Debug command while in application

I use the TRACE command quite regularly while in the explorer mode to test my EEPs, etc. I have not used the DEBUG command within an application while an application is being used. We have a form that was working fine for years until about five months ago. Now it inconsistently does not perform

RE: [RBASE-L] - Sub Reports and Break Headers

Make sure you ONLY have one common column in the sub report. I have often forgotten that and was not able to get the sub report to work. I believe the sub report band determines which common column to use. It looks like from what you have written the sub report is associated to the H1 band.

RE: [RBASE-L] - ISO-8601 date format

with some blue's clues. Very Best R:egards, Razzak At 12:12 PM 6/19/2020, 'Jim Belisle' via RBASE-L wrote: >I would like to export data from RBASE to a CSV file so the one date >column is in the /mm/dd format (ISO-8601). >I have been able to successfully create a temp table wi

[RBASE-L] - ISO-8601 date format

I would like to export data from RBASE to a CSV file so the one date column is in the /mm/dd format (ISO-8601). I have been able to successfully create a temp table with a text column that puts my date info in this format. (I have not seen the ability to format in RBASE the ISO-8601

RE: [RBASE-L] - DB Edit Field - Change the field background color based on the value in the field

I would try to change two things. 1) Create your var vwatch1 in the "on after start" EEP of the form. That way you are not creating it each time you enter the field. 2) Then use the var vwatch1 to make the color change, not the component ID name. IF vwatch1 = 'Y' THEN PROPERTY

RE: [RBASE-L] - problem printing to PDFs

essage- From: 'Jim Belisle' via RBASE-L To: rbase-l@googlegroups.com Sent: Mon, May 11, 2020 3:11 pm Subject: RE: [RBASE-L] - problem printing to PDFs Patti, Now that you mention it, I believe I have the same problem. I thought I was doing something wrong when I first notices

RE: [RBASE-L] - problem printing to PDFs

Patti, Now that you mention it, I believe I have the same problem. I thought I was doing something wrong when I first notices this last month. But the minute I saw your post, I checked it out and sure enough, if I print only one page of a pdf report, I cannot print the other two pages of the

RE: Re[2]: [RBASE-L] - File import

]: [RBASE-L] - File import Send me your address and I'll send some sample code from a similar usage Bruce -- Original Message -- From: "'Jim Belisle' via RBASE-L" mailto:rbase-l@googlegroups.com>> To: "rbase-l@googlegroups.com<mailto:rbase-l@googlegrou

RE: [RBASE-L] - File import

2 c -- Original Message -- From: "'Jim Belisle' via RBASE-L" mailto:rbase-l@googlegroups.com>> To: "rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>" mailto:rbase-l@googlegroups.com>> Sent: 5/10/2020 12:59:33 PM Subject: [RBASE-L] - File import I am

[RBASE-L] - File import

I am trying to work with our web administrator in bringing order information into RBASE using FTP. The FTP syncornizer creates an Excel file from the web then send that Excel file to our server. I then create code that brings that file information into RBASE using GATEWAY. Here is the glitch.

RE: [RBASE-L] - Bill Eyring

Bill worked with me in trying to take my less than normalized database become more normalized. He was good in his communication to us. We are sorry to hear of his passing. Thanks for the update. James Belisle Making Information Systems People Friendly Since 1990