Accented field names

Francois Van Lerberghe fvanlerberghe at freegates.be
Wed Jun 16 18:31:31 CDT 2004


le 16/06/04 16:40, Ruslan Zasukhin <sunshine at public.kherson.ua> a écrit :

> On 6/16/04 5:30 PM, "Aaron Bratcher" <aaronbratcher at ontargetreports.com>
> wrote:
> 
>> Valentina gives me a 603 error when doing the this query in viSQL:
>> SELECT Référence FROM Contacts
>> 
>> Does Valentina have problems with accented field names?
> 
> Try wrap them by []

Mmmh, I think it's an encoding issue, since it's perfectly working here with
RB 3.5

Assuming that
- the SQLString = "SELECT Référence FROM Contacts"
- that this string is from an EditField
- and RB 5 default encoding for EditField is UTF8,
perhaps it's needed to convert the string to a MacRoman encoding or any
other default system encoding ?


François Van Lerberghe
Rue Thier Monty, 15 A
4570 Marchin
Belgique



More information about the Valentina mailing list