Search found 107 matches

by Hazael
Fri Jul 02, 2010 7:51 pm
Forum: DataBases
Topic: From DBF/CDX to SQLite
Replies: 11
Views: 4846

Re: From DBF/CDX to SQLite

Yep. It is sql1.prg. :) The LIMIT clause places an upper bound on the number of rows returned in the result. A negative LIMIT indicates no upper bound. The optional OFFSET following LIMIT specifies how many rows to skip at the beginning of the result set. In a compound query, the LIMIT clause may o...
by Hazael
Wed Jun 30, 2010 3:44 pm
Forum: DataBases
Topic: From DBF/CDX to SQLite
Replies: 11
Views: 4846

Re: From DBF/CDX to SQLite

Hi Qatan! I think, if you wanna see next records, you can use phrase OFFSET - you will get next portion of information. It could be done when user reach end of table while browsing results. Marek Hello Marek, Would you mind to provide a code example of this? It could be simple in native Harbour. Yo...
by Hazael
Wed Jun 30, 2010 12:54 pm
Forum: DataBases
Topic: From DBF/CDX to SQLite
Replies: 11
Views: 4846

Re: From DBF/CDX to SQLite

Thank you all for your help! I found that SQLMIX works well and may be a good choice. Marek and Ratinaghiri's idea of OFFSET is good too. It will require to create a special tbrowse() do deal with it. Seems that I will have to do the hard job of making it but you already gave the first steps (Thank ...
by Hazael
Thu Jun 24, 2010 10:35 pm
Forum: DataBases
Topic: From DBF/CDX to SQLite
Replies: 11
Views: 4846

Re: From DBF/CDX to SQLite

Well, I am not sure I understand it. I think harbour code with a simple example of it while browsing would help to understand. Let's see... in a database with 800,000 records if I limit the query to get only 1,000 records then what I will have to show (and browse data) are only the first 1,000 recor...
by Hazael
Thu Jun 24, 2010 3:23 pm
Forum: DataBases
Topic: From DBF/CDX to SQLite
Replies: 11
Views: 4846

Re: From DBF/CDX to SQLite

Hello Rathinagiri, Thank you for helping. I am tending to use DBF/CDX because I feel more confortable and more secure with it for this new project. I think you are talking about sql1.prg, right? If so I already have it from your good example (Ware-Soft). If not, of course I will be interested. Do yo...
by Hazael
Thu Jun 24, 2010 1:09 pm
Forum: DataBases
Topic: From DBF/CDX to SQLite
Replies: 11
Views: 4846

From DBF/CDX to SQLite

Hello, I am trying to move from DBF/CDX to SQLite because of the many features and advantages I learned from here: http://www.sqlite.org/features.html I was studing previous interesting posts with real examples about this subject and I am creating a simple program in CUI mode (Character User Interfa...
by Hazael
Thu Jun 24, 2010 12:10 pm
Forum: Self Introduction
Topic: I want to be a HMG Poster
Replies: 493
Views: 67131

Re: I want to be a HMG Poster

Hello, I'm a former Clipper Summer'87 student from 1990. Recently I found xHarbour and right now I am using Harbour from SVN with MingW32. Trying to develop a simple and small ERP in CUI mode using GTWVT. Interested in HMG forum because I found it to be one of the most active places discussing about...