Re: [RBASE-L] - Limit command does not work as documented

Hey, Rohan - The documentation you cite works with two parameters. Offset is the first row, and row_count is the number of rows. If you want to see, for example, rows 100 to 120, enter 'LIMIT 100, 20'. What Bruce cites also works, starting at row 0 and taking the next 20 rows. *AKA Bare Chested

Re: [RBASE-L] - Limit command does not work as documented

That works, Bruce. Thanks. here is the documentation and it does not need a where clause. [image: image.png] Thanks for your assistance, Bruce. Rohan Corea 818-451-6705 www.linkedin.com/in/rohancorea On Mon, Nov 6, 2023 at 2:18 PM Bruce Chitiea wrote: > Rohan, try: > > SELECT ALL FROM

Re: [RBASE-L] - Limit command does not work as documented

Rohan, try: SELECT ALL FROM customer WHERE LIMIT = 5 Bruce -- Original Message -- From rkco...@gmail.com To rbase-l@googlegroups.com Date 11/6/2023 2:12:25 PM Subject [RBASE-L] - Limit command does not work as documented I am using the Concomp database as an example. The following

[RBASE-L] - LIMIT command does not work as documented

My apologies for the earlier,incomplete message. I am using the Concomp database as an example. The following statement does network select all from customer limit 5 However, if I use orderby clause before limit, it works browse all from customer order by CustID limit 10 Is it a bug?

[RBASE-L] - Limit command does not work as documented

I am using the Concomp database as an example. The following statement does network select all from customer limit 5 However, if I use orderby clause before limit, it works browse all from customer order by CustID limit 10 Is it a bug? Rohan Corea 818-451-6705

[RBASE-L] - LIMIT COMMAND NOTWORKING AS DOCUMENTED

I am using the Concomp database as an example. The following command does not work Rohan Corea 818-451-6705 www.linkedin.com/in/rohancorea -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the

Re[2]: [RBASE-L] - Database CHOOSER

Randy: Hey, thanks. I'm fully booked today, but I'll get back to you soon. For an R:BASE feature perfectly suited for menu-at-the-desktop, take a look at the R:BASE External Form File (.RFF) structure. Best, Bruce Bruce A. Chitiea SafeSectors, Inc. 1142 S Diamond Bar Blvd # 442 Diamond Bar

Re: [RBASE-L] - I want to use a CHOOSE command to list options from a subdirectory rather than from inside a connected database.

Awesome!  You gave me an idea to explore for something similar I need to do Karen On Monday, November 6, 2023 at 03:45:28 AM CST, randyp ctags.com wrote: Dear Karen, I found  CHOOSE in help but didn't recognize the usage for its #Lfiles option. My RMD files are located in this

Re: [RBASE-L] - I want to use a CHOOSE command to list options from a subdirectory rather than from inside a connected database.

Dear Karen, I found CHOOSE in help but didn't recognize the usage for its #Lfiles option. My RMD files are located in this subdirectory: C:\RBTI\RBGX5E\Samples\ CHOOSE vaRbase FROM #LFILES IN c:\rbti\rbgx5e\samples\*.rmd RUN .vaRbase This CHOOSE generates a lovely, alphabetical listing of

Re: [RBASE-L] - Database CHOOSER

Dear Bruce, Your solution appears more comprehensive and elegant than I envisioned. My suggestion was more along the line of an R:Base feature included with the program. Please share how you do this, as it also suggests some strategies for organization, and sub-directory management. All the