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
