Recent

Author Topic: problemas con Firebird y SQL...  (Read 8398 times)

Christian Ortiz

  • Guest
problemas con Firebird y SQL...
« on: January 02, 2006, 06:50:44 pm »
Hi, I am using Lazarus 0.9.10, firebird 1.5.1 on Linux suse10. When i use SQL
Components, it can't connect, the error: Can't find host "localhost".
(IBconnect, SQLtransaction, SQLQuery and DataSource).

After that i began using Interbase components (ibdatabase, ibtransaction, ibquery and datasource). It can connect, but when i insert data (with SQL statements : Insert ... Values ...) and make a ibquery.update* (i forget the complete :) ) in iSQL, i can see all data, but not when i do a query in Lazarus ¿?¿?¿??¿? why?????, nut if i do a query whit sum count, appers normal ??? im really confuse, i would like somebody help me.

PD: sorry for my ugly english

Anonymous

  • Guest
RE: problemas con Firebird y SQL...
« Reply #1 on: January 04, 2006, 12:54:32 pm »
I have the same problem.. (not the sane at all) I'm using Microsoft Windows and the last Lazarus version. I've using these Interbase components to connect to the Firebird but when I'll insert a record, I've got this Error: "DataSource is not in Write Mode" (something like this..)
I've checked all components : database, query, transaction and connection.. Everything is allright.. I've done this job sometimes with Delphi, but now I NEED to use Lazarus due to License values ($$$) of our Delphi..
So.. Can Anybody help me and Ortiz ?
Well see ya, thanks for the support and sorry for my bad english language..

Anonymous

  • Guest
RE: problemas con Firebird y SQL...
« Reply #2 on: January 04, 2006, 06:09:14 pm »
Try FIBL! (This is basically like Delphi's IBX)
http://sourceforge.net/projects/fibl

Good luck!

Edu

Anonymous

  • Guest
RE: problemas con Firebird y SQL...
« Reply #3 on: January 04, 2006, 06:15:05 pm »
Thanks EDU.. I'll Try FIBL soon as possible.. !! Like you can see, the components distributed in Lazarus package doesn't work with many programmers.. !!

See ya..

Christian Ortiz

  • Guest
Mmm
« Reply #4 on: January 04, 2006, 07:05:08 pm »
Interbase components, work fine for me, i think the problem is DBgrid component, it does not show all the data in a query, but i can write, i can read.
Th FIBL doesnt want to compile with lazarus 10.0, ask for a library doesnt exist :(

Anonymous

  • Guest
RE: Mmm
« Reply #5 on: January 07, 2006, 12:08:20 am »
try use UIB from http://www.progdigy.com

Anonymous

  • Guest
RE: Mmm
« Reply #6 on: January 13, 2006, 06:05:38 pm »
I've used UIB before, but I have the problem of read-only.. When I press insert button UIB return the error message (DataSource is not in Write Mode).. This thing is annoying..
Well.. thanks for the help.. I'll try the other solutions soon as possible.. !!

See ya.. ! (sorry for my bad english language..)

iws

  • Newbie
  • Posts: 1
    • http://fpc.by.ru/
RE: Mmm
« Reply #7 on: January 25, 2006, 02:53:19 pm »
Quote from: "Christian Ortiz"
Th FIBL doesnt want to compile with lazarus 10.0, ask for a library doesnt exist :(


What is "Lazarus 10.0"
--------
     Ivan Shikhalev
     http://freepascal.ru/

Christian Oirtiz

  • Guest
jeje
« Reply #8 on: January 25, 2006, 07:57:31 pm »
sorry, was lazarus 0.9.10

 

TinyPortal © 2005-2018