[firebird-support] Error opening a database

2019-12-02 Thread Tony Christiansen t...@adegroup.com.au [firebird-support] 
We have FB3.0.3 installed on a server with 200 odd users each accessing 
their own database.

A number have reported this error when attempting to open a database today.

Internal Firebird consistency check (cannot start garbage collector thread)
IProvider::attachDatabase failed when loading mapping cache

What would cause this and what remedy would be possible.

Sincere thanks
Tony

[firebird-support] Re: A recommendation (database migration)

2019-12-02 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support] 
'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] a écrit :
> Is this link permanent? if so, and if you agree, I can publish it at
> firebirdnews.org
>
> []s
> Carlos
> www.firebirdnews.org - www.FireBase.com.br

it can be and if there is any other problem I can fix it.

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Re: A recommendation (database migration)

2019-12-02 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] 
Is this link permanent? if so, and if you agree, I can publish it at
firebirdnews.org

[]s
Carlos
www.firebirdnews.org - www.FireBase.com.br

NSGntefs> 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] a écrit :
>> Hi!
>>
>> If you have a compiled version with the fix, I think a lot of people
>> would enjoy if you can share the executable ;-)

NSGntefs> done http://tetrasys.fi/data/ibpump.7z







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] A recommendation (database migration)

2019-12-02 Thread Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] 
I do know that - just have never tried the cross platform yet but would love 
to.  :)



Thanks!
Kevin







 

> On Dec 2, 2019, at 11:12 AM, Karol Bieniaszewski liviusliv...@poczta.onet..pl 
> [firebird-support]  wrote:
> 
> 
> >> That’s part of the issue - I’m a Delphi guy and not sure I could get it 
> >> cross platform.
> 
>  
> Delphi is crossplatform.
> 
> It suport Windows, macOS, iOS, Android and now Linux from one codebase.
> 
>  
> Regards,
> 
> Karol Bieniaszewski
> 
> 
> 



[Non-text portions of this message have been removed]

[firebird-support] Re: A recommendation (database migration)

2019-12-02 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support] 
'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] a écrit :
> Hi!
>
> If you have a compiled version with the fix, I think a lot of people
> would enjoy if you can share the executable ;-)

done http://tetrasys.fi/data/ibpump.7z

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] A recommendation (database migration)

2019-12-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
02.12.2019 19:19, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] 
wrote:
> If you have a compiled version with the fix, I think a lot of people
> would enjoy if you can share the executable ;-)

   I'm sorry, I'm not sure if I'm allowed to share it.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

ODP: [firebird-support] Re: A recommendation (database migration)

2019-12-02 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] 
>> That’s part of the issue - I’m a Delphi guy and not sure I could get it 
>> cross platform.

Delphi is crossplatform. 
It suport Windows, macOS, iOS, Android and now Linux from one codebase.

Regards,
Karol Bieniaszewski

Re: [firebird-support] A recommendation (database migration)

2019-12-02 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] 
Hi!

If you have a compiled version with the fix, I think a lot of people
would enjoy if you can share the executable ;-)

Carlos
www.firebirdnews.org - www.FireBase.com.br

DSsicfs> 02.12.2019 18:28, 'Carlos H. Cantu' lis...@warmboot.com.br 
[firebird-support] wrote:
>> IB DataPump from Clevercomponents has problems with FB 3, but now it
>> is open source. It is made in Delphi. If someone interested and with
>> some free time can fix the problem and even update the application:
>> 
>> https://github.com/CleverComponents/Interbase-DataPump/

DSsicfs>Nice to see that it is open source. If the problem is
DSsicfs> "Index out of range" error then 
DSsicfs> here is the patch for it:

DSsicfs> --- ibpMain.pas2002-11-01 03:40:02.0 +0100
DSsicfs> +++ ibpMain.pas.new 2019-02-18 19:23:28.403022900 +0100
DSsicfs> @@ -2177,7 +2177,8 @@
DSsicfs>   begin
DSsicfs> rd.Add(TrimRight(qryFree.Fields[0].AsString));
DSsicfs> i := lst.IndexOf(rd[rd.Count-1]);
DSsicfs> -  lst.Delete(i);
+  if i >>= 0 then
DSsicfs> +lst.Delete(i);
DSsicfs> DelDep(rd[rd.Count-1]);
DSsicfs> qryFree.Next;
DSsicfs>   end;

Re: [firebird-support] A recommendation (database migration)

2019-12-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
02.12.2019 18:28, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] 
wrote:
> IB DataPump from Clevercomponents has problems with FB 3, but now it
> is open source. It is made in Delphi. If someone interested and with
> some free time can fix the problem and even update the application:
> 
> https://github.com/CleverComponents/Interbase-DataPump/

   Nice to see that it is open source. If the problem is "Index out of range" 
error then 
here is the patch for it:

--- ibpMain.pas 2002-11-01 03:40:02.0 +0100
+++ ibpMain.pas.new 2019-02-18 19:23:28.403022900 +0100
@@ -2177,7 +2177,8 @@
  begin
rd.Add(TrimRight(qryFree.Fields[0].AsString));
i := lst.IndexOf(rd[rd.Count-1]);
-  lst.Delete(i);
+  if i >= 0 then
+lst.Delete(i);
DelDep(rd[rd.Count-1]);
qryFree.Next;
  end;


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] A recommendation (database migration)

2019-12-02 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] 
IB DataPump from Clevercomponents has problems with FB 3, but now it
is open source. It is made in Delphi. If someone interested and with
some free time can fix the problem and even update the application:

https://github.com/CleverComponents/Interbase-DataPump/

[]s
Carlos
Migration Guide do FB 3
https://www.firebirdnews.org/migration-guide-to-firebird-3/

KSKSRScfs> Greetings!

KSKSRScfs> We are in the middle of migrating from FB 1.56 to 3.x.

KSKSRScfs> Of course the recommendation is to create a script of the
KSKSRScfs> database and run it against FB 3 which we’ve done.  We’ve
KSKSRScfs> also purchased the Migration Guide to Firebird 3.

KSKSRScfs> Now comes the challenge - getting the data over.  Some of
KSKSRScfs> our customers have millions and millions of records.
KSKSRScfs> The recommendation is to use a tool to pump the data over.
KSKSRScfs> Clever Components has a tool but it seems really out-dated
KSKSRScfs> and not very intuitive.  This tool is a suggestion in the Migration 
Guide.

KSKSRScfs> I understand not having a GUI tool with Firebird as there
KSKSRScfs> are a few really good ones out there.  (IB Expert is my must-have 
tool)

KSKSRScfs> However, I t think it’s imperative FB has a database
KSKSRScfs> migration tool..  We should not have to rely on any 3rd
KSKSRScfs> party tools to upgrade a database.

KSKSRScfs> Here’s what I would love to see the process being:

KSKSRScfs> Have a tool to analyze the current database.  This can
KSKSRScfs> already be done by creating a script and running it against the 
target version of FB.
KSKSRScfs> Once the database is created successfully with no errors
KSKSRScfs> or warnings in step 1, all we should have to do is backup
KSKSRScfs> the database in the older version of FB and restore it in
KSKSRScfs> the target version.  I know triggers and stored procedures
KSKSRScfs> don’t get recompiled, but they should somehow.  I’m sure
KSKSRScfs> the Firebird Gurus can figure this one out.  :)
KSKSRScfs>   

KSKSRScfs> I would be happy to donate time to help in anyway I can.
KSKSRScfs> This is an awesome database and I can’t say enough about FB and the 
developers.


KSKSRScfs> Just some thoughts here as I go through the
KSKSRScfs> (so-far-painful) migration process.


KSKSRScfs> Best Regards,
KSKSRScfs> Kevin




KSKSRScfs> [Non-text portions of this message have been removed]



KSKSRScfs> 
KSKSRScfs> Posted by: Kevin Stanton 
KSKSRScfs> 

KSKSRScfs> ++

KSKSRScfs> Visit http://www.firebirdsql.org and click the Documentation item
KSKSRScfs> on the main (top) menu.  Try FAQ and other links from the left-side 
menu there.

KSKSRScfs> Also search the knowledgebases at
KSKSRScfs> http://www.ibphoenix.com/resources/documents/ 

KSKSRScfs> ++
KSKSRScfs> 

KSKSRScfs> Yahoo Groups Links

[firebird-support] Re: A recommendation (database migration)

2019-12-02 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support] 
Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] a 
écrit :
> That’s part of the issue - I’m a Delphi guy and not sure I could get it cross 
> platform.
>
I use Delphi also but would be more interesting to start on codetyphon 
(free pascal).
we wait for another opinion.

-- 
Norbert Saint Georges
http://tetrasys.fi

Re: [firebird-support] Fail to create external table

2019-12-02 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] 
Den 2019-12-02 kl. 16:56, skrev Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support]:
> 02.12.2019 16:35, Kjell Rilbe kjell.ri...@marknadsinformation.se 
> [firebird-support] wrote:
>> Any ideas?
> In short: give up. Just give up.
> In long: both client side and server side ANSI code pages must support 
> these letter.

They do. All involved operating systems use Windows-1252.

I realized now that I failed to actually set the connection charset for 
the isql session.

I tried now with "chcp 1252" then start isql.exe and before connect 
issue "set names win1252;" command. In that state, I was able to select 
existing UTF-8 data and get it properly translitterated in the isql session..

In this state, I tried again to create the external table, and again got 
the file name "Teståäö.txt" which is the Win1252 interpretation of 
"Teståäö.txt" in UTF-8 encoding.

In other words, it would seem that isql.exe correctly transliterated my 
win1252 encoded input string "Teståäö.txt" and sent it to the server 
that way. The server database character set it UTF-8, so I suspect that 
the server then transliterates the file name into an UTF-8 string and 
passes that to the file system using an non-unicode API call, that would 
then expect the string to be encoded with the operating system's code 
page, in this case Windows-1252. I think that's where the error occurs.

Should I report this as a bug? I.e. that Firebird server engine fails to 
transliterate the file name for an external table from the database 
character set into the OS character set when making OS API calls for the 
corresponding file operations.

Regards,
Kjell




[Non-text portions of this message have been removed]

[firebird-support] Re: A recommendation (database migration)

2019-12-02 Thread blackfalconsoftw...@outlook.com [firebird-support] 
Kevin...
 

 EMS Sql Manager has a great list of tools for Firebird and Interbase that will 
provide the very processes you are looking for...  https://www.sqlmanager.net 
https://www.sqlmanager.net
 

 Granted these are commercial products but I have been using them for years and 
have found them to be quite reliable with decent technical support as well.
 

 However, if you are interested in developing such a tool, maybe we could 
collaborate.  I work with the Microsoft development products and primarily 
develop for the desktop in VB.NET but I am fluent in C#.  I haven't done any 
web development in years and prefer to stay away from it given the complete 
mess such development has become...
 

 With regards,
Steve Naidamast
Sr. Software Engineer

Re: [firebird-support] A recommendation (database migration)

2019-12-02 Thread Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] 
That’s part of the issue - I’m a Delphi guy and not sure I could get it cross 
platform.




 

> On Dec 2, 2019, at 8:51 AM, Norbert Saint Georges n...@tetrasys.eu 
> [firebird-support]  wrote:
> 
> Kevin Stanton kevin.stan...@rdb-solutions.com 
>  [firebird-support] a 
> écrit :
> > I would be happy to donate time to help in anyway I can. This is an awesome 
> > database and I can’t say enough about FB and the developers.
> 
> Hello,
> 
> Your tool would be developed in what language? and for which platform?
> 
> -- 
> Norbert Saint Georges
> http://tetrasys.fi 
> 
> 



[Non-text portions of this message have been removed]

[firebird-support] Re: A recommendation (database migration)

2019-12-02 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support] 
Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] a 
écrit :
> I would be happy to donate time to help in anyway I can. This is an awesome 
> database and I can’t say enough about FB and the developers.

Hello,

Your tool would be developed in what language? and for which platform?

-- 
Norbert Saint Georges
http://tetrasys.fi

Re: [firebird-support] Fail to create external table

2019-12-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
02.12.2019 16:35, Kjell Rilbe kjell.ri...@marknadsinformation.se 
[firebird-support] wrote:
> Any ideas?

   In short: give up. Just give up.
   In long: both client side and server side ANSI code pages must support these 
letter.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] A recommendation (database migration)

2019-12-02 Thread Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] 
Greetings!

We are in the middle of migrating from FB 1.56 to 3.x.

Of course the recommendation is to create a script of the database and run it 
against FB 3 which we’ve done.  We’ve also purchased the Migration Guide to 
Firebird 3.

Now comes the challenge - getting the data over.  Some of our customers have 
millions and millions of records.
The recommendation is to use a tool to pump the data over.  Clever Components 
has a tool but it seems really out-dated and not very intuitive.  This tool is 
a suggestion in the Migration Guide.

I understand not having a GUI tool with Firebird as there are a few really good 
ones out there.  (IB Expert is my must-have tool)

However, I t think it’s imperative FB has a database migration tool..  We 
should not have to rely on any 3rd party tools to upgrade a database.

Here’s what I would love to see the process being:

Have a tool to analyze the current database.  This can already be done by 
creating a script and running it against the target version of FB.
Once the database is created successfully with no errors or warnings in step 1, 
all we should have to do is backup the database in the older version of FB and 
restore it in the target version.  I know triggers and stored procedures don’t 
get recompiled, but they should somehow.  I’m sure the Firebird Gurus can 
figure this one out.  :)
  

I would be happy to donate time to help in anyway I can. This is an awesome 
database and I can’t say enough about FB and the developers.


Just some thoughts here as I go through the (so-far-painful) migration process.


Best Regards,
Kevin




[Non-text portions of this message have been removed]

[firebird-support] Fail to create external table

2019-12-02 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] 
Hi,

Using Firebird 3.0.4.33054 on WIndows (64 bit), I want to create an 
external table where the external file name contains Swedish letters. I 
would think this is a reasonable desire these days.

After failing to get the character encoding right in FlameRobin, I 
thought I'd try isql.exe.

So I fired up a command prompt, set codepage to UTF-8 (chcp 65001). Then 
connected to my database in isql and did a select to check that it 
indeed does display existing UTF-8 data correctly, to ensure that I 
actually got the connection character set right. Seems to work.

Then I try this SQL:

create table "ExSlask" external file 'D:\MISE\Data\Firebird\Teståäö.txt' 
("Id" char(5) character set win1252, "CRLF" char(2) character set win1252);

When I press enter, isql.exe exits without any message whatsoever. I'm 
just returned to the Windows command prompt. No external table is created.

Any ideas?

The same SQL executes fine in FlameRobin, but the resulting file name is 
"Teståäö.txt", which means that FlameRobin and/or Firebird fails to 
correctly convert the UTF-8 encoded string in the SQL into the file 
system's encoding (Win1252). I have FlameRobin connected using UTF-8 
connection charset.

Mvh,
Kjell



[Non-text portions of this message have been removed]

Re: [firebird-support] What key word specifies a search for an entire word?

2019-12-02 Thread Richard Damon rich...@damon-family.org [firebird-support] 
On 12/2/19 5:06 AM, Tjioe Hian Pin thp_p...@yahoo.com [firebird-support]
wrote:
>  
> what about:
>
> SELECT fstName, fiKeyID FROM Members WHERE ' '||fstName||' '
> containing ' '||@po||' '
>
> Cheers,
> Tjioe
>
Again, that is likely prevent use of an index to find the record, and
force a table scan. Why not just use WHERE fstName = @po

-- 
Richard Damon

Re: [firebird-support] What key word specifies a search for an entire word?

2019-12-02 Thread Tjioe Hian Pin thp_p...@yahoo.com [firebird-support] 
 what about:

SELECT fstName, fiKeyID FROM Members WHERE ' '||fstName||' ' containing ' 
'||@po||' '

Cheers,Tjioe
On Saturday, November 30, 2019, 02:20:00 PM GMT+7, Mark Rotteveel 
m...@lawinegevaar.nl [firebird-support]  
wrote:  
 
     
On 29-11-2019 22:52, Clyde Eisenbeis cte...@gmail.com [firebird-support] 
wrote:
> The fstName is the column title, not the value.  I'm using embedded 
> Firebird.

That you're using Firebird Embedded doesn't matter, it works exactly the 
same as Firebird Server for queries. The problem is that your using two 
conditions on column fstName using AND. That means for a single row both 
conditions must be true for that column.

The conditions

lower(fstName) LIKE lower(@p0)
AND lower(fstName) LIKE lower(@p1)

will only be true if both @p0 and @p1 can match the same value, which I 
think is unlikely for a column which contains first names. Maybe you 
meant OR instead?

Mark
-- 
Mark Rotteveel

  #yiv986025 #yiv986025 -- #yiv986025ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv986025 
#yiv986025ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv986025 
#yiv986025ygrp-mkp #yiv986025hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv986025 #yiv986025ygrp-mkp #yiv986025ads 
{margin-bottom:10px;}#yiv986025 #yiv986025ygrp-mkp .yiv986025ad 
{padding:0 0;}#yiv986025 #yiv986025ygrp-mkp .yiv986025ad p 
{margin:0;}#yiv986025 #yiv986025ygrp-mkp .yiv986025ad a 
{color:#ff;text-decoration:none;}#yiv986025 #yiv986025ygrp-sponsor 
#yiv986025ygrp-lc {font-family:Arial;}#yiv986025 
#yiv986025ygrp-sponsor #yiv986025ygrp-lc #yiv986025hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv986025 
#yiv986025ygrp-sponsor #yiv986025ygrp-lc .yiv986025ad 
{margin-bottom:10px;padding:0 0;}#yiv986025 #yiv986025actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv986025 
#yiv986025activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv986025
 #yiv986025activity span {font-weight:700;}#yiv986025 
#yiv986025activity span:first-child 
{text-transform:uppercase;}#yiv986025 #yiv986025activity span a 
{color:#5085b6;text-decoration:none;}#yiv986025 #yiv986025activity span 
span {color:#ff7900;}#yiv986025 #yiv986025activity span 
.yiv986025underline {text-decoration:underline;}#yiv986025 
.yiv986025attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv986025 .yiv986025attach div a 
{text-decoration:none;}#yiv986025 .yiv986025attach img 
{border:none;padding-right:5px;}#yiv986025 .yiv986025attach label 
{display:block;margin-bottom:5px;}#yiv986025 .yiv986025attach label a 
{text-decoration:none;}#yiv986025 blockquote {margin:0 0 0 
4px;}#yiv986025 .yiv986025bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv986025 
.yiv986025bold a {text-decoration:none;}#yiv986025 dd.yiv986025last 
p a {font-family:Verdana;font-weight:700;}#yiv986025 dd.yiv986025last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv986025 
dd.yiv986025last p span.yiv986025yshortcuts 
{margin-right:0;}#yiv986025 div.yiv986025attach-table div div a 
{text-decoration:none;}#yiv986025 div.yiv986025attach-table 
{width:400px;}#yiv986025 div.yiv986025file-title a, #yiv986025 
div.yiv986025file-title a:active, #yiv986025 
div.yiv986025file-title a:hover, #yiv986025 div.yiv986025file-title 
a:visited {text-decoration:none;}#yiv986025 div.yiv986025photo-title a, 
#yiv986025 div.yiv986025photo-title a:active, #yiv986025 
div.yiv986025photo-title a:hover, #yiv986025 
div.yiv986025photo-title a:visited {text-decoration:none;}#yiv986025 
div#yiv986025ygrp-mlmsg #yiv986025ygrp-msg p a 
span.yiv986025yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv986025 
.yiv986025green {color:#628c2a;}#yiv986025 .yiv986025MsoNormal 
{margin:0 0 0 0;}#yiv986025 o {font-size:0;}#yiv986025 
#yiv986025photos div {float:left;width:72px;}#yiv986025 
#yiv986025photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv986025 
#yiv986025photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv986025
 #yiv986025reco-category {font-size:77%;}#yiv986025 
#yiv986025reco-desc {font-size:77%;}#yiv986025 .yiv986025replbq 
{margin:4px;}#yiv986025 #yiv986025ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv986025 #yiv986025ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean,