Hi There, I am using Genious@Work Product Edtition 3-2000 for about 2 years and I am really happy about it. There is one little thing that might be rather a MS Problem than a Genious but I am interested if other users know this too.

Afer importing from an MS SQL Server everything works fine except that Contacts with no Data in the for instance Telefon Field do have a lot of unterlines in Outlook instead of beeing empty. When you then click in the field the underlines were gone.

Because we were using a Phonetool for searching Contacts it is quiet annoying if Contacts were showing up without data. They should just be empty as they were in the SQL DB. We were using Outlook 2003 SP3. Any ideas about that ? Thx in advance

Is it possible you are using char datatype in DB and the data is filled with space char ?

Wow - this was fast...Yes you were right. It is char datatype in DB but i cannot change that. any hint for fixing this ?

You can create a VIEW and convert the CHAR to varchar in the view.
Map then the View (in GeniusConnect) instead of the Table

I am alreday using a VIEW:

SELECT TOP 100 PERCENT II.KAdresse.Name, II.KAdresse.Adresse1, II.KAdresse.Adresse2, II.KAdresse.Adresse3, II.KAdresse.Postleitzahl, II.KAdresse.Ort,
II.KAdresse.Telefon, II.KAdresse.Telefax, II.KAdresse.KAdrKdn, II.Kunde.GDStatus, II.KAdresse.Telefon10, II.KAdresse.Natel, II.KAdresse.Telefon9,
II.KAdresse.Telefon7, II.KAdresse.Telefon8, RTRIM(II.KAdresse.Name) + ',' + ' ' + II.KAdresse.Adresse1 + ' ' + II.KAdresse.Telefon7 AS FileAs
FROM II.KAdresse INNER JOIN
II.Kunde ON II.KAdresse.KAdrKdn = II.Kunde.Kunde
WHERE (II.Kunde.GDStatus = 1)
ORDER BY II.KAdresse.Name

But how do i convert the Telefon fields ? Unfortunately, I am not a real SQL specialist...

CAST(II.KAdresse.Telefon9 AS varchar( XXXX ))

to name the converted field:
CAST(II.KAdresse.Telefon9 AS varchar( XXXX )) as Telefon9

Thx a lot...I think this might work - at least in the view it`s alreday diffrent when clicking in the fields. No the cursor is at the beginning and not somewhere in the middle... ;-)). Thx