Escaping quotes like in C#?

[pemo18]

Hello,

Does X# supports the quoting mechanismn of C# like

string sqlCommand = @"Select Nachname ""Nachnahme"" From Adressen";

which results to Select Nachname "Nachnahme" From Adressen

this would bei helpful for building SQL commands with aliases that works with Postgre for example.

Right now we would use something like Nachname 'Nachname' and StrTran() for replacing ' with Chr(34) which works well

Kind regards,
Peter

[lumberjack]

Hi Peter,

Does X# supports the quoting mechanismn of C# like

Yes

Code: Select all

string sqlCommand = @"Select Nachname ""Nachnahme"" From Adressen";
LOCAL sqlCommand := "Select Nachname ""Nachnahme"" from Adressend" // Double quote notation AS STRING
or
LOCAL sqlCommand := e"Select Nachname "Nachnahme" from Adressend" // Escaped string nrt etc...

[pemo18]

Oh, thats good (so I did no try hard enough to make it work;)

Regards,
Peter

[pemo18]

Hi Johan,

Are you sure about the first option?

I could only make it work with the second option (e and ) which I like better because its more readable.

Regards,
Peter

[FFF]

I think, Johan mixed the " and ' ...
And don't forget, there are differences in behaviour between core and the dialects!

@Chris, now you have the reason, why 'Chris is "great" ' should work, too, as does "Chris is 'great' "
Some time ago we discussed why that's not handled equal

[Chris]

Never said that they should not both be supported! (the features I mean, not the content )
This is why they are both allowed now in X# for VO and other dialects (while single quotes were not supported in vulcan). In Core, this is not supported, in order to make the syntax more .Net-friendly, because .Net languages use single quotes for the Char type.

About the "abc""def""ghi" syntax, this is indeed not supported, I remember we had discussed about it, but can't remember what was decided . Will open a feature request for it.

[robert]

Guys,
Do you really want another string format ?
We already have
- double quoted strings ("abc'[]")
- single quoted strings ('abc"[]')
- bracketed strings ([abc'"])
- interpolated strings (i"abc{i}")
- extended strings ( e"trn")
- extended interpolated strings (ei"r{i}" and ie"r{i}")
- character literals ('a' or c'a')

We are planning to add binary literals like in FoxPro (0h202020), but I personally think that is enough.

Robert

[FFF]

Robert,
i'd say, if ' "abc" ' works, like " 'abc' " does, it would be enough - but this variant indeed would come handy for the SQL writers...

[Chris]

Robert,

The problem is that single quoted strings do not work in Core dialect. Only way to workaround this is with escaped strings, but this syntax is difficult to read. So since c# supports the syntax "abc""def", I think it would be nice to support it in X# as well. Of course it's not high priority...