Hi, LOL English aint my main language sorry. As for your question, may i know what's the advantage of Firebird over Interbase ?
For Question 1: I double click TIBDatabase component to open the Database Component Editor. Set everything correctly, then click at the test button. It shows "Connection successfully". Then i close the editor, and go back to my form and set the TIBTable Active property to true. But it dont allow me to do this and prompt out with this error message : "Dynamic SQL error SQL error code = -901 features is not supported" Any idea what's wrong with that?? For Question 2: I need to show all the records from a table to the users (that's part of the user requirement). Therefore i've to use both TIBTable and TDbgrid component. The problem is that there's only 3 records in that table, but i wonder why it tooks so long for the system to load it . Thanks. Jonas Raoni <[EMAIL PROTECTED]> wrote: On 5/19/05, soonhuat ong <[EMAIL PROTECTED]> wrote: Man, your English is worse than mine hehe... Just a question, why don't you use Firebird [http://www.firebirdsql.org] instead of Interbase? > Question 1: > I have develop the a stand-alone application using Interbase. Now i want to > convert it to > client-base application, how do i do that ?? Let's assume my IP address is > 192.182.3.207, and the server machine name is 'MyServer' ... So......... What's your main problem? Besides the instalation process (installing and starting the database on the server, and adding the comunication dll to your system folder on the clients), you just need to feed the correct ip address to your application and make sure that there's no firewall blocking the interbase port on the server... There's really nothing to do :) Here I use ZeosLib to connect with firebird, it's pretty nice... But if you want to have a very fast communication, take a look on IBObjects... Since it was made for interbase/firebird there must be few layers and work arounds to support other databases ;] > Question 2: > In my standalone application, i've found that my application is way too slow > to show a > form with data.. The following is basically what i do > Drop a TIBTable, TIBTransaction, TDatabase, TDatasource and DBGrid component > on a > frmMyForm1. Grids, tables, etc... All those sequential controls/commands aren't nice to be used with any SQL database, so, try to avoid using such things (specially in a client/server application), the problems and slowlyness will grow together with the users of your program =] Try to just ask something to the database when you really need to (I mean, dont open huge queries at initialization... like "select * from table"), try to page the results and filter everything... I mean, don't give to the user a list full of clients, but a search form =) You can see very nice patterns on the web development, take a look on how everything is done and just copy the behaviour on your program... Things will run very fast ;] -- "ME ALIMENTE [http://br-linux.org/noticias/002750.html] hehe" "Invente, Tente!!! Fa�a um c�digo eficiente" (Jonas Raoni haha) Jonas Raoni Soares Silva --------------------------- Desenvolvedor de aplica��es jonasraoni at gmail dot com http://www.joninhas.ath.cx:666 ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. [Non-text portions of this message have been removed] ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
