Ok, so I need to check this. THis is the code of Powerscript

//-------------------------------------

SELECT isnull("t000_hotel_parameters5"."c_short_date_format" , :ls_def)

INTO :this.short_date_format

FROM "t000_hotel_parameters5" ;

//---------------------------------



And this is the conversion result:

//---------------------------------------------

var sql1 = @"SELECT isnull('t000_hotel_parameters5'.'c_short_date_format', @ls_def)

FROM ""t000_hotel_parameters5"" ";

short_date_format = (i_trn.SqlExecutor.Scalar<object>(sql1, ls_def)).ToString();

//----------------------------------------------

Is this correct?

Hi Arcady,



Yes, this is the resulting translation. If you test it out on SnapDevelop you can see that the result is basically the same as of PB embedded SQL.



PowerScript Migrator basically supports all 4 types of embedded SQL. So this example of yours shouldn't be a problem for the tool.



I hope this helps.



Regards,