🚀 go-pugleaf

Peter Nunn <pnunn@infoteq.com.au> wrote:
>Has anyone out there managed to get a linux program working in kylix
>connected to a prostgresql database?
>
>After much mucking around I managed to get the SQLConnection to open
>without error (after making a few symbolic links that were missing),
>but when I try and connect up to the db with any data aware
>components, the wrong data types are returned.
>
>For exampl, using the booktown database from Practical PostgreSQL the
>text types are seen as memo types (by DBText components), the int
>types as strings (and thats as far as I've got at the moment).
>
>Is there a better way??  Not real happy so far.
>
>This is Kylix 3 C++ on Mandrake 9.2.
>
>Peter Nunn.
>
>

My programs work just fine with PostgreSQL. I use Kylix 3 Delphi and Mandrake 9.0.

Hi Nikola,

glad to hear that someone else is trying this out...

Do you get the correct types returned in the data aware components?
Do you're varchar fields come back as memo's or text?

Mine seem to all be memo's for some reason, and there not blobs at all
as far as I can see.

Thanks.

Peter.

On 8 Nov 2003 15:51:44 -0700, "Nikola" <jolovic@drenik.net> wrote:

>
>Peter Nunn <pnunn@infoteq.com.au> wrote:
>>Has anyone out there managed to get a linux program working in kylix
>>connected to a prostgresql database?
>>
>>After much mucking around I managed to get the SQLConnection to open
>>without error (after making a few symbolic links that were missing),
>>but when I try and connect up to the db with any data aware
>>components, the wrong data types are returned.
>>
>>For exampl, using the booktown database from Practical PostgreSQL the
>>text types are seen as memo types (by DBText components), the int
>>types as strings (and thats as far as I've got at the moment).
>>
>>Is there a better way??  Not real happy so far.
>>
>>This is Kylix 3 C++ on Mandrake 9.2.
>>
>>Peter Nunn.
>>
>>
>
>My programs work just fine with PostgreSQL. I use Kylix 3 Delphi and Mandrake 9.0.

Peter Nunn <pnunn@infoteq.com.au> wrote:
>Hi Nikola,
>
>glad to hear that someone else is trying this out...
>
>Do you get the correct types returned in the data aware components?
>Do you're varchar fields come back as memo's or text?
>
>Mine seem to all be memo's for some reason, and there not blobs at all
>as far as I can see.
>
>Thanks.
>
>Peter.
>
>On 8 Nov 2003 15:51:44 -0700, "Nikola" <jolovic@drenik.net> wrote:
>
>>
>>Peter Nunn <pnunn@infoteq.com.au> wrote:
>>>Has anyone out there managed to get a linux program working in kylix
>>>connected to a prostgresql database?
>>>
>>>After much mucking around I managed to get the SQLConnection to open
>>>without error (after making a few symbolic links that were missing),
>>>but when I try and connect up to the db with any data aware
>>>components, the wrong data types are returned.
>>>
>>>For exampl, using the booktown database from Practical PostgreSQL the
>>>text types are seen as memo types (by DBText components), the int
>>>types as strings (and thats as far as I've got at the moment).
>>>
>>>Is there a better way??  Not real happy so far.
>>>
>>>This is Kylix 3 C++ on Mandrake 9.2.
>>>
>>>Peter Nunn.
>>>
>>>
>>
>>My programs work just fine with PostgreSQL. I use Kylix 3 Delphi and Mandrake 9.0.
>


  Yes, I get correct field types... Varchar come back as text...

        Regards,

                     Nikola

Hi Peter,

I have been using Kylix with Postgresql for about a year now. Yes, the
driver that comes with Kylix mistranslates many of the data types -
the boolean-as-string is a particular pain - but that's the least of
your worries! If you try to apply updates to a dataset it posts each
record as a separate transaction. If (say) the fourth record fails,
the first three will be posted. Not helpful!

After wrestling with this for a while, I bought vitavoom's driver
which handles transactions correctly AND renders the data types
correctly. It's not free, but will save a lot of angst if you're
planning to do anything involving transactions. You can get it at
www.vitavoom.com

I can thoroughly recommend Postgresql btw. It's fast and totally
reliable.

Hope this helps.

John Campbell
Glasgow 
Scotland

PS I notice you're using Mandrake 9.2 - I am currently stuck with 8.2
which is one of the "authorised" distros - what did you have to tweak
to get Kylix to work?


Peter Nunn <pnunn@infoteq.com.au> wrote in message news:<u3tmqvgnsk1hlou3ip64em18d48hk75nvn@4ax.com>...
> Has anyone out there managed to get a linux program working in kylix
> connected to a prostgresql database?
> 
> After much mucking around I managed to get the SQLConnection to open
> without error (after making a few symbolic links that were missing),
> but when I try and connect up to the db with any data aware
> components, the wrong data types are returned.
> 
> For exampl, using the booktown database from Practical PostgreSQL the
> text types are seen as memo types (by DBText components), the int
> types as strings (and thats as far as I've got at the moment).
> 
> Is there a better way??  Not real happy so far.
> 
> This is Kylix 3 C++ on Mandrake 9.2.
> 
> Peter Nunn.

Peter Nunn wrote:

> Has anyone out there managed to get a linux program working in kylix
> connected to a prostgresql database?
> 
> After much mucking around I managed to get the SQLConnection to open
> without error (after making a few symbolic links that were missing),
> but when I try and connect up to the db with any data aware
> components, the wrong data types are returned.
> 


> This is Kylix 3 C++ on Mandrake 9.2.

I use Kylix 3 Pro (Delphi) on Mandrake 9.1 and it works fine (after setting
the links). Postgresql version is 7.3.2. 

How did you set up the field components in the DataSets? Try double-clicking
on the DS icon, then right-click on the opened widow, then choose to get
all fields. Then point a DataSource to a DataSet; then point DataControls
to DataSource and specify a field (in a data control) from drop-down list.

Mikhail.

Thanks Mikhail,

that is basically what I did, but I'm still getting the varchar fields
mapping to memo rather than to text fields.

Very frustrating.

Thanks anyway.

Peter.


On Thu, 04 Dec 2003 13:46:43 -0600, mike <mikeumo@onebox.com> wrote:

>Peter Nunn wrote:
>
>> Has anyone out there managed to get a linux program working in kylix
>> connected to a prostgresql database?
>> 
>> After much mucking around I managed to get the SQLConnection to open
>> without error (after making a few symbolic links that were missing),
>> but when I try and connect up to the db with any data aware
>> components, the wrong data types are returned.
>> 
>
>
>> This is Kylix 3 C++ on Mandrake 9.2.
>
>I use Kylix 3 Pro (Delphi) on Mandrake 9.1 and it works fine (after setting
>the links). Postgresql version is 7.3.2. 
>
>How did you set up the field components in the DataSets? Try double-clicking
>on the DS icon, then right-click on the opened widow, then choose to get
>all fields. Then point a DataSource to a DataSet; then point DataControls
>to DataSource and specify a field (in a data control) from drop-down list.
>
>Mikhail.
>

Peter Nunn a �crit :
> Has anyone out there managed to get a linux program working in kylix
> connected to a prostgresql database?
> 
> After much mucking around I managed to get the SQLConnection to open
> without error (after making a few symbolic links that were missing),
> but when I try and connect up to the db with any data aware
> components, the wrong data types are returned.
> 
> For exampl, using the booktown database from Practical PostgreSQL the
> text types are seen as memo types (by DBText components), the int
> types as strings (and thats as far as I've got at the moment).
> 
> Is there a better way??  Not real happy so far.
> 
> This is Kylix 3 C++ on Mandrake 9.2.
> 
> Peter Nunn.
> 
> 

I could make a pg front end with kylix and the Zeos lib components. But 
the result is bullshit. It takes an hour to load and, because Zeos comps 
seem not to be available as dcu (design time comps), there is a need to 
compile this project with the runtime comps, so a 20 MB of libs to ship 
with the 150KB of exe file. Welcome back to Visual Basic!

I switched back to QT and straight C++ and now I can say I develop 
database stuff the right way.


Though I do like Delphi a lot under Windows, Kylix sucks a lot.

Regards,