Alpha Video Training
Page 1 of 3 123 LastLast
Results 1 to 30 of 61

Thread: VFP FoxPro to Alpha5 Questions

  1. #1
    Member
    Real Name
    Stanley Barnett
    Join Date
    Jun 2008
    Location
    Kentucky
    Posts
    119

    Default VFP FoxPro to Alpha5 Questions

    Hi,

    I'm a VFP programmer for 10 years now and trying to get my head around Alpha5. Any pointers and help is greatly appreciated in translating between these languages...

    1. Are the A5 .dbf tables secure and protected from changes by users connecting to it via an odbc driver outside the A5 environment like Excel? Could this type of access screw up relations, indexes and/or other things?

    2. What A5 code would I need to do the following:
    a. test if a table is open,
    vfp code: if used("Products")

    b. open the products table,
    vfp code: use "Products" in 0 shared (or exclusive)

    c. set the order by using an index,
    vfp code: set order to "ItemNum"

    d. set a filter condition,
    vfp code: set filter to Item_Num >= "25412"

    e. browse the table,
    vfp code: browse

    f. create an index on Item_Num with a name of ItemNum,
    vfp code: index on Item_Num tag ItemNum

    g. go to a record number 514,
    vfp code: go 514

    h. resize all the columns on a grid to fit the widest values for each column in the browse form programatically and/or via the ui,
    vfp code: Thisform.grdProducts.AutoFit()

    i. find the type of a variable and/or field,
    vfp code: type(fieldname/variable name)

    j. More later....

    3. How do I use a variable in a program/function like this:
    aa = date()
    ?dtoc(aa)
    (this errors out in the interactive window)

    4. Does the term "open exclusive or shared" mean anything to A5?

    5. How do I see the entire contents of a memo field on a browse?

    6. What other Foreign languages are supported?

    7. More later...

    Thanks,
    Stanley

  2. #2
    "Certified" Alphaholic Keith Hubert's Avatar
    Real Name
    Keith Hubert
    Join Date
    Jul 2000
    Location
    London, UK
    Posts
    6,930

    Default Re: VFP FoxPro to Alpha5 Questions

    Hi Stanley,

    Welcome to Alpha, I know you have posted here just a few times but to get the best help here are a couple of tips.

    1: Only ask one question at a time, that way a number of threads can be just for one topic.

    2: Just ask, how to achieve what you want as a result. Most people here will not understand what and how you did it before and therefore cant make the comparison.

    Any way to answer question 3.

    aa=date()
    x=dtoc(aa)
    ?x
    = "13/06/2008"

    Hope this help a bit.
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

  3. #3
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: VFP FoxPro to Alpha5 Questions

    Or to make Stanley's work,

    Code:
     
    dim aa as D
    aa=date()
    ?dtoc(aa)
    = "06/13/2008"
    Along with what Keith stated....

    Its best to not try and use other db terms really--I know you are trying to get a handle on Alpha by relating to what you know...which can help at times...but many times it will just add to your confusion as you will also then be trying to DO things the same way as you have done with other tools.

    Just by going through the tutorials and the User Manual will greatly expedite your learning/transition. Many of the answers you have asked can be found fairly easy with either a search of the messageboard or the online help file...and the earlier on you learn the ins and outs of how to do these searches the faster you can grow in Alpha.

    Just another opinion or I guess I used up Keith's 2 pence here. :)
    Last edited by MikeC; 06-13-2008 at 09:49 AM.
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




  4. #4
    Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,631

    Default Re: VFP FoxPro to Alpha5 Questions

    Wow! You said (asked) a mouthful! Keith is correct. You are better off asking one Q at a time as the need arises. But since you are testing the waters (sort of), I'll try to answer your Qs.

    Quote Originally Posted by stanlyn View Post
    1. Are the A5 .dbf tables secure and protected from changes by users connecting to it via an odbc driver outside the A5 environment like Excel? Could this type of access screw up relations, indexes and/or other things?
    Sounds like a recipe for disaster if you try to modify dbf data from Excel if you also plan on using A5 in the same context.

    2. What A5 code would I need to do the following:
    a. test if a table is open,
    TABLE.ISOPEN()
    TABLE.IN_USE()

    b. open the products table,
    tbl = table.open("Products")

    c. set the order by using an index,
    tbl.index_primary_Put("ItemNum")

    d. set a filter condition,
    The traditional method is something like this:
    Code:
    query.order = ""		
    query.filter = "Item_Num >= '25412' "
    query.options = ""    
    Q = tbl.query_create()
    But A5 has a whole host of query/filter methods.
    Too many to get into here.

    e. browse the table,
    Usually you would select browse view that from a toolbar. No code needed, but you can easily code it if you like. You can create as many customized browse views as you like.

    f. create an index on Item_Num with a name of ItemNum,
    Again, you would typically define the index in a simple dialog - no coding needed. But A5 has simple functions that allow you to code the indicies if you prefer.

    g. go to a record number 514,
    You can also do this from a toolbar, or:
    tbl.fetch_goto(514)

    h. resize all the columns on a grid to fit the widest values for each column in the browse form programatically and/or via the ui,
    You can size the column width in design or view mode by dragging the column edge. I believe you can dynamically set the width w. xbasic as well. But I do not believe you can auto size the column width to the text size of the column.

    i. find the type of a variable and/or field,
    typeof() - for variable
    .type_get() - - - e.g.
    table.current().field_get([number or fieldname]).type_get()

    j. More later....
    Whatever...

    3. How do I use a variable in a program/function like this:
    aa = date()
    ?dtoc(aa)
    (this errors out in the interactive window)
    No error from I.E. when I did it:
    Code:
    aa = date()
    
    ?dtoc(aa)
    = "06/13/2008"
    4. Does the term "open exclusive or shared" mean anything to A5?
    Sure. Depends upon the context.

    tbl = table.open("Products",FILE_RO_EXCLUSIVE)
    Modes =
    FILE_RO_EXCLUSIVE
    FILE_RW_EXCLUSIVE
    FILE_RO_SHARED
    FILE_RW_SHARED
    FILE_REUSE_EXISTING
    TABLE_MODE_INFORMATIONAL

    "Shared" can refer to variable scope, etc.

    5. How do I see the entire contents of a memo field on a browse?
    Drag the row height. Can't remember if you are limited to 255 characters or if it will show the whole shebang.

    6. What other Foreign languages are supported?
    None (as far as I know).

    7. More later...
    Right.

  5. #5
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,300

    Default Re: VFP FoxPro to Alpha5 Questions

    Stanley, I agree with Peter's responses except for the first. No. The native DBF tables used by Alpha Five are formatted the same as Foxpro 2.6 tables. They are not secure and may be read by a host of other applications. Alpha Five includes a built in encryption capability however. If you encrypt the tables other 3rd party apps won't be able to read the tables.

  6. #6
    Member
    Real Name
    Stanley Barnett
    Join Date
    Jun 2008
    Location
    Kentucky
    Posts
    119

    Default Re: VFP FoxPro to Alpha5 Questions

    Thanks for the detailed answers to my questions... I'm trying to grab the basics so I can test with some of my large datasets. Also, I know all the answers are in the docs, BUT it will take forever for me to get a handle on the basics because of the shear volume of docs. Most importantly, the terminology is simular in some cases and very different in others, hence the confusion... So, please bear with me...

    Sounds like a recipe for disaster if you try to modify dbf data from Excel if you also plan on using A5 in the same context
    It is a disaster waiting to happen... and I wanted to know if there were any ways to protect it like most sql databases where true authentication must be done before access is granted.

    If I understand you correctly, even if the data is encrypted, a 3rd party app can connect to and expose it to disaster... correct?

    1: Only ask one question at a time, that way a number of threads can be just for one topic.
    I see this as one thread (VFP as it relates to A5)... I started this thread with so many questions so to keep all the VFP Foxpro stuff together thereby helping the next foxpro developer. I have also noted that one question leads to another quickly and it would be more efficient for replies all in one place because the person repling to this would most likly know some foxpro.

    Quote:
    e. browse the table,

    Usually you would select browse view that from a toolbar. No code needed, but you can easily code it if you like.
    What do I type in the IE to call a generic browse up?

    Quote:
    f. create an index on Item_Num with a name of ItemNum,

    Again, you would typically define the index in a simple dialog - no coding needed. But A5 has simple functions that allow you to code the indicies if you prefer.
    What is the code to build the above index as the IE (command window) is generally faster that the mouse way. I use this type of routines in table maintenance procedures as many times it is better to delete all the indexes, do the table maintenance, and finally rebuild them from scratch via the procedure code. It also shows me what is going on behind the scenes and allows my to do whatever programatically, and learn faster.


    Thanks so much...
    Stanley

  7. #7
    Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,631

    Default Re: VFP FoxPro to Alpha5 Questions

    Stanley,

    If I understand you correctly, even if the data is encrypted, a 3rd party app can connect to and expose it to disaster... correct?
    Not sure to be honest. But I think I could open up almost any file in MS_Word, type some gibberish and save it, thus wrecking the file (I believe)?

    What do I type in the IE to call a generic browse up?
    A5_OPEN_DEFAULT_BROWSE()

    What is the code to build the above index as the IE
    Code:
    tbl = table.current()
    tbl.index_create_begin("LASTNAME", "LAST_NAME")
    tbl.index_add("FIRSTNAME", "FIRST_NAME")
    index1 = tbl.index_create_end()

  8. #8
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,300

    Default Re: VFP FoxPro to Alpha5 Questions

    I wanted to know if there were any ways to protect it like most sql databases where true authentication must be done before access is granted.
    I don't understand this question. Can't I grab the SQL data file with a hex editor and wreak havoc? I thought you were asking about 3rd party apps? Now it sounds like you are talking about database security within the Alpha Five environment itself. These are different things. Alpha Five includes a built in security system which can be configured to require users to log in before access (through A5) is granted. If this is not what you're asking please clarify.

    -- tom

  9. #9
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,300

    Default Re: VFP FoxPro to Alpha5 Questions

    What do I type in the IE to call a generic browse up?
    The Alpha Five way to do this would be to choose the table/set tab of the control panel and right click the desired entry. A lot of functionality has been built for you, saving much typing. Being able to view the "default browse" or the "default form" with a mouse click is some of it. Defining indexes with the help of a genie is another.

  10. #10
    Member
    Real Name
    Stanley Barnett
    Join Date
    Jun 2008
    Location
    Kentucky
    Posts
    119

    Default Re: VFP FoxPro to Alpha5 Questions

    Is A5 multi threaded?

  11. #11
    Member
    Real Name
    Stanley Barnett
    Join Date
    Jun 2008
    Location
    Kentucky
    Posts
    119

    Default Re: VFP FoxPro to Alpha5 Questions

    Can an index be created using a function as its input?

  12. #12
    Member
    Real Name
    Stanley Barnett
    Join Date
    Jun 2008
    Location
    Kentucky
    Posts
    119

    Default Re: VFP FoxPro to Alpha5 Questions

    What does "Save change in Progress" mean? I didn't make any changes, I only browsed a table, and when I close it it asks this ?

  13. #13
    "Certified" Alphaholic NoeticCC's Avatar
    Real Name
    Andrea Gill
    Join Date
    Nov 2007
    Location
    Golcar, West Yorkshire, UK
    Posts
    2,069

    Default Re: VFP FoxPro to Alpha5 Questions

    Quote Originally Posted by stanlyn View Post
    Is A5 multi threaded?
    http://support.alphasoftware.com/alp...nd_Methods.htm

  14. #14
    Member
    Real Name
    Stanley Barnett
    Join Date
    Jun 2008
    Location
    Kentucky
    Posts
    119

    Default Re: VFP FoxPro to Alpha5 Questions

    When I issue a filter on a table and then issue the browse command, the browse does not respect the filter that was previously set. It acts as if the filter was turned off.

    I'd like to set the index to be used, and/or add a filter, then browse the table without typing all the arguments into the browse command.

  15. #15
    "Certified" Alphaholic NoeticCC's Avatar
    Real Name
    Andrea Gill
    Join Date
    Nov 2007
    Location
    Golcar, West Yorkshire, UK
    Posts
    2,069

    Default Re: VFP FoxPro to Alpha5 Questions

    Quote Originally Posted by stanlyn View Post
    Can an index be created using a function as its input?
    Do you mean can you create an index that is more than just the value in a column, but rather a calculated value based on values in one or more columns, then yes.

  16. #16
    Member
    Real Name
    Stanley Barnett
    Join Date
    Jun 2008
    Location
    Kentucky
    Posts
    119

    Default Re: VFP FoxPro to Alpha5 Questions

    Thanks NoeticCC for the threading answer...

    I did notice that I cannot do anything in IE when running a large filter or indexing. If its truely multi-threaded, then why does the UI lock until the process finishes?

    Now I'm wondering if it really is multi-threaded, as true multi-threaded apps allows other processes to be started and ran regardless of other processes. If I have to program in all the threading, then I'll consider it single threaded because of the way it behaves out of the box. I hope I'm missing something here.

  17. #17
    "Certified" Alphaholic NoeticCC's Avatar
    Real Name
    Andrea Gill
    Join Date
    Nov 2007
    Location
    Golcar, West Yorkshire, UK
    Posts
    2,069

    Default Re: VFP FoxPro to Alpha5 Questions

    Quote Originally Posted by stanlyn View Post
    Thanks NoeticCC for the threading answer...

    I did notice that I cannot do anything in IE when running a large filter or indexing. If its truely multi-threaded, then why does the UI lock until the process finishes?
    Presumably, the UI locks because Alpha5 doesn't "want" you to go and be able to edit stuff that is currently being processed...

    The thread functions refer to what YOU as a developer can allow YOUR users to do, e.g. you can spawn other threads in the background depending on your needs. E.g. you can start a folder watch or a timer event in another thread separate from the main, but that is behaviour in the app you write with Alpha5, since you sepcifically coded it that way (assuming that the actions in the other thread can go ahead without requiring any subsequent actions to wait etc.).

    This does of course not mean that the development tool itself is going to automatically act the way you wish it would in any given instance... unless you spaw a process in a separate thread it will take place in the current thread, since the likelyhood of such operations affecting data (and thus needing to be completed before any new ops can be started, lest data become corrupted/garbled) is rather high.

  18. #18
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    5,994

    Default Re: VFP FoxPro to Alpha5 Questions

    Stanlyn.

    If I understand you correctly, even if the data is encrypted, a 3rd party app can connect to and expose it to disaster... correct?
    So can an exe file be opened with notepad and destroyed. The biggest deal is with the encryption, another alpha adb can't open that table and see the data, nor can anything else open and see the data. It can get garbled up by a hacker. So can a sql table, or any other file.

    Indexes:

    May i suggest you make your basic indexes for you tables and do the ones you rarely need on the fly.

    typing-mouse:

    When we left dos, we learned the mouse big time and alpha is following the desire of the many with the mouse. It may not be faster, but if you are doing something with more than a few key strokes that can be done with a couple mouse clicks, I vote mouse.

    Functions:

    when learning clipper, I was told to memorize the functions. we had a hundred or more. In alpha there are hundreds(pretty good help file though). In clipper, almost everything required you make a another function. Alpha does not require so many udf's, but you can if you want and it is usually faster.

    VFP/clipper/basic:

    did a little foxpro in the dos days, but clipper was the big dog then. Alpha is getting to be more and more accepted now because you can do so much without programming code.

    Suggestion:

    Do some of the easy mouse button clicks to do some of the things you asked about, then save as a script or xbasic. check the code alpha made, many suprises.

    -----------------------------------------------

    Don't worry too much about the next VFP programmer looking at this thread, because each will have their own issues to deal with. The one thing you have here is a lot of help for whatever you need. A lot of these users have a vast amount of experience in other languages. Makes for a variety of answers for you which shows the versatility of your new tool.

    You had some pretty good answers from the users here so far.

    .



    .
    Dave Mason
    dave@aldaweb.com

    Skype is dave.mason46

  19. #19
    "Certified" Alphaholic
    Real Name
    Cal Locklin
    Join Date
    Mar 2000
    Location
    S.E. Michigan
    Posts
    5,763

    Default Re: VFP FoxPro to Alpha5 Questions

    Stanley, welcome to the A5 community. We all feel your pain about getting your head around it initiallly - we've all been there and we've all survived. The way I did it was to read all I could find and to work with the examples like Alpha Sports. When I first started, the Help file wasn't as big as it is now but I eventually read every page of it. And, I'd say I've read at least 95% of everything in the current Help files - probably more. (I don't remember it all but at least I have an idea of what's available to me.)

    One of the problems I have with the current Help file is that the keyword searches find every instance of that word. In most cases that means that most references aren't really relevant. To help you find the info you need, try downloading and using my A5v5 Xbasic Help file:
    - This file contains every xbasic function from v5. (More proof that I truly did read every page of their help file which was in PDF format only at that time.)
    - The file ONLY includes xbasic functions - no other tutorials, etc.
    - Most every question you've asked so far would involve only xbasic commands that were already available in version 5.
    - There are many v6-v7 functions also listed and a few v8 functions. (You should be aware that most of the changes from v6 on have related to web apps and interfacing with the web. There are some new desktop xbasic functions but even many of those are only wrappers around older functions.)
    - The keywords in this help file were specificially defined for each topic and are, therefore, always relevant.
    - Many of the keywords are synonyms. This means that you can find a Delete function by looking for Remove, Erase, Delete, Drop, and maybe one or two others. (Compare that to the current Help file that virtually requires you to already know the command in order to find it.)
    - This is an older .hlp type file so you may need to download the appropriate file from MS to run it in XP.
    - If you decide to use it, remember that you are getting the benefit of hundreds of hours of my time for free.

    Since you are coming from another system, you might also want to read my A5 Naming Recommendations. I like the way most people handle naming in VB and Access but A5 has some restrictions because of it's basis in .DBF files. As a result, most of those naming methods basically suck if you try to apply them to A5. Although there are specific recommendations in that document, the really important thing is to understand the reason for suggesting them. I've been using A5 since version 1 first came out and I can tell you that all those reasons are valid - if you think any of them aren't important to you now, they will be at some point in the future. (I'm going to change the 'purpose' on that page because it's not just about running text searches. Good naming practices also make development faster, more efficient, and easier to understand/edit in the future. In some cases they can even make the application more stable.)

    I also want to point out that the comment about "one question at a time" referred to separate threads - not separate posts on one thead. Separate posts on one thread are even more confusing. Due to the nature of the initial post, I'm not sure there would have been a huge benefit to splitting them up in this case but part of the reason for splitting them is that some people can't answer all the questions. That makes it harder for them to respond.

    Finally, one thing that nobody has pointed out but I think may have caused the initial problem with the test in the Interactive Windows (IW) is that you must hit the Enter key on each line to 'run' that line so the rest of the lines in the IW can see/use the result. My guess is that you may have copied that short test to the IW and added the "?" in front of the second line then hit "Enter" only on that one line thinking that it would "see" the first line. (You can also highlight multiple lines and run the whole thing just like a regular script by clicking the lightning bolt or pressing Ctrl-F5. If you do that, it has to look just like a script - all IW related symbols like "?" and "=" must be removed first.)

  20. #20
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: VFP FoxPro to Alpha5 Questions

    Cal, all.

    The date script
    Code:
     
    aa = date()
    ?dtoc(aa)
    errors out if you highlight "aa=date()" first and use the lightning bolt Run icon to run it, then placing the cursor after ?dtoc(aa) and hitting enter.
    Code:
     
    aa = date()
    ?dtoc(aa)
    ERROR: Variable "aa" not found.
    If placing the cursor after each line and hitting enter then no error is produced.
    Code:
    aa = date()
    ?dtoc(aa)
    = "06/14/2008"
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




  21. #21
    "Certified" Alphaholic
    Real Name
    Cal Locklin
    Join Date
    Mar 2000
    Location
    S.E. Michigan
    Posts
    5,763

    Default Re: VFP FoxPro to Alpha5 Questions

    Quote Originally Posted by MikeC View Post
    The date script ... errors out if you highlight "aa=date()" first and use the lightning bolt Run icon to run it, then placing the cursor after ?dtoc(aa) and hitting enter.
    Most interesting!

    I verified this in v8 and v9. I also tried it by putting a "DIM aa as D" before the "aa=date()". After highlighting both those lines and hitting the lightning bolt, it seems to work.

    However, in A5v5 - A5v7 all you have to do is highlight the "aa=date()" line. Sounds to me like "something changed" in v8. (alternate concepts might be considered in place of "something changed".)

  22. #22
    "Certified" Alphaholic NoeticCC's Avatar
    Real Name
    Andrea Gill
    Join Date
    Nov 2007
    Location
    Golcar, West Yorkshire, UK
    Posts
    2,069

    Default Re: VFP FoxPro to Alpha5 Questions

    Quote Originally Posted by DaveM View Post
    did a little foxpro in the dos days, but clipper was the big dog then. Alpha is getting to be more and more accepted now because you can do so much without programming code.
    ... and much, much more WITH programming a little code, too... ;)

  23. #23
    Member
    Real Name
    Stanley Barnett
    Join Date
    Jun 2008
    Location
    Kentucky
    Posts
    119

    Default Re: VFP FoxPro to Alpha5 Questions

    Concerning the date script that was erroring out...

    With me coming from VFP and learning about the IW, it was easy to adapt as they behave very simular with regards to the community.

    There are a couple places that A5 lacks and I will surely miss in using A5's IW unless they are hidden or turned off features.

    1. After running a line in IW, it puts the result in the IW window itself. VFP puts it on the desktop by default or any other window you chose. The problem with mixing the results with the commands in the IW window is that it prevents you from appending more code to the previous code and selecting the larger block of code and running it without first cleaning out all the results.

    I also noted that if you edit and execute a line or block of code that you previously executed from IW, the edited block erases/replaces the previous line or block so I'm losing the ability to see all the various ways that did or did not work. VFP handles it by allowing you to edit, add, remove any piece of the block and when you execute it, VFP copies the code to the end of the IW window without changing any of the previously executed lines... (losing history)

    2. There is no Control Z (undo) and I found that by having a block of code highlighted and typing over it and realized that I needed to keep the highlighted code. The other shortcut keys were there, but I could not find the UnDo (Ctrl-Z) anywhere. I did see that the forms allows an UnDo with a non-Windows standard of Alt-Backspace. (Why not use the Windows standard here?)

    3. I also noticed that the IW always forgets what you were working on in the last session as it comes up empty. Look at all the history I'm losing... The history of what I was working on is always helpful, and I would rather be the in charge of clearing it instead of A5 always clearing it... I know you can stop and waste the time to save a copy of it. What about a crash, and executing code in the IW will probably crash it quicker than anywhere else as we are testing all kinds of crazy combinations to achive a resolution of something. All the code that was keyed into IW up until the crash would be lost. (not a good thing, as I would have to duplicate the process and probably crash it again)

    I made some progress yesturday, and now today I wanted to pick up where I left off and guess what? Empty IW... I cannot pickup and continue, as I have to start over by searching for the forum message that had information given by this valuable community in it and start over. (very disappointing to say the least)

    Please do not take offense, as I know A5 has its way, but maybe A5 could be improved in the area of this discussion, which everyone could benefit. I tried to hold back on this one, but felt everyone would benefit if A5 added them. (heck, they may already be there and maybe someone will point them out... I hope) I appreciate this community very much and encourage continued dialog as I kick the tires.

  24. #24
    Member
    Real Name
    Stanley Barnett
    Join Date
    Jun 2008
    Location
    Kentucky
    Posts
    119

    Default Re: VFP FoxPro to Alpha5 Questions

    Hi CALocklin,

    Thanks for your reply and wisdom... I completely agree with you and that is always exactly what I do after I'm committed.

    At this early stage, I'm not committed to spend the enormous amount of time to read everything, as I'm trying to evaluate where A5 stacks up against VFP and the .Net stuff, as I want to make the right choice selecting my next language. I am reading all the stuff and pointers all you are giving me that allows me to do the simple stuff.

    I am still evaluating A5 as it seams quite capable, and so far I haven't seen anything that is a show stopper, so I'll continue on...

    Thanks, Stanley

  25. #25
    Member
    Real Name
    Stanley Barnett
    Join Date
    Jun 2008
    Location
    Kentucky
    Posts
    119

    Default Re: VFP FoxPro to Alpha5 Questions

    ... and much, much more WITH programming a little code, too...
    Glad to see this...

    I've been noticing that there is an large number of forum users that has been a member less than a year. That probably explains why I get mouse and genie answers as most are not coders, instead they totally use the UI...

    In evaluating a language, the language needs to be able to do everything (100%)via code with no execptions. Does A5 fit here?

  26. #26
    Member
    Real Name
    Stanley Barnett
    Join Date
    Jun 2008
    Location
    Kentucky
    Posts
    119

    Default Re: VFP FoxPro to Alpha5 Questions

    Hi DaveM,

    Quote:
    If I understand you correctly, even if the data is encrypted, a 3rd party app can connect to and expose it to disaster... correct?

    So can an exe file be opened with notepad and destroyed. The biggest deal is with the encryption, another alpha adb can't open that table and see the data, nor can anything else open and see the data. It can get garbled up by a hacker. So can a sql table, or any other file.
    1. In my world, a properly secured sql database cannot be opened by unauthorized 3rd party apps.

    2. Also you can also easily protect, hide, and secure a sql database so that anyone with notepad or a hex editor cannot even get to it to perform their magic.

    3. This level of protection is almost impossibe with dbf files on a network, as most must have full access for them to be written to. VFP has the same problem when dealing with their native dbf's, while VFP using a sql backend does not.

    Thanks,
    Stanley

  27. #27
    Member
    Real Name
    Stanley Barnett
    Join Date
    Jun 2008
    Location
    Kentucky
    Posts
    119

    Default Re: VFP FoxPro to Alpha5 Questions

    Hi Cal,

    Avoid using one name 'inside' another like Zipcode and Zipcode4. Better to use Zipcode and Zip4 or Zip_code4. Or, applying rule 1 above, Zipcodef is already unique from Zipcode4f. Another advantage in this case is that you could easily run a search for "zipcode" if you wanted to find all references to either Zipcodef or Zipcode4f. If you ran a search on just "zip" you might also find, for example, references to zip files used for backup routines.
    Are you saying that if I have 3 fields in a table named zipcode1, zipcode2, and zipcode3, and I searched for "12345" that the system can search all 3 fields for the occurance of "12345"...

    If so, Please give me a simple example on how to do this as this is interesting and something VFP cannot do...

    How does the full text search routine work?

    Thanks,
    Stanley

  28. #28
    Member
    Real Name
    Stanley Barnett
    Join Date
    Jun 2008
    Location
    Kentucky
    Posts
    119

    Default Re: VFP FoxPro to Alpha5 Questions

    Hi NoeticCC,

    Presumably, the UI locks because Alpha5 doesn't "want" you to go and be able to edit stuff that is currently being processed...
    But there are many times I'd like to be working on other work unrelated to the long task being performed. I hate waiting till a process finishes before I can go back to work...

    Can a 2nd instance of A5 be opened on the same database with the only thing locked being the executing task on instance 1?

    Thanks,
    Stanley

  29. #29
    "Certified" Alphaholic Keith Hubert's Avatar
    Real Name
    Keith Hubert
    Join Date
    Jul 2000
    Location
    London, UK
    Posts
    6,930

    Default Re: VFP FoxPro to Alpha5 Questions

    Hi Stanley,

    In evaluating a language, the language needs to be able to do everything (100%)via code with no execptions. Does A5 fit here?
    There seems to be no end to what Alpha developers have achieved with Xbasic code, I think it depends on your imagination. Is there a particular test you have in mind?

    With the combination of Xbasic and Xdialog you can build very powerful applications.

    Fortunately you will always find something in Alpha that could be improved, that is what the guys in HQ have been doing for the past 20 years and they are still at it. The point is they do listen to us the developers and end users and do make the requested changes and then some.

    We are a very protective community and like to help every member as positively as possible.

    This forum is a testament to the power and versatility of Alpha Software.

    To answer your question;
    Are you saying that if I have 3 fields in a table named zipcode1, zipcode2, and zipcode3, and I searched for "12345" that the system can search all 3 fields for the occurance of "12345"...

    If so, Please give me a simple example on how to do this as this is interesting and something VFP cannot do...

    How does the full text search routine work?
    See thumbnail.
    Last edited by Keith Hubert; 06-15-2008 at 12:57 AM. Reason: Added thumbnail
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

  30. #30
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: VFP FoxPro to Alpha5 Questions

    Stanley,
    Regarding the IW, you have very valid points and would love to have an automatic save script/code feature for it...currently it can only be saved and restored manually via the top menu for the IW. If noone else puts this into the Wishlist forum, I most likely will. There is also a feature I just found called the Scrapbook in which script can be saved from anywhere it seems.
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




Similar Threads

  1. Alpha5, vers 8 & Alpha5, version 7
    By dchiass in forum Alpha Five Version 8
    Replies: 2
    Last Post: 04-27-2007, 10:16 AM
  2. FoxPro driver
    By David in forum Alpha Five Version 7
    Replies: 5
    Last Post: 02-09-2007, 07:16 PM
  3. Conversion from FoxPro
    By Richard Moore in forum Alpha Four Versions 7 and 8
    Replies: 3
    Last Post: 07-24-2003, 06:08 PM
  4. FoxPro Data
    By Richard Coxe in forum Alpha Five Version 5
    Replies: 6
    Last Post: 11-06-2002, 08:05 AM
  5. Run Dbase/Foxpro program from alpha5
    By crimmelcp in forum Alpha Five Version 4
    Replies: 1
    Last Post: 04-09-2000, 05:27 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •