Re: [firebird-support] ISC ERROR CODE:335544721
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
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
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
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
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
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
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
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!
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
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
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