BasicOs Posted January 7, 2006 Share Posted January 7, 2006 (edited) BREAK MS RULES, USE dbase LANGUAGE, in autoit for handling databases.INCLUDES A 2 LINE LESSON OF DBASE III PLUS FOR BEGINNERSdbaseIIIplus is a PROGRAMM OF THE 80'S for handling database, now converted by Autoit into a programm of XXI , better eXPerienceI think one of the bests not compiled, interpreter languages for database handling is DBASE III (plus, clipper etcc) from 1980sI got some analysys and some partially made scripts of a port of XBASE into AUTOIT, so taking advantage of this easy language:-DBASE advantages: 1.easy database handling, and interpreter (you can make changes without compiling, on the flight)(can be encrypted if needed)2.easy debbugging, lighting, quick and small code (allways less than 1Mb source+ exes all included)3.compatible and exportable data4. I dont like MS game "if users LOSE their KNOWLEDGE, WE WIN AND MAKE MONEY ":MS false commercial philosophy of "New incompatible version every 9 months to get new cash but no real improvement for ms customers and changing everything, for the sake of a "suppoussed" better experience bla bla etc.. = You can do everything without losing your knowledge with AUTOIT.-Autoit - Dbase Advantages:adding what is missing from ms-dos, nice grafical interface, plus other programms controlThings doing: waiting for feedbacksmall Things To DO: graphical interface connections (udf) 1. (output RESULTS(SELECT) needed: Pick up the OUTPUT, into Autoit Vars, which can be handled by the graphic interface)2-If not output needed only make a process like DELETE or INSERT(append), then only return a var where it is OK or not.3-translate the dos printing calls into file and the output into default printer.Things That Failed: I hope nothing is goin to fail.How to: 3 UDF which treat dbase in 3 different ways: 1st: execute code created inside an AU3 2d: example of translation of dbase->au3, for updating and inserting data in a dbf 3d: executing external prgsENJOY BOYS!!!!Requirements: You need a copy of dbase.exe and libraries (functions tested with dbase III pluS) for working with clipper,dbase IV,Xbase in general you should make some small changes that fit compiler/interpreter.Main func: takes some code into var welsend and then execute this dbase language code, optiona file outputwelsend=dbase III+ code can be created on the fly by the au3wfileopcional= output file optional1-Func dbase($WELSEND, $WFILEOPCIONAL)FUNCTION DBASEREPLA similar to REPLACE With (may include an append optional) UPDATEs OR INSERT ONE OR MANY RECORDS inside of a dbf DATABASE FIELDS FILTER filoutput append or not2-Func dbaserepla($WDATABASE, $WREPLACEFIELDS, $WFORCOND, $FILE2, $iSAPPEND)execute one PRG (like au3 in dbase), Wparam are the optionals param which will replace text inside the PRG3-Func DBDO($PRG, $WPARAMETERS)Now the download:LESSON OF DBASE FOR BEGGINNERS: SEE HOW EASYLY you can get info of a database into AU3 (LIGHTNING SPEED) MILLIONS OF RECORDS dbase code how TO (MAKE A SELECT) list names of people in database into au3 this info gets into a var called $selectedPeople you can use in AUTOITSYNTAX: $SelectedPeople = DBASE ("USE PEOPLEÇset alter onÇLIST OFF NAME,AGE FOR " & $WFOR & "Çset alter off", "people")LOOK AT THE ORIGINAL DBASE III+ CODE:;( --- OPENS DATABASE PEOPLE.DBF)USE PEOPLE ; EXECUTE THE SELECT: FOR FIELDS NAME AGE --- wFOR CAN BE: $WFOR=" AGE>20"LIST OFF NAME,AGE FOR AGE>20Please send me some posts about this topic, if you find interesting and so ..............Postdatum:Autoit goes UP: Thanks Jonh for not changing every 9 months of autoit version and make obsolote and unusable all what we learnt before. MS drops: right now it FORCED restart itself automatically after an "CRITICAL" update and I lost again part of my WORK.agghhh!!dbfuncs.au3 Edited January 8, 2006 by BasicOs Autoit.es - Foro Autoit en Español Word visitors Image Clustrmap image: - Football Spanish team - Spanish team: Casillas, Iniesta, Villa, Xavi, Puyol, Campdevilla, etc..Programando en Autoit+Html - Coding Autoit-Html - Arranca programas desde Internet - Preprocesador de Autoit a http Link to comment Share on other sites More sharing options...
Moderators SmOke_N Posted January 7, 2006 Moderators Share Posted January 7, 2006 Errr... If there is no script... shouldn't this be in the idea lab? Common sense plays a role in the basics of understanding AutoIt... If you're lacking in that, do us all a favor, and step away from the computer. Link to comment Share on other sites More sharing options...
BasicOs Posted January 7, 2006 Author Share Posted January 7, 2006 (edited) Errr... If there is no script... shouldn't this be in the idea lab? you are wrong idea lab is stated as Autoit suggestions readv3 Idea LabPost your ideas and suggestions for AutoIt here.AN SCRIPT consist of two parts:first: ANALYSYS 90% of scriptsecond: CODING 10% of script(in fact not so important)I AM POSTING one part of the script, not yet whole because I havent yet finished, waiting for feed backhearthly, thanks for feed back. ps: dont forget analysys is 90% of the script, coding is mostly copying from the manual. Edited January 7, 2006 by BasicOs Autoit.es - Foro Autoit en Español Word visitors Image Clustrmap image: - Football Spanish team - Spanish team: Casillas, Iniesta, Villa, Xavi, Puyol, Campdevilla, etc..Programando en Autoit+Html - Coding Autoit-Html - Arranca programas desde Internet - Preprocesador de Autoit a http Link to comment Share on other sites More sharing options...
Gene Posted January 7, 2006 Share Posted January 7, 2006 I think one of the bests not compiled, interpreter languages for database handling is DBASE III (plus, clipper etcc) from 1980sI got some analysys and some partially made scripts of a port of XBASE into AUTOIT, so taking advantage of this easy language:-DBASE advantages: 1.easy database handling, and interpreter (you can make changes without compiling, on the flight)(can be encrypted if needed)2.easy debbugging, lighting, quick and small code (allways less than 1Mb source+ exes all included)3.compatible and exportable data4.You can do everything without losing your knowledge and take advantage of new techs if you keep a nice AUTOIT interface.-Autoit plusinto Dbase Advantages:adding what is missing from ms-dos, nice grafical interface, plus other programms controlPlease send me some posts about this topic, if you find interesting and so ..............DONE: ANALYSYS: porting dbase code (*.prg) whole and partially:1-when output RESULTS(SELECT) needed: Pick up the OUTPUT, into Autoit Vars, which can be handled by the graphic interface.2-If not output needed only make a process like DELETE or INSERT(append), then only return a var where it is OK or not.3-Cancel graphical typical MS-DOS interface of dbase.4-translate the dos printing calls into file and the output into default printer.Things To Be Added: coding part of the script, graphical interface connections (udf)Things That Failed: I hope nothing is goin to fail as the analysys is clear and the database handling code is XBASE.Probable Question(s): populate ¿a few or many ? new autoit UDFs similar to DBASE III+ code or only recode/port whole source.Postdatum: Thanks Jonh for not changing every 9 months of autoit version and make obsolote and unusable all what we learnt before. I think I may be interested, I spent a lot of time in dBase & Clipper in the 80s. I'd like to see a more detailed statement of your goals and analysis without MS comments (they just get in the way). Note my edits of your post above.Your response to SmOke_N was unfortunate, in that it seemed more hostile than explanatory. From your initial post I too thought you had some existing code. I wondered why you didn't post it.Gene [font="Verdana"]Thanks for the response.Gene[/font]Yes, I know the punctuation is not right... Link to comment Share on other sites More sharing options...
Moderators SmOke_N Posted January 7, 2006 Moderators Share Posted January 7, 2006 you are wrong idea lab is stated as Autoit suggestions readv3 Idea LabPost your ideas and suggestions for AutoIt here.AN SCRIPT consist of two parts:first: ANALYSYS 90% of scriptsecond: CODING 10% of script(in fact not so important)I AM POSTING one part of the script, not yet whole because I havent yet finished, waiting for feed backMay be you are an einstein programmer who can make scripts without analysys and you code directly, really a bad habit for you. If you like I will speak as you do in your encode programm, I will copy part of your post and change:see the edit.thanks for feed back. ps: dont forget analysys is 90% of the script, coding is only copying from the manual. do Work!!!Whoah Tiger!!I simply thought you posted it in the wrong forum. Common sense plays a role in the basics of understanding AutoIt... If you're lacking in that, do us all a favor, and step away from the computer. Link to comment Share on other sites More sharing options...
ACalcutt Posted January 7, 2006 Share Posted January 7, 2006 I've never heard of XBASE. what is it used for? Andrew Calcutt Http://www.Vistumbler.net Http://www.TechIdiots.net Its not an error, its a undocumented feature Link to comment Share on other sites More sharing options...
Gene Posted January 8, 2006 Share Posted January 8, 2006 I've never heard of XBASE. what is it used for? Have you ever heard of dBase? Either way dBase was the first widely used serious database tool for PCs. There were some better and lesser imitators for use with compilers and some were interpreted. Over time they became more similar and also came to be collectively called xBase. Clipper, Quicksilver and FoxPro were some of the better implementations. Eventually dBase and FoxPro transitioned to Windows. They were relatively easy to use and prior to Windows made serious efforts to add features and capability without breaking existing code. Oh, dBase and FoxPro were interpreted, Clipper, Quicksilver were compiledI started with dBase, went to Quicksilver, then to Clipper. There were too many IEs in the plants who thought it was their duty to tinker with my code. I dabbled in several others too. I still have dBase III, Quicksilver, 2 two versions of Clipper and 1 each of FoxPro and its Distribution Kit. While I'm listing obsolete software I have, maybe I should mention MS VB for DOS, MS QuickBasic 2.0 and PowerBuilder 3. I have no idea why I have kept these, maybe my son can sell them as antiquities when he is my age.Gene [font="Verdana"]Thanks for the response.Gene[/font]Yes, I know the punctuation is not right... Link to comment Share on other sites More sharing options...
BasicOs Posted January 8, 2006 Author Share Posted January 8, 2006 (edited) functions uploadedPlease send me some posts about them, if you find interesting and so ..............FILE AT:http://www.autoitscript.com/forum/index.ph...pe=post&id=6014 Edited January 8, 2006 by BasicOs Autoit.es - Foro Autoit en Español Word visitors Image Clustrmap image: - Football Spanish team - Spanish team: Casillas, Iniesta, Villa, Xavi, Puyol, Campdevilla, etc..Programando en Autoit+Html - Coding Autoit-Html - Arranca programas desde Internet - Preprocesador de Autoit a http Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now