I have a from date and to date in a table and I use this to find the rows I want
select all from INSLOGB where .vevent between F_DATE and TO_DATE gets the same result as select all from INSLOGB where F_DATE <= .vevent and TO_DATE >= .vevent I am not sure if one is more correct than the other? From: William Stacy Sent: Wednesday, March 30, 2011 3:34 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Scheduling how about something like WHERE colstartdate LE .vdate AND colendate GE .vdate (LE=less than or equal to, GE greater than or equal to) bill On Wed, Mar 30, 2011 at 10:22 AM, jan johansen <[email protected]> wrote: Group, I've had a scheduling system for a number of years. However I need to upgrade it. In the past if a user wanted to schedule an event across a number of days, say 3, they would have enter 3 events, one for each day. This worked well and it showed up on our scheduler just fine. However the request is now to enter 1 event with a start and end day. While simply adding a column for an end date is easy, the lookup is a confusing to me. What the heck would a query look like? The majority of events are 1 day events. Jan -----Original Message----- From: Glenn Smith <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 30 Mar 2011 11:00:07 -0600 Subject: [RBASE-L] - Re: CHECK FOR VALUES Jim, Do you have to use a spec file in v7.6? I run the code below (v9.1) and have no problems. In my case, the import table (cyber) is a permanent table, but you could place some code to create a temp table before the import. I clear the table, as needed, prior to this routine and then prompt for the file to import. I use append as I may want to import and process more than one spreadsheet. Works well – does assume that the number of columns in Excel are static – and that data comes from the first tab. choose vfile from #lfile in *.xls lines 31 gateway import xls &vfile append cyber option col_names off From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, March 29, 2011 5:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CHECK FOR VALUES We Save it in the old version 4 Excel so I would think Gateway should recognize it. Since it was not working, I tried a different approach. The user still has to CALL for the specification file but it works as I want it to. I still wish I could get the CODE to work and not have to use the GATEWAY box. James Belisle ---------------------------------------------------------------------------- From: [email protected] [mailto:[email protected]] On Behalf Of Gary Wendike Sent: Tuesday, March 29, 2011 6:18 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CHECK FOR VALUES James, check to make sure that the file is truly been saved as xls. Open the file in Excel and then do a Save As…look in the boxes below the window to see how the file has been saved in the past. I have run across this when the file has been saves in XML format. Gary From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, March 29, 2011 11:09 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CHECK FOR VALUES I used your code: GATEWAY IMPORT XLS DAILYTBL.xls CREATE TEMPORARY tdaytbl OPTION SPECIFICATION_FILE_NAME dailytbl.rgw I am still getting the error, “dailytbl.xls exists but is not a storage object.” James Belisle ---------------------------------------------------------------------------- From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Tuesday, March 29, 2011 8:38 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CHECK FOR VALUES James, Use the GATEWAY EXPORT from your database to create your RGW. Open the RGW with a text editor and search for RowLast. Change that value to some crazy big number like 2146385432. Then use your GATEWAY IMPORT like so. GATEWAY IMPORT XLS Customer.xls CREATE TEMPORARY customertesting OPTION SPECIFICATION_FILE_NAME Customer.rgw Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 29 Mar 2011 08:01:49 -0500 Subject: [RBASE-L] - Re: CHECK FOR VALUES I AM CURRENT WITH LAST VERSION OF 7.6 James Belisle -------------------------------------------------------------------------- From: [email protected] [mailto: [email protected]] On Behalf Of jan johansen Sent: Tuesday, March 29, 2011 7:59 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CHECK FOR VALUES James, What version? I think you are 7.6. Are you current? I vaguely remember a reported problem with GATEWAY a couple of years ago. Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 29 Mar 2011 07:53:22 -0500 Subject: [RBASE-L] - Re: CHECK FOR VALUES Jan, The situation is the same here. The number of rows is always different but t he Columns are the same. I know you use the CSV approach, but I would like to get the XLS approach to work, just so I know what I am doing wrong. I used this code in a CMD file and got this error. “The file exists but is not a storage object” GATEWAY IMPORT XLS + Workinfo.xls APPEND + tworkinfoday + SHEET_INDEX 0 + OPTION SPECIFICATION_FILE_NAME worktemp.RGW James Belisle ------------------------------------------------------------------------ From: [email protected] [mailto: [email protected]] On Behalf Of jan johansen Sent: Tuesday, March 29, 2011 7:42 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CHECK FOR VALUES James, That's if you want to use an RGW. If you just want to import a file use GATEWAY IMPORT CSV .vFileName CREATE CSVImportTable In my case, the excel sheet always has the same columns but the rows can change. Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 29 Mar 2011 07:31:25 -0500 Subject: [RBASE-L] - Re: CHECK FOR VALUES Jan, I In the Help section it states: The import must be performed once using the graphic user interface and saved using the "Specifications.." button. The specifications will be stored in a file with the .RGW file extension. One of the specs is the ending row. Is this not necessary when setting up a spec file? James Belisle ---------------------------------------------------------------------- From: [email protected] [mailto: [email protected]] On Behalf Of jan johansen Sent: Tuesday, March 29, 2011 7:14 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CHECK FOR VALUES James, It's still pretty early for me. Why does it matter how many rows? Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 29 Mar 2011 07:09:40 -0500 Subject: [RBASE-L] - Re: CHECK FOR VALUES At the present time, I use a specification file in Gateway to import into my tables from an EXCEL file. If I go to a TEMP table scenario, I would like to use code to do the import, rather than having the GATEWAY box popup. The problem I foresee is in the number of rows imported since it is almost always different. All the other items will remain the same. I know I can create a var at the start of the code asking for the number of rows to import. How would I go about using the spec file but changing the number of rows imported? Here is the code thus far: (ask for the number of rows to import and put into var) GATEWAY IMPORT XLS + Workinfo.xls APPEND + tworkinfoday + SHEET_INDEX 0 + OPTION SPECIFICATION_FILE_NAME worktemp.RGW James Belisle -------------------------------------------------------------------- From: [email protected] [mailto: [email protected] ] On Behalf Of Gary Wendike Sent: Monday, March 28, 2011 10:39 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CHECK FOR VALUES I agree with Jan on using the temp table approach. I also load many files from xls, csv and access format a day and use a temp file to process, check and adjust the data before I ever load to the permanent table. I never load directly into my permanent table. Gary From: [email protected] [mailto: [email protected] ] On Behalf Of jan johansen Sent: Monday, March 28, 2011 3:50 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CHECK FOR VALUES Jim, I think you should import the XLS into a TEMP table to do your evaluations on. If the evaluations pass, APPEND to the permanent table. Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 28 Mar 2011 15:25:44 -0500 Subject: [RBASE-L] - CHECK FOR VALUES Everyday we import into RBASE to files from EXCEL. One is a file with the time in and out for the whole day. (one per day per employee) The other has punches for specific work done for the day. (many punches per day) Certain employees, because their job is the same each day fail to punch in for the second file. What I want to do is check the excel file as it imports into RBASE for those employees and add a row with specific information. Any ideas as to the best way to accomplish this would be appreciated. James Belisle -- William Stacy, O.D. Please visit my website by clicking on : http://www.folsomeye.net
