Re: [firebird-support] ISC ERROR CODE:335544721

2019-11-18 Thread Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support]
 Hello Dimitry,
I have all I use to find on other computer in C:\Program Files 
(x86)\Firebird\Firebird_2_5...
With best regards,Mike
Le lundi 18 novembre 2019 à 21:23:15 UTC+1, Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]  a 
écrit :  
 
 18.11.2019 20:38, Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] wrote:
> I havent' Interbase installed on this computer, only Firebird...

  Look better. Use Process Explorer to see versions and locations of DLLs 
loaded into 
your application.


-- 
  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



  

Re: [firebird-support] ISC ERROR CODE:335544721

2019-11-18 Thread Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support]
 Hello Dimitry,
I havent' Interbase installed on this computer, only Firebird...
I have desactivate the Frewall...
Still have the same message...
Strange, first time I've found this with win10 and Firebird…
The same application work fine other computer with Firebird.
With best regards,Mike

Le lundi 18 novembre 2019 à 20:23:39 UTC+1, Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]  a 
écrit :  
 
 18.11.2019 19:40, Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] wrote:
> Do you have an idea of what I have to do ?

  Remove Interbase client and use Firebird client to connect to Firebird.


-- 
  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



  

[firebird-support] ISC ERROR CODE:335544721

2019-11-18 Thread Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support]
Hello,
I have an ISC ERROR CODE:335544721
This is the message : 
ISC ERROR CODE:335544721ISC ERROR MESSAGE:
Unable to complete network request to host "MYCOMPUTER".Failed to locate host 
machineUndefined service gds_db/tcp
MYCOMPUTER : a Win 10 64bitsFirebird 2.58
Application written with Delphi +IBO
The database is a local database...on MYCOMPUTER
port 3050 tcp is open in enter and out…
Do you have an idea of what I have to do ?
With best regards,Mike









Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5

2019-06-12 Thread Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support]
 Hello,
May be you build an empty Fb2.5 database with the same structure (Tables, 
Generators…)Export the FB3 datas into SQL...Adapt the sql.. and execute them 
into FB2.5...
With best regards,Mikey
Le mercredi 12 juin 2019 à 12:57:08 UTC+2, 'Mr. John' mr_joh...@yahoo.com 
[firebird-support]  a écrit :  
 
     

 I've extracted db into a script,but when restoring got almost the same error: 
 Invalid token.Dynamic SQL Error.SQL error code = -104.Token unknown - line 1, 
column 36.START.
error is on every generator code:
 CREATE GENERATOR GEN_HT_MENT_ID START WITH 0 INCREMENT BY 1;
  SET GENERATOR GEN_HT_MENT_ID TO 1;
in my app I have no such code,for generators I used this:
CREATE GENERATOR GEN_HT_MENT_ID;SET GENERATOR GEN_HT_MENT_ID TO 1;

thanks




thanks
On Wednesday, June 12, 2019, 1:25:40 PM GMT+3, Dimitry Sibiryakov 
s...@ibphoenix.com [firebird-support]  wrote: 
 
 
 12.06.2019 12:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> what other way I could use?

  Create database from scratch, pump data.


-- 
  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



#yiv7025946912 #yiv7025946912 -- #yiv7025946912ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7025946912 
#yiv7025946912ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7025946912 
#yiv7025946912ygrp-mkp #yiv7025946912hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv7025946912 #yiv7025946912ygrp-mkp #yiv7025946912ads 
{margin-bottom:10px;}#yiv7025946912 #yiv7025946912ygrp-mkp .yiv7025946912ad 
{padding:0 0;}#yiv7025946912 #yiv7025946912ygrp-mkp .yiv7025946912ad p 
{margin:0;}#yiv7025946912 #yiv7025946912ygrp-mkp .yiv7025946912ad a 
{color:#ff;text-decoration:none;}#yiv7025946912 #yiv7025946912ygrp-sponsor 
#yiv7025946912ygrp-lc {font-family:Arial;}#yiv7025946912 
#yiv7025946912ygrp-sponsor #yiv7025946912ygrp-lc #yiv7025946912hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7025946912 
#yiv7025946912ygrp-sponsor #yiv7025946912ygrp-lc .yiv7025946912ad 
{margin-bottom:10px;padding:0 0;}#yiv7025946912 #yiv7025946912actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7025946912 
#yiv7025946912activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7025946912
 #yiv7025946912activity span {font-weight:700;}#yiv7025946912 
#yiv7025946912activity span:first-child 
{text-transform:uppercase;}#yiv7025946912 #yiv7025946912activity span a 
{color:#5085b6;text-decoration:none;}#yiv7025946912 #yiv7025946912activity span 
span {color:#ff7900;}#yiv7025946912 #yiv7025946912activity span 
.yiv7025946912underline {text-decoration:underline;}#yiv7025946912 
.yiv7025946912attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv7025946912 .yiv7025946912attach div a 
{text-decoration:none;}#yiv7025946912 .yiv7025946912attach img 
{border:none;padding-right:5px;}#yiv7025946912 .yiv7025946912attach label 
{display:block;margin-bottom:5px;}#yiv7025946912 .yiv7025946912attach label a 
{text-decoration:none;}#yiv7025946912 blockquote {margin:0 0 0 
4px;}#yiv7025946912 .yiv7025946912bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7025946912 
.yiv7025946912bold a {text-decoration:none;}#yiv7025946912 dd.yiv7025946912last 
p a {font-family:Verdana;font-weight:700;}#yiv7025946912 dd.yiv7025946912last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7025946912 
dd.yiv7025946912last p span.yiv7025946912yshortcuts 
{margin-right:0;}#yiv7025946912 div.yiv7025946912attach-table div div a 
{text-decoration:none;}#yiv7025946912 div.yiv7025946912attach-table 
{width:400px;}#yiv7025946912 div.yiv7025946912file-title a, #yiv7025946912 
div.yiv7025946912file-title a:active, #yiv7025946912 
div.yiv7025946912file-title a:hover, #yiv7025946912 div.yiv7025946912file-title 
a:visited {text-decoration:none;}#yiv7025946912 div.yiv7025946912photo-title a, 
#yiv7025946912 div.yiv7025946912photo-title a:active, #yiv7025946912 
div.yiv7025946912photo-title a:hover, #yiv7025946912 
div.yiv7025946912photo-title a:visited {text-decoration:none;}#yiv7025946912 
div#yiv7025946912ygrp-mlmsg #yiv7025946912ygrp-msg p a 
span.yiv7025946912yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7025946912 
.yiv7025946912green {color:#628c2a;}#yiv7025946912 .yiv7025946912MsoNormal 
{margin:0 0 0 0;}#yiv7025946912 o {font-size:0;}#yiv7025946912 
#yiv7025946912photos div 

Re: [firebird-support] invalid request BLR at offset 27, on restore FB 3 database to 2.5

2019-06-12 Thread Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support]
 Hello,
I know that FB2.5 to F3.0 is possible :First do backup under FB2.5 and after 
restore under FB3...
But I may not understand your problem : do you want to do an FB3 -> FB2.5 
restore ?IF yes I may presume this is impossible… I'm right ?
With best Regards,Mickey
Le mercredi 12 juin 2019 à 11:50:55 UTC+2, 'Mr. John' mr_joh...@yahoo.com 
[firebird-support]  a écrit :  
 
     

HiI'm trying to restore a FB 3 database to 2.5Before fb3 backup,I copy from 2.5 
gbak.exe to gbak2.exe into FB3 folderthen run 
gbak2.exe -v -b "d:\db3.fdb" "d:\dbbk.gbk"  -user SYSDBA -pass "mypass"

backup is done with no erorrs
I can restore it again to fb3 with no error but when I restore it to Fb2.5 I 
got this: 
 Starting restore. Current time: 12:25:06 PM Invalid token.     invalid request 
BLR at offset 27.     BLR syntax error: expected valid BLR code at offset 28, 
encountered 210.     Exiting before completion due to errors.   Restore 
completed. Current time: 12:25:08 PM. Elapsed time: 00:00:01



restore is done from IBExpert 
thanks  #yiv1968461019 #yiv1968461019 -- #yiv1968461019ygrp-mkp {border:1px 
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1968461019 
#yiv1968461019ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1968461019 
#yiv1968461019ygrp-mkp #yiv1968461019hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv1968461019 #yiv1968461019ygrp-mkp #yiv1968461019ads 
{margin-bottom:10px;}#yiv1968461019 #yiv1968461019ygrp-mkp .yiv1968461019ad 
{padding:0 0;}#yiv1968461019 #yiv1968461019ygrp-mkp .yiv1968461019ad p 
{margin:0;}#yiv1968461019 #yiv1968461019ygrp-mkp .yiv1968461019ad a 
{color:#ff;text-decoration:none;}#yiv1968461019 #yiv1968461019ygrp-sponsor 
#yiv1968461019ygrp-lc {font-family:Arial;}#yiv1968461019 
#yiv1968461019ygrp-sponsor #yiv1968461019ygrp-lc #yiv1968461019hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1968461019 
#yiv1968461019ygrp-sponsor #yiv1968461019ygrp-lc .yiv1968461019ad 
{margin-bottom:10px;padding:0 0;}#yiv1968461019 #yiv1968461019actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1968461019 
#yiv1968461019activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1968461019
 #yiv1968461019activity span {font-weight:700;}#yiv1968461019 
#yiv1968461019activity span:first-child 
{text-transform:uppercase;}#yiv1968461019 #yiv1968461019activity span a 
{color:#5085b6;text-decoration:none;}#yiv1968461019 #yiv1968461019activity span 
span {color:#ff7900;}#yiv1968461019 #yiv1968461019activity span 
.yiv1968461019underline {text-decoration:underline;}#yiv1968461019 
.yiv1968461019attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv1968461019 ..yiv1968461019attach div a 
{text-decoration:none;}#yiv1968461019 .yiv1968461019attach img 
{border:none;padding-right:5px;}#yiv1968461019 .yiv1968461019attach label 
{display:block;margin-bottom:5px;}#yiv1968461019 .yiv1968461019attach label a 
{text-decoration:none;}#yiv1968461019 blockquote {margin:0 0 0 
4px;}#yiv1968461019 .yiv1968461019bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1968461019 
.yiv1968461019bold a {text-decoration:none;}#yiv1968461019 dd.yiv1968461019last 
p a {font-family:Verdana;font-weight:700;}#yiv1968461019 dd.yiv1968461019last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1968461019 
dd.yiv1968461019last p span.yiv1968461019yshortcuts 
{margin-right:0;}#yiv1968461019 div.yiv1968461019attach-table div div a 
{text-decoration:none;}#yiv1968461019 div.yiv1968461019attach-table 
{width:400px;}#yiv1968461019 div.yiv1968461019file-title a, #yiv1968461019 
div.yiv1968461019file-title a:active, #yiv1968461019 
div.yiv1968461019file-title a:hover, #yiv1968461019 div.yiv1968461019file-title 
a:visited {text-decoration:none;}#yiv1968461019 div.yiv1968461019photo-title a, 
#yiv1968461019 div.yiv1968461019photo-title a:active, #yiv1968461019 
div.yiv1968461019photo-title a:hover, #yiv1968461019 
div.yiv1968461019photo-title a:visited {text-decoration:none;}#yiv1968461019 
div#yiv1968461019ygrp-mlmsg #yiv1968461019ygrp-msg p a 
span.yiv1968461019yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1968461019 
.yiv1968461019green {color:#628c2a;}#yiv1968461019 .yiv1968461019MsoNormal 
{margin:0 0 0 0;}#yiv1968461019 o {font-size:0;}#yiv1968461019 
#yiv1968461019photos div {float:left;width:72px;}#yiv1968461019 
#yiv1968461019photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv1968461019 
#yiv1968461019photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1968461019
 #yiv1968461019reco-category {font-size:77%;}#yiv1968461019 
#yiv1968461019reco-desc {font-size:77%;}#yiv1968461019 .yiv1968461019replbq 
{margin:4px;}#yiv1968461019 #yiv1968461019ygrp-actbar div a:first-child 

Re: [firebird-support] Cannot open database file in local hard disk

2018-02-20 Thread Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support]
 Hello,
Did you try some thing like this :
IBODatabase1.Path := your GDB or FDB filename with path...;
IF SERVER_<>'' then // NAME or IP of  the server
   IBODatabase1.Server:=SERVER_ else
            IBODatabase1.Server:=PC_NAME; //localhost  if not 
IBODatabase1.Connected then
   IBODatabase1.Connect;
(using SYSDBA and masterkey.. or user)
Best Regards,MLCVISTA

Le ‎mardi‎ ‎20‎ ‎février‎ ‎2018‎ ‎16‎:‎09‎:‎33‎ ‎CET, Eduardo 
guse...@gmail.com [firebird-support]  a écrit 
:  
 
     
 

Thanks for your suggestion.
 
 The user have total control of the file and the folder. I can modify it and 
even delete it. I tried moving the file to other folders and I tried with many 
FDB files. If I copy the FDB to another computer with Firebird, then I can open 
it without any problem. So the problem seems to be related to the computer.
 
 I use Firebird 2.1 since many years ago and it works well. That's why I didn´t 
change it already.
 
 
  Mensaje original 
 Asunto: [firebird-support] Cannot open database file in local hard disk
 De: Rustam rusta...@ukr.net [firebird-support] 

 A: firebird-support@yahoogroups.com
 Fecha: 20/02/2018 11:09
  
    
1) Check user access rights on DB folder/file and account, under which Firebird 
server is running
 2) Why you don't use latest 2.5.8 version of Firebird?
 
  
 
 
 
|  | Libre de virus. www.avast.com  |

   #yiv3964543233 #yiv3964543233 -- #yiv3964543233ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3964543233 
#yiv3964543233ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3964543233 
#yiv3964543233ygrp-mkp #yiv3964543233hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3964543233 #yiv3964543233ygrp-mkp #yiv3964543233ads 
{margin-bottom:10px;}#yiv3964543233 #yiv3964543233ygrp-mkp .yiv3964543233ad 
{padding:0 0;}#yiv3964543233 #yiv3964543233ygrp-mkp .yiv3964543233ad p 
{margin:0;}#yiv3964543233 #yiv3964543233ygrp-mkp .yiv3964543233ad a 
{color:#ff;text-decoration:none;}#yiv3964543233 #yiv3964543233ygrp-sponsor 
#yiv3964543233ygrp-lc {font-family:Arial;}#yiv3964543233 
#yiv3964543233ygrp-sponsor #yiv3964543233ygrp-lc #yiv3964543233hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3964543233 
#yiv3964543233ygrp-sponsor #yiv3964543233ygrp-lc .yiv3964543233ad 
{margin-bottom:10px;padding:0 0;}#yiv3964543233 #yiv3964543233actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3964543233 
#yiv3964543233activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3964543233
 #yiv3964543233activity span {font-weight:700;}#yiv3964543233 
#yiv3964543233activity span:first-child 
{text-transform:uppercase;}#yiv3964543233 #yiv3964543233activity span a 
{color:#5085b6;text-decoration:none;}#yiv3964543233 #yiv3964543233activity span 
span {color:#ff7900;}#yiv3964543233 #yiv3964543233activity span 
.yiv3964543233underline {text-decoration:underline;}#yiv3964543233 
.yiv3964543233attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3964543233 .yiv3964543233attach div a 
{text-decoration:none;}#yiv3964543233 .yiv3964543233attach img 
{border:none;padding-right:5px;}#yiv3964543233 .yiv3964543233attach label 
{display:block;margin-bottom:5px;}#yiv3964543233 .yiv3964543233attach label a 
{text-decoration:none;}#yiv3964543233 blockquote {margin:0 0 0 
4px;}#yiv3964543233 .yiv3964543233bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3964543233 
.yiv3964543233bold a {text-decoration:none;}#yiv3964543233 dd.yiv3964543233last 
p a {font-family:Verdana;font-weight:700;}#yiv3964543233 dd.yiv3964543233last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3964543233 
dd.yiv3964543233last p span.yiv3964543233yshortcuts 
{margin-right:0;}#yiv3964543233 div.yiv3964543233attach-table div div a 
{text-decoration:none;}#yiv3964543233 div.yiv3964543233attach-table 
{width:400px;}#yiv3964543233 div.yiv3964543233file-title a, #yiv3964543233 
div.yiv3964543233file-title a:active, #yiv3964543233 
div.yiv3964543233file-title a:hover, #yiv3964543233 div.yiv3964543233file-title 
a:visited {text-decoration:none;}#yiv3964543233 div.yiv3964543233photo-title a, 
#yiv3964543233 div.yiv3964543233photo-title a:active, #yiv3964543233 
div.yiv3964543233photo-title a:hover, #yiv3964543233 
div.yiv3964543233photo-title a:visited {text-decoration:none;}#yiv3964543233 
div#yiv3964543233ygrp-mlmsg #yiv3964543233ygrp-msg p a 
span.yiv3964543233yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3964543233 
.yiv3964543233green {color:#628c2a;}#yiv3964543233 .yiv3964543233MsoNormal 
{margin:0 0 0 0;}#yiv3964543233 o {font-size:0;}#yiv3964543233 
#yiv3964543233photos div {float:left;width:72px;}#yiv3964543233 
#yiv3964543233photos div div {border:1px solid 

Re: [firebird-support] Evaluate "empty" string

2017-08-16 Thread Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support]
May be this :
if (terminal<>'') and ( not  (terminal is null)) thendo something
With best regardsMichel 

Le Mercredi 16 août 2017 18h20, "Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support]"  a écrit :
 

     On 16-8-2017 17:53, Jorge Andres Brugger jorge.brug...@gmail.com 
[firebird-support] wrote:
> Hello all.
> I need to evaluate if one SP varchar parameter is "not empty". I´m using:
> if (((CHAR_LENGTH(trim(terminal))>0) or (terminal is not null)) then  something>.
> If I send '' (empty string) as parameter content, the expression 
> evaluates to true (I´m expecting to get a false).
> What am I doing wrong?

An empty string is not null, so even though 
(CHAR_LENGTH(trim(terminal))>0) might be false, (terminal is not null) 
is true, so the IF evaluates to true and is executed.

Maybe you meant AND instead of OR?
-- 
Mark Rotteveel
  #yiv9825789986 #yiv9825789986 -- #yiv9825789986ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9825789986 
#yiv9825789986ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9825789986 
#yiv9825789986ygrp-mkp #yiv9825789986hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv9825789986 #yiv9825789986ygrp-mkp #yiv9825789986ads 
{margin-bottom:10px;}#yiv9825789986 #yiv9825789986ygrp-mkp .yiv9825789986ad 
{padding:0 0;}#yiv9825789986 #yiv9825789986ygrp-mkp .yiv9825789986ad p 
{margin:0;}#yiv9825789986 #yiv9825789986ygrp-mkp .yiv9825789986ad a 
{color:#ff;text-decoration:none;}#yiv9825789986 #yiv9825789986ygrp-sponsor 
#yiv9825789986ygrp-lc {font-family:Arial;}#yiv9825789986 
#yiv9825789986ygrp-sponsor #yiv9825789986ygrp-lc #yiv9825789986hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9825789986 
#yiv9825789986ygrp-sponsor #yiv9825789986ygrp-lc .yiv9825789986ad 
{margin-bottom:10px;padding:0 0;}#yiv9825789986 #yiv9825789986actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9825789986 
#yiv9825789986activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9825789986
 #yiv9825789986activity span {font-weight:700;}#yiv9825789986 
#yiv9825789986activity span:first-child 
{text-transform:uppercase;}#yiv9825789986 #yiv9825789986activity span a 
{color:#5085b6;text-decoration:none;}#yiv9825789986 #yiv9825789986activity span 
span {color:#ff7900;}#yiv9825789986 #yiv9825789986activity span 
.yiv9825789986underline {text-decoration:underline;}#yiv9825789986 
.yiv9825789986attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv9825789986 .yiv9825789986attach div a 
{text-decoration:none;}#yiv9825789986 .yiv9825789986attach img 
{border:none;padding-right:5px;}#yiv9825789986 .yiv9825789986attach label 
{display:block;margin-bottom:5px;}#yiv9825789986 .yiv9825789986attach label a 
{text-decoration:none;}#yiv9825789986 blockquote {margin:0 0 0 
4px;}#yiv9825789986 .yiv9825789986bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9825789986 
.yiv9825789986bold a {text-decoration:none;}#yiv9825789986 dd.yiv9825789986last 
p a {font-family:Verdana;font-weight:700;}#yiv9825789986 dd.yiv9825789986last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9825789986 
dd.yiv9825789986last p span.yiv9825789986yshortcuts 
{margin-right:0;}#yiv9825789986 div.yiv9825789986attach-table div div a 
{text-decoration:none;}#yiv9825789986 div.yiv9825789986attach-table 
{width:400px;}#yiv9825789986 div.yiv9825789986file-title a, #yiv9825789986 
div.yiv9825789986file-title a:active, #yiv9825789986 
div.yiv9825789986file-title a:hover, #yiv9825789986 div.yiv9825789986file-title 
a:visited {text-decoration:none;}#yiv9825789986 div.yiv9825789986photo-title a, 
#yiv9825789986 div.yiv9825789986photo-title a:active, #yiv9825789986 
div.yiv9825789986photo-title a:hover, #yiv9825789986 
div.yiv9825789986photo-title a:visited {text-decoration:none;}#yiv9825789986 
div#yiv9825789986ygrp-mlmsg #yiv9825789986ygrp-msg p a 
span.yiv9825789986yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9825789986 
.yiv9825789986green {color:#628c2a;}#yiv9825789986 .yiv9825789986MsoNormal 
{margin:0 0 0 0;}#yiv9825789986 o {font-size:0;}#yiv9825789986 
#yiv9825789986photos div {float:left;width:72px;}#yiv9825789986 
#yiv9825789986photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv9825789986 
#yiv9825789986photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9825789986
 #yiv9825789986reco-category {font-size:77%;}#yiv9825789986 
#yiv9825789986reco-desc {font-size:77%;}#yiv9825789986 .yiv9825789986replbq 
{margin:4px;}#yiv9825789986 #yiv9825789986ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv9825789986 #yiv9825789986ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9825789986 
#yiv9825789986ygrp-mlmsg 

Re: [firebird-support] update all records

2016-05-05 Thread Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support]
Hello, 
I don't understand your SQL :"Where 1=1"   first "1" is a field name ?
if "Where actualizar=1" it may works ?The condition is on records, and must use 
fields values...no ?
If you don't use condition, all records should be updated to the same value 0...
"Update stock set actualizar=0"  should update all records with actualizar =0 
to whole stock table... 
With best regards,Mikey 

Le Jeudi 5 mai 2016 19h19, "kristinwens...@yahoo.com [firebird-support]" 
 a écrit :
 

     Thanks 

On Wednesday, May 4, 2016 6:45 PM, "shg_siste...@yahoo.com.ar 
[firebird-support]"  wrote:
 

     hello! I've been googling but found nothing about it.
Why this sentence does not update all the records in the table? (FB 2.5)
update stock set actualizar = 0 where 1=1

Thanks!!
Sergio  

 #yiv9733264172 #yiv9733264172 -- #yiv9733264172ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9733264172 
#yiv9733264172ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9733264172 
#yiv9733264172ygrp-mkp #yiv9733264172hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv9733264172 #yiv9733264172ygrp-mkp #yiv9733264172ads 
{margin-bottom:10px;}#yiv9733264172 #yiv9733264172ygrp-mkp .yiv9733264172ad 
{padding:0 0;}#yiv9733264172 #yiv9733264172ygrp-mkp .yiv9733264172ad p 
{margin:0;}#yiv9733264172 #yiv9733264172ygrp-mkp .yiv9733264172ad a 
{color:#ff;text-decoration:none;}#yiv9733264172 #yiv9733264172ygrp-sponsor 
#yiv9733264172ygrp-lc {font-family:Arial;}#yiv9733264172 
#yiv9733264172ygrp-sponsor #yiv9733264172ygrp-lc #yiv9733264172hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9733264172 
#yiv9733264172ygrp-sponsor #yiv9733264172ygrp-lc .yiv9733264172ad 
{margin-bottom:10px;padding:0 0;}#yiv9733264172 #yiv9733264172actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9733264172 
#yiv9733264172activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9733264172
 #yiv9733264172activity span {font-weight:700;}#yiv9733264172 
#yiv9733264172activity span:first-child 
{text-transform:uppercase;}#yiv9733264172 #yiv9733264172activity span a 
{color:#5085b6;text-decoration:none;}#yiv9733264172 #yiv9733264172activity span 
span {color:#ff7900;}#yiv9733264172 #yiv9733264172activity span 
.yiv9733264172underline {text-decoration:underline;}#yiv9733264172 
.yiv9733264172attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv9733264172 .yiv9733264172attach div a 
{text-decoration:none;}#yiv9733264172 .yiv9733264172attach img 
{border:none;padding-right:5px;}#yiv9733264172 .yiv9733264172attach label 
{display:block;margin-bottom:5px;}#yiv9733264172 .yiv9733264172attach label a 
{text-decoration:none;}#yiv9733264172 blockquote {margin:0 0 0 
4px;}#yiv9733264172 .yiv9733264172bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9733264172 
.yiv9733264172bold a {text-decoration:none;}#yiv9733264172 dd.yiv9733264172last 
p a {font-family:Verdana;font-weight:700;}#yiv9733264172 dd.yiv9733264172last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9733264172 
dd.yiv9733264172last p span.yiv9733264172yshortcuts 
{margin-right:0;}#yiv9733264172 div.yiv9733264172attach-table div div a 
{text-decoration:none;}#yiv9733264172 div.yiv9733264172attach-table 
{width:400px;}#yiv9733264172 div.yiv9733264172file-title a, #yiv9733264172 
div.yiv9733264172file-title a:active, #yiv9733264172 
div.yiv9733264172file-title a:hover, #yiv9733264172 div.yiv9733264172file-title 
a:visited {text-decoration:none;}#yiv9733264172 div.yiv9733264172photo-title a, 
#yiv9733264172 div.yiv9733264172photo-title a:active, #yiv9733264172 
div.yiv9733264172photo-title a:hover, #yiv9733264172 
div.yiv9733264172photo-title a:visited {text-decoration:none;}#yiv9733264172 
div#yiv9733264172ygrp-mlmsg #yiv9733264172ygrp-msg p a 
span.yiv9733264172yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9733264172 
.yiv9733264172green {color:#628c2a;}#yiv9733264172 .yiv9733264172MsoNormal 
{margin:0 0 0 0;}#yiv9733264172 o {font-size:0;}#yiv9733264172 
#yiv9733264172photos div {float:left;width:72px;}#yiv9733264172 
#yiv9733264172photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv9733264172 
#yiv9733264172photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9733264172
 #yiv9733264172reco-category {font-size:77%;}#yiv9733264172 
#yiv9733264172reco-desc {font-size:77%;}#yiv9733264172 .yiv9733264172replbq 
{margin:4px;}#yiv9733264172 #yiv9733264172ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv9733264172 #yiv9733264172ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9733264172 
#yiv9733264172ygrp-mlmsg table 

Re: [firebird-support] Firebird 3.0 Is Available Now!

2016-04-19 Thread Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support]
Great !Is it possible to buy it without using paypal ? and to get a price in 
Euro ?
Best Regards,MlcVista 

Le Mardi 19 avril 2016 14h57, "'Carlos H. Cantu' lis...@warmboot.com.br 
[firebird-support]"  a écrit :
 

     Awesome! Congratulations to all the people who made this possible!

Btw, I will take the opportunity to announce that my "Migration Guide
to Firebird 3" eBook is being sold at
http://www.firebirdnews.org/migration-guide-to-firebird-3/

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

AKaiacfs> Firebird 3.0 Is Available Now - with major improvements in 
AKaiacfs> performance, security and SQL features

  #yiv9024262230 #yiv9024262230 -- #yiv9024262230ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9024262230 
#yiv9024262230ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9024262230 
#yiv9024262230ygrp-mkp #yiv9024262230hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv9024262230 #yiv9024262230ygrp-mkp #yiv9024262230ads 
{margin-bottom:10px;}#yiv9024262230 #yiv9024262230ygrp-mkp .yiv9024262230ad 
{padding:0 0;}#yiv9024262230 #yiv9024262230ygrp-mkp .yiv9024262230ad p 
{margin:0;}#yiv9024262230 #yiv9024262230ygrp-mkp .yiv9024262230ad a 
{color:#ff;text-decoration:none;}#yiv9024262230 #yiv9024262230ygrp-sponsor 
#yiv9024262230ygrp-lc {font-family:Arial;}#yiv9024262230 
#yiv9024262230ygrp-sponsor #yiv9024262230ygrp-lc #yiv9024262230hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9024262230 
#yiv9024262230ygrp-sponsor #yiv9024262230ygrp-lc .yiv9024262230ad 
{margin-bottom:10px;padding:0 0;}#yiv9024262230 #yiv9024262230actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9024262230 
#yiv9024262230activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9024262230
 #yiv9024262230activity span {font-weight:700;}#yiv9024262230 
#yiv9024262230activity span:first-child 
{text-transform:uppercase;}#yiv9024262230 #yiv9024262230activity span a 
{color:#5085b6;text-decoration:none;}#yiv9024262230 #yiv9024262230activity span 
span {color:#ff7900;}#yiv9024262230 #yiv9024262230activity span 
.yiv9024262230underline {text-decoration:underline;}#yiv9024262230 
.yiv9024262230attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv9024262230 .yiv9024262230attach div a 
{text-decoration:none;}#yiv9024262230 .yiv9024262230attach img 
{border:none;padding-right:5px;}#yiv9024262230 .yiv9024262230attach label 
{display:block;margin-bottom:5px;}#yiv9024262230 .yiv9024262230attach label a 
{text-decoration:none;}#yiv9024262230 blockquote {margin:0 0 0 
4px;}#yiv9024262230 .yiv9024262230bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9024262230 
.yiv9024262230bold a {text-decoration:none;}#yiv9024262230 dd.yiv9024262230last 
p a {font-family:Verdana;font-weight:700;}#yiv9024262230 dd.yiv9024262230last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9024262230 
dd.yiv9024262230last p span.yiv9024262230yshortcuts 
{margin-right:0;}#yiv9024262230 div.yiv9024262230attach-table div div a 
{text-decoration:none;}#yiv9024262230 div.yiv9024262230attach-table 
{width:400px;}#yiv9024262230 div.yiv9024262230file-title a, #yiv9024262230 
div.yiv9024262230file-title a:active, #yiv9024262230 
div.yiv9024262230file-title a:hover, #yiv9024262230 div.yiv9024262230file-title 
a:visited {text-decoration:none;}#yiv9024262230 div.yiv9024262230photo-title a, 
#yiv9024262230 div.yiv9024262230photo-title a:active, #yiv9024262230 
div.yiv9024262230photo-title a:hover, #yiv9024262230 
div.yiv9024262230photo-title a:visited {text-decoration:none;}#yiv9024262230 
div#yiv9024262230ygrp-mlmsg #yiv9024262230ygrp-msg p a 
span.yiv9024262230yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9024262230 
.yiv9024262230green {color:#628c2a;}#yiv9024262230 .yiv9024262230MsoNormal 
{margin:0 0 0 0;}#yiv9024262230 o {font-size:0;}#yiv9024262230 
#yiv9024262230photos div {float:left;width:72px;}#yiv9024262230 
#yiv9024262230photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv9024262230 
#yiv9024262230photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9024262230
 #yiv9024262230reco-category {font-size:77%;}#yiv9024262230 
#yiv9024262230reco-desc {font-size:77%;}#yiv9024262230 .yiv9024262230replbq 
{margin:4px;}#yiv9024262230 #yiv9024262230ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv9024262230 #yiv9024262230ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9024262230 
#yiv9024262230ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9024262230 
#yiv9024262230ygrp-mlmsg select, #yiv9024262230 input, #yiv9024262230 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9024262230 

Réf.: FW: 126374Re: [firebird-support] Diagnose SQL error code -303

2015-03-17 Thread Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support]


try to place chars et to NONE... You must have a letter That is not supported 
by your charset in one records... 


--
Le lun. 16 mars 2015 22:08 HNEC, 'Chris LeFebvre' lefebv...@comcast.net 
[firebird-support] a écrit :


Thanks for the reply, I used a trial of Database Workbench 5 to create the
new database rather than the paid for version 3.4.4 I usually use (just
testing to see if I want to upgrade) and I checked all my existing databases
and this new database was created to use UTF8 (by default I guess and I
didn't change it) while all my other databases seem to use a characterset of
NONE. I'm still not entirely sure what exactly the problem was because I
tried deleting a few records and I still couldn't add a record or edit the
artist and title fields of any existing records. So I created a new database
with Database Workbench 3.4.4 and created the tables, generators and
procedures using the DDL statements from the old database (editing out
references to UTF8) and then used the datapump to copy data from the
existing database to the new one. After renaming both databases everything
appears to be working properly again.

I looked up UTF8 and the Wikipedia article says UTF8 is a character
encoding capable of encoding all possible characters (called code points) in
Unicode so if that's the case then I still don't understand exactly what
the problem was with the old database; why I was able to enter 104 records
and then suddenly start getting a -303 error when adding a record or editing
the Artist or Title fields of an existing record? Also what's the real
difference between having a database with a default character set of UTF8
and NONE? I'm asking for future reference and because I'm pretty sure that I
didn't fix the problem but instead just developed a workaround and I'd
really like to know?

Michel Le Clezio

Take a look to charset used in text and the Charset of database... May be
in one record you use is an unsupported char... by the Charset of
database... this can happen if you paste
 a value... ( a value not build by your keyboard) 


Le Dimanche 15 mars 2015 5h28, 'Chris LeFebvre' lefebvrec@...
[firebird-support] firebird-support@yahoogroups.com a écrit :




Re: [firebird-support] Diagnose SQL error code -303

2015-03-15 Thread Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support]
Take a look to charset used in text and the Charset of database... May be in 
one record you use is an unsupported char... by the Charset of database... this 
can happen if you paste a value... ( a value not build by your keyboard)  

 Le Dimanche 15 mars 2015 5h28, 'Chris LeFebvre' lefebv...@comcast.net 
[firebird-support] firebird-support@yahoogroups.com a écrit :
   

     I have at least a dozen different Firebird databases that I’ve created for 
my own personal use over the years and I develop the front end in Delphi. I 
recently created a new database for a project and I’d been adding new data into 
it successfully until today when I tried to insert what would have been the 
105th record and my program threw a SQL error -303. I tried a number of 
different things to try and figure out what is causing the problem but when I 
wasn’t making any headway I tried opening the database in Database Workbench 
3.4.4 and querying the table that is having the problem and then manually 
trying to add a new record and this is the error I’m getting:  ISC ERROR 
CODE:335544569  ISC ERROR MESSAGEDynamic SQL ErrorSQL error code = 
-303Arithmetic exception, numeric overflow, or string truncationUnexpected end 
of file on backup file  The layout of the table is fairly simple:  CREATE TABLE 
PLAYLISTS(ARTIST CHAR( 100) COLLATE UTF8,TITLE CHAR( 100) COLLATE UTF8,GENRE 
CHAR( 30) COLLATE UTF8,PORDER INTEGER,SONGNUM INTEGER,MAINKEY BIGINT,KEYFIELD 
BIGINT NOT NULL,CONSTRAINT PK_PLAYLISTS PRIMARY KEY (KEYFIELD))  A little trial 
and error turned up the fact that I can enter data in any column except the 
Artist and Title, when I enter data into those fields and try and move to 
another field I get the -303 error. This perplexes me since there are 104 other 
records in the database that have been added successfully without any problem 
and there is nothing strange or unusual about the text of the Artist and Title 
that I’m attempting to insert; I even tried just making either field a single 
character “a” and I get the same error. I’ve also discovered that I can’t edit 
any of the other 104 records; for example if I attempt to edit a record with an 
value of “Carlos Ortega” in the artist field and replace that with “a” and move 
to another field I get the same -303 error.  In case there was some damage to 
the database I’ve even tried a backup and restore and I still have the same 
problem on the restored database. I’ve tried using the Database Validation  
Repair wizard and it simply says “No errors”.  Does anyone have some insight 
into this problem?  Thanks,Chris LeFebvre  #yiv2640494804 #yiv2640494804 -- 
#yiv2640494804ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 
0;padding:0 10px;}#yiv2640494804 #yiv2640494804ygrp-mkp hr {border:1px solid 
#d8d8d8;}#yiv2640494804 #yiv2640494804ygrp-mkp #yiv2640494804hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv2640494804 #yiv2640494804ygrp-mkp #yiv2640494804ads 
{margin-bottom:10px;}#yiv2640494804 #yiv2640494804ygrp-mkp .yiv2640494804ad 
{padding:0 0;}#yiv2640494804 #yiv2640494804ygrp-mkp .yiv2640494804ad p 
{margin:0;}#yiv2640494804 #yiv2640494804ygrp-mkp .yiv2640494804ad a 
{color:#ff;text-decoration:none;}#yiv2640494804 #yiv2640494804ygrp-sponsor 
#yiv2640494804ygrp-lc {font-family:Arial;}#yiv2640494804 
#yiv2640494804ygrp-sponsor #yiv2640494804ygrp-lc #yiv2640494804hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2640494804 
#yiv2640494804ygrp-sponsor #yiv2640494804ygrp-lc .yiv2640494804ad 
{margin-bottom:10px;padding:0 0;}#yiv2640494804 #yiv2640494804actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2640494804 
#yiv2640494804activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2640494804
 #yiv2640494804activity span {font-weight:700;}#yiv2640494804 
#yiv2640494804activity span:first-child 
{text-transform:uppercase;}#yiv2640494804 #yiv2640494804activity span a 
{color:#5085b6;text-decoration:none;}#yiv2640494804 #yiv2640494804activity span 
span {color:#ff7900;}#yiv2640494804 #yiv2640494804activity span 
.yiv2640494804underline {text-decoration:underline;}#yiv2640494804 
.yiv2640494804attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv2640494804 .yiv2640494804attach div a 
{text-decoration:none;}#yiv2640494804 .yiv2640494804attach img 
{border:none;padding-right:5px;}#yiv2640494804 .yiv2640494804attach label 
{display:block;margin-bottom:5px;}#yiv2640494804 .yiv2640494804attach label a 
{text-decoration:none;}#yiv2640494804 blockquote {margin:0 0 0 
4px;}#yiv2640494804 .yiv2640494804bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2640494804 
.yiv2640494804bold a {text-decoration:none;}#yiv2640494804 dd.yiv2640494804last 
p a {font-family:Verdana;font-weight:700;}#yiv2640494804 dd.yiv2640494804last p 
span