Search results for query: *

Well, when you get the results you show it's a sign VFP can't cope with the driver. I already told you that getting a connection isn't proof of the driver working for VFP. In the threads I pointed out the testing was including queries, not just inserts. Besides that, query results like you show...

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...

Yes, I pointed 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(*)...

Here for reference: https://www.tek-tips.com/threads/running-sqlexec-on-mysql-database-continued.1830399/ https://www.tek-tips.com/threads/mysql-connection-string-using-latest-driver.1830568/

Well, you ignored what I said and just listened to Tore plus assume getting a connection handle already proves a driver works. I'm serious here, the driver you use must be changed. You can of course create a DSN, but the final truth about a driver working is with actively working on data in all...

By the way, the ANSI va UNICODE drivers are not catering for the encoding of the data, but Windows major distinction of processes using the Unicode vs ANSI aPI of Windows itself and secondary and related to that using ANSI (several code pages vs Unicode (UTF16 or UCS2) strings in the string...

I searched myself and found the thread, where listed drivers they used and worked vs not worked: https://www.tek-tips.com/threads/running-sqlexec-on-mysql-database-continued.1830399/ You'll see I had questions about the specific construct of server and client, but that turned out to be okay, a...

I assume with crashing you mean you get a C5 error and the VFP process really crashed. VFP isn't a Unicode application, except perhaps you're using VFPA. SYou say you use VFP9, so that's it, I think. You also get problems with the latest ANSI drivers, search VFP MySQL here in the forum and...

I'd say it depends whether you drag&drop the mail item or drag an attachment in an opened mail. You can drag so many things, that it's quite impossible to write exhaustive code that covers all cases. Seems to me you found a way to cope with a mail item dragged into your VFP application and get...

The usual stuff, which may still be unknown to you at least the VFP way. 1. Error handling with ON ERROR, the Error event and TRY..CATCH...ENDTRY 2. Break points, especially in reports with code 3. Ensuring the current workarea has data, otherwise the report will not be empty, it just won't show...

Perhaps I should add, BlueSharpe, what I explained was a basic concept not only of reports. If you take that concept of the current workarea into consideration you automatically arrive at a solution that differs from what I assume you're doing. But I don't exactly know what your doing, until...

I wouldn't wonder in detail about what goes on there, it's up on BlueSharpe to provide more details. I would imagine you open up some tables to design the report, as that allows to make use of the Expression Builder dialog, for example. Then the rerpot runs fine from the report designer preview...

Since you're completely new, there are two standard ways to feed a report with data. 1. The report has a private data session and you add the table or tables you want to print in the reports data environment 2. The has no private data session and you feed it from whatever is the current...

To be very clear about PACK: It's neither documented that it creates new files nor what file extensions they get, it's only clearly known from experience. Likewise that once it completes you have the same filenames and no kept bak or other files. What file extensiosn PACK uses is undocumented...

Okay, I experimented a bit and in case someone modifies a table with the table designer, one of two cases apply: a) the table designer uses the dbf exclusive and no other user can open it b) the table designer does not get exclusive access and only shows the dbf structure in read only mode...

No, you were asking "Does the 'strange name' have any pattern?" and all I was saying is that VFP only chnages the extension of files it works on or creates temporary files with other extensions than normal to finally rename them. If you search the help for bak or .bak you don't find PACK, so...

Just one obvious thing nobody mentioned - maybe because it's obvious: The best protection against data loss, no matter if by table corruption or the file deletion you encountered, is a backup of data. That should be a feature of your software. You're concentrating very much on just the problem...

Sorry, I got this wrong. You also said: "In one case, the owner is the only one using our software. There isn't any good reason to sabotage himself." I took that as there being a single user mode, where you might give the user the ability to modify the tables. There could also be the case...

Have you even found a bak file? The only documented case for a bak file is using the table designer. And that's not a runtime feature. If you just work on data with either APPEND, REPLACE and (xBase) DELETE or SQL INSERT/UPDATE/DELETE you never get a bak file.

I agree with what ggreen said last. But when your dbf is missing after an alter table or using the table designer to change the structure, that means storing the latered table failed and you may have the old structure in a DBC or have some informations about the table updated, some not. In...