Guest Posted January 18, 2011 Share Posted January 18, 2011 Message from: "Luis Diaz" What it's a better components to access to Firebird with unigui? . Quote Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2011 Author Share Posted January 18, 2011 Message from: "Luis Diaz" El 18/01/2011 18:10, Junior/RO escribió: > Luis Diaz escreveu: > >> What it's a better components to access to Firebird with unigui? > I am using Zeos, but only the trunk version of development of Zeos works well with Delphi 2010. I try Interbase components, but I get error when put a TIbSql+TIBtransaction in a form created in runtime. I do not understand how I should use the data access compenentes. My scenario is: In a MainModule put: Quote Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2011 Author Share Posted January 18, 2011 Message from: "Farshad Mohajeri" "Luis Diaz" wrote in message news:FtSrPS0tLHA.2164@anaxagvs227... > El 18/01/2011 18:10, Junior/RO escribió: >> Luis Diaz escreveu: >> >>> What it's a better components to access to Firebird with unigui? >> I am using Zeos, but only the trunk version of development of Zeos works >> well with Delphi 2010. > I try Interbase components, but I get error when put a > TIbSql+TIBtransaction in a form created in runtime. > I do not understand how I should use the data access compenentes. > My scenario is: > In a MainModule put: > -- One IBDatabase for use for all forms > -- One IbSql+IbTransaction for validate user and password in login form. > Login form is a panel in Main Form. > From Main form call to second form (created at runtime) with one > IBsql+Ibtransaction for search data form. > Login form works well, bat in the second form I get error "unprepared > statament" when execute the query. > And I can not find a solution to the problem... You scenario looks plausible. Have you tested your project in Desktop mode first? . Quote Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2011 Author Share Posted January 18, 2011 Message from: "Farshad Mohajeri" "Luis Diaz" wrote in message news:FtSrPS0tLHA.2164@anaxagvs227... > El 18/01/2011 18:10, Junior/RO escribió: >> Luis Diaz escreveu: >> >>> What it's a better components to access to Firebird with unigui? >> I am using Zeos, but only the trunk version of development of Zeos works >> well with Delphi 2010. > I try Interbase components, but I get error when put a > TIbSql+TIBtransaction in a form created in runtime. > I do not understand how I should use the data access compenentes. > My scenario is: > In a MainModule put: > -- One IBDatabase for use for all forms > -- One IbSql+IbTransaction for validate user and password in login form. > Login form is a panel in Main Form. > From Main form call to second form (created at runtime) with one How do you create your Form at runtime? Post a code snippet. . Quote Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2011 Author Share Posted January 18, 2011 Message from: "Luis Diaz" El 18/01/2011 20:37, Farshad Mohajeri escribió: > "Luis Diaz" wrote in message > news:FtSrPS0tLHA.2164@anaxagvs227... >> El 18/01/2011 18:10, Junior/RO escribió: >>> Luis Diaz escreveu: >>> >>>> What it's a better components to access to Firebird with unigui? >>> I am using Zeos, but only the trunk version of development of Zeos works >>> well with Delphi 2010. >> I try Interbase components, but I get error when put a >> TIbSql+TIBtransaction in a form created in runtime. >> I do not understand how I should use the data access compenentes. >> My scenario is: >> In a MainModule put: >> -- One IBDatabase for use for all forms >> -- One IbSql+IbTransaction for validate user and password in login form. >> Login form is a panel in Main Form. >> From Main form call to second form (created at runtime) with one > You scenario looks plausible. Have you tested your project in Desktop mode > first No I defined the project only as Isapi. > How do you create your Form at runtime? Post a code snippet. procedure TMainForm.UniButton6Click(Sender: TObject); var calendario : TExpPerCalendario; begin PMenu.Visible:=false; Calendario := TExpPerCalendario.Create(uniApplication); Calendario.CodTerceiro := MainModule.UniMainModule.QueryUsu.FieldByName('USU_TER').AsString; Calendario.Show; end; . Quote Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2011 Author Share Posted January 18, 2011 Message from: "Farshad Mohajeri" "Luis Diaz" wrote in message news:qcLvse0tLHA.2164@anaxagvs227... > El 18/01/2011 20:37, Farshad Mohajeri escribió: >> "Luis Diaz" wrote in message >> news:FtSrPS0tLHA.2164@anaxagvs227... >>> El 18/01/2011 18:10, Junior/RO escribió: >>>> Luis Diaz escreveu: >>>> >>>>> What it's a better components to access to Firebird with unigui? >>>> I am using Zeos, but only the trunk version of development of Zeos >>>> works >>>> well with Delphi 2010. >>> I try Interbase components, but I get error when put a >>> TIbSql+TIBtransaction in a form created in runtime. >>> I do not understand how I should use the data access compenentes. >>> My scenario is: >>> In a MainModule put: >>> -- One IBDatabase for use for all forms >>> -- One IbSql+IbTransaction for validate user and password in login form. >>> Login form is a panel in Main Form. >>> From Main form call to second form (created at runtime) with one >> You scenario looks plausible. Have you tested your project in Desktop >> mode >> first > No I defined the project only as Isapi. OK. Can you recompile it for Desktop mode and see if the problem persists? This problem looks irrelevant to uniGUI. >> How do you create your Form at runtime? Post a code snippet. > procedure TMainForm.UniButton6Click(Sender: TObject); > var calendario : TExpPerCalendario; > begin > PMenu.Visible:=false; > Calendario := TExpPerCalendario.Create(uniApplication); > Calendario.CodTerceiro := > MainModule.UniMainModule.QueryUsu.FieldByName('USU_TER').AsString; > Calendario.Show; > end; . Quote Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2011 Author Share Posted January 18, 2011 Message from: "Luis Diaz" El 18/01/2011 20:44, Farshad Mohajeri escribió: > "Luis Diaz" wrote in message > news:qcLvse0tLHA.2164@anaxagvs227... >> El 18/01/2011 20:37, Farshad Mohajeri escribió: >>> "Luis Diaz" wrote in message >>> news:FtSrPS0tLHA.2164@anaxagvs227... >>>> El 18/01/2011 18:10, Junior/RO escribió: >>>>> Luis Diaz escreveu: >>>>> >>>>>> What it's a better components to access to Firebird with unigui? >>>>> I am using Zeos, but only the trunk version of development of Zeos >>>>> works >>>>> well with Delphi 2010. >>>> I try Interbase components, but I get error when put a >>>> TIbSql+TIBtransaction in a form created in runtime. >>>> I do not understand how I should use the data access compenentes. >>>> My scenario is: >>>> In a MainModule put: >>>> -- One IBDatabase for use for all forms >>>> -- One IbSql+IbTransaction for validate user and password in login form. >>>> Login form is a panel in Main Form. >>>> From Main form call to second form (created at runtime) with one >>> You scenario looks plausible. Have you tested your project in Desktop >>> mode >>> first >> No I defined the project only as Isapi. > OK. Can you recompile it for Desktop mode and see if the problem persists? > This problem looks irrelevant to uniGUI. > how I do this? . Quote Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2011 Author Share Posted January 18, 2011 Message from: "Farshad Mohajeri" "Luis Diaz" wrote in message news:sCgR9i0tLHA.2164@anaxagvs227... > El 18/01/2011 20:44, Farshad Mohajeri escribió: >> "Luis Diaz" wrote in message >> news:qcLvse0tLHA.2164@anaxagvs227... >>> El 18/01/2011 20:37, Farshad Mohajeri escribió: >>>> "Luis Diaz" wrote in message >>>> news:FtSrPS0tLHA.2164@anaxagvs227... >>>>> El 18/01/2011 18:10, Junior/RO escribió: >>>>>> Luis Diaz escreveu: >>>>>> >>>>>>> What it's a better components to access to Firebird with unigui? >>>>>> I am using Zeos, but only the trunk version of development of Zeos >>>>>> works >>>>>> well with Delphi 2010. >>>>> I try Interbase components, but I get error when put a >>>>> TIbSql+TIBtransaction in a form created in runtime. >>>>> I do not understand how I should use the data access compenentes. >>>>> My scenario is: >>>>> In a MainModule put: >>>>> -- One IBDatabase for use for all forms >>>>> -- One IbSql+IbTransaction for validate user and password in login >>>>> form. >>>>> Login form is a panel in Main Form. >>>>> From Main form call to second form (created at runtime) with one >>>> You scenario looks plausible. Have you tested your project in Desktop >>>> mode >>>> first >>> No I defined the project only as Isapi. >> OK. Can you recompile it for Desktop mode and see if the problem >> persists? >> This problem looks irrelevant to uniGUI. >> > how I do this? > Create a new combo project VCL+ISAPI. Move your forms and modules from old project to new one. . Quote Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2011 Author Share Posted January 18, 2011 Message from: "Luis Diaz" This is a multi-part message in MIME format. Quote Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2011 Author Share Posted January 18, 2011 Message from: "Farshad Mohajeri" Hi, VCL mode is not much different than a regular delphi app, so it seems to = be related to database components and the way you use them.=20 In VCL mode get the same error: The query in login work fine. This second query break with this error. The difference between them is where they are placed. The first are in = MainModule with TDatabase, the second are into second form conected to = first TDatabase. Each query with your respective transaction. Only share = the Tdatabase. Quote Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2011 Author Share Posted January 18, 2011 Message from: "Luis Diaz" El 18/01/2011 21:32, Farshad Mohajeri escribió: > so it seems to be related to database components and the way you use > them. Well. My way to use unigui is corect? I study about use of Interbase components. Thk. . Quote Link to comment Share on other sites More sharing options...
Guest Posted January 18, 2011 Author Share Posted January 18, 2011 Message from: "Farshad Mohajeri" "Luis Diaz" wrote in message news:Q4z%23IA1tLHA.2164@anaxagvs227... > El 18/01/2011 21:32, Farshad Mohajeri escribió: >> so it seems to be related to database components and the way you use >> them. > Well. My way to use unigui is corect? > I study about use of Interbase components. > Thk. Yes, you can use MainModule and Forms for non-visual Data components. Good practice is to put non-visual data components in MainModule and other DataModules created from uniGUI wizard. . Quote Link to comment Share on other sites More sharing options...
Guest Posted February 11, 2011 Author Share Posted February 11, 2011 Message from: "Sergio" Hola Luis! your problem is not unigui related at all. I bet you have a second SQL that uses the user id as a parameter, something like: Select * from messages where userid=:ID OK, in this case, you need to do a TTable.prepare; just beffore you can assign a value to :ID and execute the query, for instance: MyTable.SelectSQL.Text:= 'select * from messages where userid=:ID'; MyTable.prepare; MyTable.Params[0].value:= 'Pepe'; //The user ID from 1st. query MyTable.Open; Hope it helps you. Sergio (Spain). Luis Diaz wrote: > El 18/01/2011 18:10, Junior/RO escribió: > > Luis Diaz escreveu: > > > > > What it's a better components to access to Firebird with unigui? > > I am using Zeos, but only the trunk version of development of Zeos > > works well with Delphi 2010. > I try Interbase components, but I get error when put a > TIbSql+TIBtransaction in a form created in runtime. I do not > understand how I should use the data access compenentes. My scenario > is: In a MainModule put: > -- One IBDatabase for use for all forms > -- One IbSql+IbTransaction for validate user and password in login > form. Login form is a panel in Main Form. From Main form call to > second form (created at runtime) with one IBsql+Ibtransaction for > search data form. Login form works well, bat in the second form I > get error "unprepared statament" when execute the query. And I can > not find a solution to the problem... . Quote Link to comment Share on other sites More sharing options...
Guest Posted February 11, 2011 Author Share Posted February 11, 2011 Message from: "Luis Diaz" El 11/02/2011 16:00, Sergio escribió: > Hola Luis! > > your problem is not unigui related at all. I bet you have a second SQL > that uses the user id as a parameter, something like: > > Select * from messages where userid=:ID > > OK, in this case, you need to do a TTable.prepare; just beffore you can > assign a value to :ID and execute the query, for instance: > > MyTable.SelectSQL.Text:= 'select * from messages where userid=:ID'; > MyTable.prepare; > MyTable.Params[0].value:= 'Pepe'; //The user ID from 1st. query > MyTable.Open; > > Hope it helps you. > Sergio (Spain). > > > Luis Diaz wrote: > >> El 18/01/2011 18:10, Junior/RO escribió: >>> Luis Diaz escreveu: >>> >>>> What it's a better components to access to Firebird with unigui? >>> I am using Zeos, but only the trunk version of development of Zeos >>> works well with Delphi 2010. >> I try Interbase components, but I get error when put a >> TIbSql+TIBtransaction in a form created in runtime. I do not >> understand how I should use the data access compenentes. My scenario >> is: In a MainModule put: >> -- One IBDatabase for use for all forms >> -- One IbSql+IbTransaction for validate user and password in login >> form. Login form is a panel in Main Form. From Main form call to >> second form (created at runtime) with one IBsql+Ibtransaction for >> search data form. Login form works well, bat in the second form I >> get error "unprepared statament" when execute the query. And I can >> not find a solution to the problem... Thanks for information. I now use ZeosLib and work fine. . Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.