Re: Re[2]: [firebird-support] firebird multiple user on delphi 7

2013-03-24 Thread cedriz monteagudo
im sorry for not elaborating my question and stating it clearly. restrictions means restrictions on accessing files, e.g. on my database i have 5 tables in which only 2 tables will be allowed on a account or 3 tables. i would like to know if it will be on delphi 7 that i put the restriction or w

Re[2]: [firebird-support] firebird multiple user on delphi 7

2013-03-24 Thread Dmitry Kuzmenko
Hello, cedriz! Monday, March 25, 2013, 5:18:52 AM, you wrote: cm> thanks for the answers i will look upon them. cm> but is it possible to connect to a firebird server via lan and cm> internet simultaneously? what is internet and what is lan? And how it differ? No difference. At least for Firebi

Re: [firebird-support] firebird multiple user on delphi 7

2013-03-24 Thread cedriz monteagudo
thanks for the answers i will look upon them. but is it possible to connect to a firebird server via lan and internet simultaneously? also can i put restrictions on users via firebird or i just need to do it on my delphi app? From: Dmitry Kuzmenko To: firebir

[firebird-support] Charset DOS850 not installed - FB2.5 Embedded

2013-03-24 Thread Sávio
Hi, I did an application with Firebird 2.5 Embedded + xHarbour (BCC582 – 32 bits). I developed it with ADO + OLE DB (IB OLEDB - v2.0.0207 provider). All works fine until to execute a INSERT instruction. The error is "CHARACTER SET DOS850 is not installed". The folder INTL exis

[firebird-support] I want to see data in the database by combining the two?

2013-03-24 Thread Vedat Pala
I want to see data in the database by combining the two? But somehow I could not. How can I do this with the following command. Here is the command does not work.(ON EXTERNAL DATA SOURCE) Can you help me please? http://www.firebirdfaq.org/faq16 FOR EXECUTE STATEMENT 'select DATA,CODE,PRICES f

Re: [firebird-support] firebird multiple user on delphi 7

2013-03-24 Thread Dmitry Kuzmenko
Hello, dice_in_trouble! Sunday, March 24, 2013, 9:37:52 AM, you wrote: d> hello can somebody help me im just new to using firebird, and got some questions: d> first is that how to connect my firebird database to my delphi 7 app you have IBX components in Delphi 7, 2 component pages. Read about

Re: [firebird-support] Re: Firebird 2.5, FibPlus, Delphi 2010, DateTime field set to Null

2013-03-24 Thread Doug Chamberlin
Wolfgang- The same idea should work with FIBPlus components. The class that represents a field in a table or query should have a Clear method you can call to set the field to NULL. Every DB component set I have seen has this. [Non-text portions of this message have been removed]

Re: [firebird-support] Re: Firebird 2.5, FibPlus, Delphi 2010, DateTime field set to Null

2013-03-24 Thread Wolfgang Kluge
Thanks for your reply Christian, However, I am afraid this would introduce a big problem since the whole application programme is based FibPlus componts for SQL. Regards Wolfgang On 03/24/2013 09:24 AM, Christian Mereles wrote: > > Hi, > > TTable.Edit; > TTable.FieldByName('Date_Paid').Clear >

[firebird-support] New to store procedure and trigger

2013-03-24 Thread Precious So
Hello, Please help me. How can i use store procedure and trigger in real world application. Where can i get a tutorial.for this topic? Thank.you in advance [Non-text portions of this message have been removed]

Re: [firebird-support] Firebird 2.5, FibPlus, Delphi 2010, DateTime field set to Null

2013-03-24 Thread Precious So
Wolfgang, Check your field if you configure it if you allow null value. Try this query if will work. Upate vi_master set date_paid ='' where record no=12 Let me know if its working. Precious On Mar 24, 2013 8:58 AM, "Wolfgang Kluge" wrote: > ** > > > Good morning. > > I need to set a DateTim

Re: [firebird-support] Firebird 2.5, FibPlus, Delphi 2010, DateTime field set to Null

2013-03-24 Thread Jesús García
El 24/03/2013, a las 01:58, Wolfgang Kluge escribió: > Query.Params[10]. Try Query.Params[10].Clear Jesús García

[firebird-support] firebird multiple user on delphi 7

2013-03-24 Thread dice_in_trouble
hello can somebody help me im just new to using firebird, and got some questions: first is that how to connect my firebird database to my delphi 7 app second is that how can i make a multiple user login with different restrictions on the data that will be displayed. and lastly is it possible t

Odp: [firebird-support] Can one (repeatedly) restructure a Firebird table in a single transaction?

2013-03-24 Thread liviusliv...@poczta.onet.pl
Hi, You can not do this in one transaction. Especially created field must be commited before fill with data. But what problem with many transaction? Simple solution is to have table with db version and check it in application if it can work with or db is not upgraded. E.g. after creating field