Devart Forums

davidmarcus

I do

set names utf8mb4 collate utf8mb4_unicode_520_ci

davidmarcus

My Delphi app is using Unicode. I have Options.UseUnicode = True and Options.CharSet = 'utf8mb4'. I think my app is working. I did test it back then. But, if your app is using Latin 1, then I don't know what happens.

davidmarcus

I think utf8mb4 works with MyDAC. See viewtopic.php?f=7&t=31291

davidmarcus

I don't know. I usually use TMyCommand to do updates. I don't know what TMyQuery can do.

davidmarcus

Not sure I understand the question. If you have multiple clients updating the same data, you need some form of locking. There are various ways to do this.

davidmarcus

If I do a query that has more than one statement, the results are shown in tabs, e.g., "Query1", "Query2". Is there a way to switch between the tabs using the keyboard?

With other clients, I start my session by doing

Code: Select all

set names 'utf8mb4' collate 'utf8mb4_unicode_520_ci';

When I do this in dbForge, it says

Characer set 'utf8mb4' is not supported

I'm using the trial version of dbForge Studio 202 for MySQL 9.0.791. The server is MariaDB 10.3.31 or 10.3.25

davidmarcus

What is your purpose in doing this?

davidmarcus

Documentation for TMyWarningEvent and TMyErrors would be helpful. Also, EMyError has an ErrorLevel property that is not documented.

davidmarcus

The Help for the TMyScript Class and the TMyCommand Class give the impression that TMyCommand can only execute one SQL statement at a time. However, the code for TMyCommand uses the CLIENT_MULTI_STATEMENTS flag, so TMyCommand can handle multiple statements separated by semicolons.

davidmarcus

Use TMyQuery.

davidmarcus

select sum(...) as Foo ...

DM.GetRecCount.FieldByName( 'Foo' ).AsInteger

davidmarcus

If you use TMyCommand, there is a RowsAffected property.

davidmarcus

The Help for "TMyConnection.Options Property" says, "Descriptions of all options are in the table below", but if you go to the page for "TMyConnectionOptions Members", you find that there are more options.

MyDAC 10.1.3

davidmarcus

The Help page Using MyDAC > Increasing Perfomance refers to

T:Devart.MyDac.TMySQL
TDAUpdateSQL

These don't appear to exist.

The page also refers to

P:Devart.Dac.TDADataSetOptions.CompressBlobMode

This option does exist, but maybe the Help meant to link to it.

MyDAC 10.1.3.

davidmarcus

Code: Select all

procedure ProcessRecord( Query: TMyQuery );
begin
   ..
   var1 := Query.FieldByName('field1').AsString;
   var2 := Query.FieldByName('field2').AsInteger;
   ..
end;

The compiler will just pass the pointer to the TMyQuery object.

Devart Forums

Search found 54 matches

Re: 'utf8' charset is now deprecated

Re: 'utf8' charset is now deprecated

Re: 'utf8' charset is now deprecated

Re: How can I control which field are being updated?

Re: How can I control which field are being updated?

Switch query tabs via keyboard

Re: Best way to check if database server available

Re: New Event tmyConnection.onwarning

Help should clarify capabilities of TMyCommand vs TMyScript for multiple statements

Re: Get OUT Param with TMyCommand

Re: Get OUT Param with TMyCommand

Re: ExecSQL Result

Help for TMyConnection.Options incorrectly says it lists all options

"Increasing Perfomance" Help page needs updating

Re: TMyQuery, read whole record at once?