Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. C

    Foxpro for dos on windows 10

    I have posted a solution. I n fact the only solution that would work by your conditions to not virtualize. I mean, when you don't realize DOSBOX-X is a vitrtualization solution, you have not understood the sentence If I would overlook your condition, there's one more very frequently used other...
  2. C

    Query returning memo fields instead of strings ( MariaDB )

    Makes me wonder why would anyone still use tinytext, which is limited to 256 bytes, so it's just like varchar(256) and it will turn to memo, because 256>254, as simple as that. And once you look up what tinytext in a MySQL or MariaDB can store, you know how it doesn't compare to simple...
  3. C

    Foxpro for dos on windows 10

    You are now using a virtual environment, just saying. There's nothing wrong with that.
  4. C

    Foxpro for dos on windows 10

    Autoexec.bat would define what starts automatically, not autoexe, nor autoexec alone. And it has to be in the start drive, that's still the same when it comes to a DOS emulator like DOSBOX-X, doesn't it? Well, and otherwise you get to the command prompt. You're as free to start what you want to...
  5. C

    Query returning memo fields instead of strings ( MariaDB )

    Still not clear what you had. If it was varchar(20) and varchar(50) you have to do CursorSetProp("MapVarchar",.T.,0) and you should also have CursorSetProp("MapBinary",.T.,0). Before doing any query, once at the start of a datasession. Anyway, memo does no harm, you can bind both a textbox and...
  6. C

    Foxpro for dos on windows 10

    Reference? If you have one, I think they first must have installed DOS itself. Windows isn't DOS based since Win98 and so that's about 30 years. DOS simply is a separate Installation and you'll need an original MS DOS. And then compatibility isn't an issue, you install FP DOS or an FP DOS...
  7. C

    Query returning memo fields instead of strings ( MariaDB )

    In general to have control about the result field types on the VFP side it's most elegant to use remote views or cursoradapter instead of SQLEXEC. Anyway, if your MariaDB column is shorter than 255 it will arrive as char or varchar in VFP with no need to CAST, if you need to CAST to get a...
  8. C

    Query returning memo fields instead of strings ( MariaDB )

    Maximum for a VFP DFB char field is 254 characters, so anything longer is turned into a memo. So if your MariaDB is overdimensioned in these fields, shorten them. If that's okay with the data, the memo field type is what you'll need and want and there's nothing wrong about that.
  9. C

    Printer Icon on Print Preview looping

    Could you post your REPORT FORM commands, whether you use VFP9, and if so whether you print with reportbehavior 80 or 90. You might be using the 90 mode with the reportpreview.app/reportoutput.app in the IDE - running source code, and missing to provide them with the exe, so it falls back to...
  10. C

    reversed words in english leading new english words

    Even VBA has StrReverse(), so whatever word list you have, reversing that is simple and fast, T-SQL also has a function you could use after importing the word list: https://learn.microsoft.com/en-us/sql/t-sql/functions/reverse-transact-sql?view=sql-server-ver16
  11. C

    Foxypreviewer commercial license

    The pricing page gives you an email address. Are you saying you mailed them about redistribution and got no response?
  12. C

    reversed words in english leading new english words

    One last thing to say. Since I only look for the reversed word in the words I already have, instead of looking up the reversed word on a website, I first keep it self referential. Doing it the way you do, the reversed word may not be in your original list, but found on dictionary.com anyway, so...
  13. C

    reversed words in english leading new english words

    ...675 rows. That computes with the 1220 word list as it has 545 pairs of words differing with their reversed counterpart and 130 palindromes, so 545*2+130=1220. It makes it easier to lookup whether both word and semordnilap are valid words and the pair can be counted in. The word in this data...
  14. C

    reversed words in english leading new english words

    For reference I wrote a repro to anyone using VFP. I now also know what I forgot in the data cleaning: Only keeping all lower case words, which gets rid of any abbreviations and acronyms. In this run I kept words where the first letter is larger than the last letter, so all pairs and...
  15. C

    reversed words in english leading new english words

    The gateman checked the nametag against the guest list. That's my favorite so far from my own list: gateman/nametag. I got a list of ~1000 from ~466k words from https://github.com/dwyl/english-words/blob/master/words.txt I removed single letters, words with a period and an apostrophe and only...
  16. C

    reversed words in english leading new english words

    What do you think of when you think of subsets? I imagine you can forget to find words ending with uq, for example, i.e. there are letter combinations only making sense in one way, not reversed. But then there is bouquet, for example, which has uq in it. In short, I think of that as a problem...
  17. C

    MySql to VFP cursor

    The result Claudio Costa showed (click on the image, don't just look at the empty thumbnail) is similar to what AzNative showed in https://www.tek-tips.com/threads/running-sqlexec-on-mysql-database-continued.1830399/...
  18. C

    MySql to VFP cursor

    ...like date type rpoblems. So it's a strong sign you're still using a wrong driver version. With the correct driver a simple query like SELECT * FROM table could only fail on very exotic data types. That's why you were asked about that. I add to that, a problematic data type would actually...
  19. C

    MySql to VFP cursor

    By the way: It doesn't suffice to install the correct driver. If you still use SQLCONNECT('WebBrowser', 'root', 'mysql') and didn't define a new DSN or changed the configuration of the WebBrowser DSN you already have to use the 8.0.33 driver, then you still get the same erroneous behavior. How...
  20. C

    MySql to VFP cursor

    ...out MariaDB Drivers may work, too in the other thread. Since you say that the question now is which one. Assuming you indeed installed 8.0.33 the question that's most relevant is what data type the referencia column of the artigos table is and what you get from SELECT Count(*) from artigos.

Part and Inventory Search

Back
Top