Sieghard, If for some reason, you still long to navigate on your database using a cursor, like first, last, next, prev, current, based on an index or not, similar to what we had with paradox database engine or dbf, I recommend you to take a look here: https://forum.lazarus.freepascal.org/index.php/topic,57974.0.html
On Sat, Aug 26, 2023 at 1:13 PM Sieghard via mseide-msegui-talk < mseide-msegui-talk@lists.sourceforge.net> wrote: > Hello Fred, > > you wrote on Fri, 25 Aug 2023 19:08:26 +0000: > > > Of course your samples are more than welcome. > > Ok, I'll prepare some samples if you care to state a format. > > > AsI have already warned, msegui DB is new jungle territory for me. > > Well, I think that's the right characterization... Not that the functions > are extraordinarily sophisticated, but they are quite convoluted, and the > documentation is "not quite up to msegui standards", so to say. I think you > can derive what that should mean. > > > The last time I worked with DB, it was with Clipper (a pseudo-compiler > > for DB3) and all seems to have a few changed since that heroic days... 😉 > > Clipper? That must have been more than 30 years ago! Clipper was a dBase > dialect, AFAIR. There were a couple "dBase compilers" other than that, and > I even had done a project or two with one. I even had written a dBase > display program with Turbo Pascal (the source of which I still have). > But these days, you will HAVE to learn SQL, the "Structured Query Language" > for databases. It's quite well standardized, but "a bit quirky" as seen > from the point of view of a real programming language user. SQL is NOT a > full programming language, but most database systems these days use it for > data entry and retrieval, so one cannot ignore it if one has to work with > them. > On Linux, there are mainly 3 database systems in common use: > - mysql, or now, as this was incorporated by a commercial "development > company", its follow-up version "mariadb". AFAIK that's free for private > use, and is often the system of choice for web server use. > - postgresql, a rather professional, but still freely usable system, that's > less commonly used on Linux, although some more commercial applications > use it, like e.g. the "GnuCash" tax calculation and ERP financial system > > Both of these are client-server systems, i.e. the data management is done > by a server deamon process that handles the real data storage and > retrieval, and client applications that connect to it to provide or request > the data of interest. Both of them can also work over a network connection. > And then there is the third system, featuring a "slightly" different > approach: > > - sqlite, a stand-alone database system, somewhat similar to dBase or > Clipper, that is meant to be integrated (compiled) into the application > using it. Its databases are stored in separate files along with tha > application data, usually with an extension of ".sqlite". You probabely > know these from firefox or thunderbird or a couple other similar > software. > > On Windows, there's, of course, the MS "native" database system (I cannot > remeber the name of) and (I think) the former "Interbase", AFAIK now called > "firebird", from former Borland Inc. > And then, there's an approach at integrating everything being able to > "speak" SQL by an integrating layer for data provisioning called "ODBC", > the "Open Data Base C<what? Controller? They don't say...>". It is so > universally capable that there's hardly an operating system without an > implementation or a database system for which no driver is available > (although NOT all of them are free). > Our msegui also has an interface for that! > I'm using postgresql for the application I use for my financial activities > and a couple data collection functions, and, of course, though only > indirectly, sqlite by means of firefox, mostly. > I' planning to put the aforementioned database "browser" (for postgresql) > on my web site shortly (in conjunction with a couple other things), but I > will give notice here. > > > @Med, for the name of fields, maybe check the datasource used by the > > dropdownedit. (I have to jump into msegui-db, I dont know....) > > Could it be that this application does direct accesses to the sqlquery > result data provided by a query? The "canonical" way seems to be meant to > use the query only indirectly through the "datasource" module, but this > might not be done consistently. Just a (wild) guess... > > See you later, and wish you very well in the meantime! > > -- > (Weitergabe von Adressdaten, Telefonnummern u.ä. ohne Zustimmung > nicht gestattet, ebenso Zusendung von Werbung oder ähnlichem) > ----------------------------------------------------------- > Mit freundlichen Grüßen, S. Schicktanz > ----------------------------------------------------------- > > > > > _______________________________________________ > mseide-msegui-talk mailing list > mseide-msegui-talk@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk > -- Vasi
_______________________________________________ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
