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...
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...
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...
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...
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...
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...
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.
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...
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
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...
...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...
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...
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...
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...
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/...
...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...
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...
...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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.