Subject ibo - planit
Author Adrián Deccico
Hi,

I am trying to connect IBO with the planit components of turbopower.
Does anyone know a solution?

regards

Adrián Deccico
Software Developer

http://adrian.org,ar
deccico@...


-----Mensaje original-----
De: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Enviado el: Tuesday, January 27, 2004 6:12 PM
Para: IBObjects@yahoogroups.com
Asunto: [IBO] Digest Number 1773


There are 11 messages in this issue.

Topics in this digest:

1. Re: User queries
From: Daniel Rail <daniel@...>
2. displayformat
From: "L.M. Bemmelmans" <info@...>
3. Change the world : a worldwide referendum !
From: Durand Georges <georgesdurand61@...>
4. How to solve Updaterecordtypes
From: "Delmar" <delmar@...>
5. Re: Size mismatch for field...
From: "fabiano_bonin" <fabiano@...>
6. Using TIB_Script for creating procs/triggers
From: "rlssv" <rene@...>
7. Re: Using TIB_Script for creating procs/triggers
From: Lucas Franzen <luc@...>
8. Re: Using TIB_Script for creating procs/triggers
From: "rlssv" <rene@...>
9. QUERY-BY-EXAMPLE
From: "skander_sp" <skander@...>
10. Re: User queries
From: Lee Jenkins <lee@...>
11. Help installing
From: "Diego - DM2" <diego@...>


________________________________________________________________________
________________________________________________________________________

Message: 1
Date: Tue, 27 Jan 2004 05:53:11 -0400
From: Daniel Rail <daniel@...>
Subject: Re: User queries

Hi,

At January 27, 2004, 05:43, Beyers Cronje wrote:

> Daniel,

> It seems Simple Query is only supported on Delphi. Do you know of a
similar
> tool for C++ Builder ?

Apparently, it also supports C++Builder 4-6, this is part of the
description of the trial version. I would suggest that you contact
Korzh sales ( sales@... ) for further information.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)



________________________________________________________________________
________________________________________________________________________

Message: 2
Date: Tue, 27 Jan 2004 12:58:06 +0100
From: "L.M. Bemmelmans" <info@...>
Subject: displayformat

Jason,

Did you look into the displayformat problem some users pointed out a
month
or so ago ?
I want to install 4.3Aa, but I'll prefer to wait if you are planning for
a
new update within 2 weeks .

Leon





________________________________________________________________________
________________________________________________________________________

Message: 3
Date: Tue, 27 Jan 2004 13:51:44 +0100 (CET)
From: Durand Georges <georgesdurand61@...>
Subject: Change the world : a worldwide referendum !

Hello,

Let me present you something that you don't use to
talk about :
the ET presence.

It is so important for yourselves and the people
around you that I
dare today to introduce a WORLDWIDE REFERENDUM. It is
not my nature
to bore someone else, and I hope I don't, but after
the reading of
the message below (short version) you will understand
what can occur
in our near future.

Whatever your interests are, don't underestimate the
consequences of
your own choice for your own life. Everyone is
directly concerned.
It is not a simple message, not only an other one
among thousands
you have already received. This is a worldwide
phenomenon ! The ET's question is very simple :
DO YOU WISH THAT WE SHOW UP ?

A message has been telepathically received from ETs by
a French jet
pilot, air traffic controller and airport manager,
master in
economic sciences in new technologies. He actually
works with
scientists (physicists) on the 3D time theory he has
also
telepathically received from ETs. This theory is going
to be a
scientific revolution. He uses a pseudonymous not to
get publicity.
Hundreds of thousands people have reacted. Just see
all the
available message translations (original long version)
here :

http://www.geocities.com/changetheworld_now/

The ET's deal is simple : "you don't have enough ET
evidences, ask
us to give them to you, but be ready to change or
abandon radically
your beliefs and points of view in order to become a
real self-
empowered human fraternity able to get dangers far
away".

Please, give you the time to read and read again this
message.

Writers, analysts and reporters have already seriously
considered
this ET message as a new turn for Humanity.
If you desire to discover dozens of links (websites,
forums and
initiatives in more than twelve languages) speaking
about the
message go to the above url second page :

http://www.geocities.com/changetheworld_now/links.html

In addition, a discussion group has been created for
those who have requested to participate actively to
the spreading of this historical extraterrestrial
communication :
http://groups.yahoo.com/group/meetetnow01/?yguid=171003091


Please, circulate this extraordinary message.

Sincerely,

A reader among others.

PS1 : Here is the list of the 57 countries where the
message has
already been read for the moment :
France , Denmark , Brazil , Canada , Italy , Australia
, United
States , Austria , Mexico , United Kingdom ,
Netherlands , Belgium ,
Germany , Argentina , Switzerland , New Zealand ,
Japan , Spain,
Sweden, Finland, Israel , Norway , Turkey , Estonia ,
Czech
Republic, Greece , Malta , Peru , Croatia , Uruguay ,
Poland ,
Chile , Romania , South Africa , Indonesia , Hong Kong
, Hungary ,
Venezuela, Colombia , Bulgaria , Luxembourg , Saudi
Arabia ,
Lithuania , Portugal , Singapore , Paraguay ,
Guatemala,
Philippines , Thailand , Malaysia , Costa Rica ,
SIovenia ,
Dominica , Lebanon , Dominican Republic , United Arab
Emirates,
Russia.
PS2 : The ET's message (short version = selection of
sentences from
the original version) :

"DO YOU WISH THAT WE SHOW UP ?" (short version)

Consider this message as a worldwide referendum! And
your answer as
a ballot!

Who are we ?

What in your history seemed ridiculous or improbable
has often
become possible, then realised, in particular in the
last fifty
years. We are conscious creatures that some name
"extra-
terrestrials", even though reality is subtler.
There is no fundamental difference between you and us,
save for the
experience of certain stages of evolution. Like most
of you, we are
in the quest of the Supreme Being. We have no human
representative
on Earth who could guide your decision.

Why aren't we visible ?

Structured DEMATERIALISATION and materialisation are
part of new
forms of science beyond the apparent control of
matter. That you
call `UFOs, there are essentially multidimensional
manufactured
spaceships that apply these capacities.
For negative multidimensional beings that play a part
in the
exercise of power in the shadow of human oligarchy,
discretion is
motivated by their will to keep their existence and
seizure unknown.
For us, discretion is motivated by the respect of the
human free
will that people can exercise to manage their own
affairs so that
they can reach technical and spiritual maturity on
their own.
Humankind's entrance into the family of galactic
civilisations is
greatly expected.
We can appear in broad daylight and help you attain
this union. We
haven't done it so far, as too few of you have
genuinely desired it,
because of ignorance, indifference or fear, and
because the
emergency of the situation did not justify it.
Who are you ?
You are the offspring of many traditions that
throughout time have
been mutually enriched by each others' contributions.
The appearance
of your cultures seems to keep you separated because
you substitute
it to your deeper being. Shape is now more important
than the
essence of your subtle nature.
For the powers in place, this prevalence of the shape
constitutes
the ramparts against any form of jeopardy.
You are being called on to overcome shape while still
respecting it
for its richness and beauty. Peace does not mean not
making war, it
consists in becoming what you are in reality: a same
Fraternity.

What is your situation ?

Your history has never ceased to be marked by
encounters between
peoples who had to discover one another in conditions
that were
often conflictual. Earth has now become a village
where everyone
knows everyone else but still conflicts persist and
threats of all
kinds get worse in duration and intensity.
Your thoughts and beliefs are modelled after partisan
interests to
turn you into slaves while at the same time giving you
the feeling
that you are in total control of your destiny, which
in essence is
the reality.
Ecosystem exhaustion mechanisms have exceeded
irreversible limits.
The scarcity of resources and their unfair
distribution - resources
which entry price will rise day after day - will bring
about
fratricide fights at a large scale, but also at the
very heart of
your cities and countrysides.
Hatred grows bigger but so does love. That is what
keeps you
confident in your ability to find solutions. But the
critical mass
is insufficient and a sabotage work is cleverly being
carried out.
Tribes, populations and human nations have always
encountered and
interacted with one another. Faced with the threats
weighing upon
the human family, it is perhaps time that a greater
interaction
occurred.

Who are the "third party" ?

There are two ways to establish a cosmic contact with
another
civilisation: via its standing representatives or
directly with
individuals without distinction. The first way entails
fights of
interests, the second way brings awareness.
The first way was chosen by a group of races motivated
by keeping
mankind in slavery, thereby controlling Earth
resources, the gene
pool and human emotional energy.
The second way was chosen by a group of races allied
with the cause
of the Spirit of service.
That is why today individuals are to make this choice
by themselves
without any representative interfering. Peace and
reunification of
your peoples would be a first step toward the harmony
with
civilisations other than yours.
That is precisely what those who manipulate you behind
the scenes
want to avoid at all cost because, by dividing, they
reign! They
also reign over those who govern you. Their strength
comes from
their capacity to distillate mistrust and fear into
you. This
considerably harms your very cosmic nature.
Being aware of the priceless value of free will, we
are inviting you
to an alternative.

What can we offer ?

WE CAN offer you a more holistic vision of the
universe and of life,
constructive interactions, the experience of fair and
fraternal
relationships, liberating technical knowledge,
eradiction of
suffering, controlled exercise of individual powers,
the access to
new forms of energy and, finally, a better
comprehension of
CONSCIOUSNESS.

WE CANNOT help you overcome your individual and
collective fears, or
bring you laws that you would not have chosen, work on
your own
selves, individual and collective effort to build the
world you
desire, the spirit of quest to new skies.

What would we receive ?

Should you decide that such a contact takes place, we
would rejoice
over the safeguarding of fraternal equilibrium in this
region of the
universe, fruitful diplomatic exchanges, and the
intense Joy of
knowing that you are united to accomplish what you are
capable of.
The feeling of JOY is strongly sought in the universe
for its energy
is divine.

What is the question we ask you ?

"DO YOU WISH THAT WE SHOW UP ?"

How to can you answer this question ?
The truth of soul can be read by telepathy. This is
why you should
calmly think about it, in all conscience. Do not rush
to answer.
Breathe and let all the power of your own free will
penetrate you.
You only need to give your answer, YES or NO,
IMMEDIATELY AFTER
ASKING THE QUESTION !
In your own private polling booth of your secret will,
you will
determine the future.

What is the lever effect ?

This decision should be made by the greatest number
among you, even
though it might seem like a minority. This request is
one of the
most intimate that can be asked to you.
If you really want to cling to your beliefs, which is
something that
we understand, then say NO. If you do not know what to
choose, do
not say YES because of mere curiosity.
Your history has plenty of episodes when determined
men and women
were able to influence the thread of events in spite
of their small
number. Just like a small number is enough to take
temporal power on
Earth and influence the future of the majority, a
small number of
you can radically change your fate as an answer to the
impotence in
face of so much inertia and hurdles ! You can ease the
mankind's
birth to Brotherhood.

What would be the consequences of a positive decision
?

For us, the immediate consequence of a collective
favourable
decision would be the materialisation of many ships,
in your sky and
on Earth.
For you, the direct effect would be the rapid
abandoning of many
certitudes and beliefs. Concretely, you would change
the scale of
your values !
Later on, peaceful and respectful exchanges would be
thus possible
if such is your wish. For now, he who is hungry cannot
smile, he who
is fearful cannot welcome us. We are sad to see men,
women and
children suffering to such a degree in their flesh and
in their
hearts when they bear such an inner light.
The main difference between your daily prayers to
entities of a
strictly spiritual nature and your current decision is
extremely
simple :
we are technically equipped to materialise!

Why such a historical dilemma ?

We know that "foreigners" are considered as enemies as
long as they
embody the "unknown". In a first stage, the emotion
that our
appearance will generate will strengthen your
relationships on a
worldwide scale.

How could you know whether our arrival is the
consequence of your
collective choice ? For the simple reason that we
would have
otherwise been already there for a long time at your
level of
existence ! If we are not there yet, it is because you
have not made
such a decision explicitely.
How could you be certain that this is not yet another
subtle
manoeuvre of the "third party" to better enslave you ?
Because one
always more efficiently fights something that is
identified than the
contrary.
Whatever, you are the sole judge in your own heart and
soul ! Do you
want to see us with your own eyes, or simply believe
what your
thinkers say ? That is the real question!

You are still the architects of your own fate...

"DO YOU WISH THAT WE SHOW UP ?"

Complete original message on
www.geocities.com/meetetnow/

IF YOU WISH THEM TO SHOW UP :

You have to know that an increasing number of persons
from
everywhere, from all religions, workers and doctors,
poors and
richs, every one agreeing the ET proposal, participate
to a
worldwide Global First Contact Experiment which will
involve a
series of weekly visualizations details of the first
of which are as
follows:
(Go to : http://www.exopolitics.org/First-Contact.htm
)

Visualization:

Imagine yourself being asked by benevolent
extraterrestrials the
question: "Do You Wish That We Show Up?" Say 'yes'!
Then instantly
imagine luminous extraterrestrial ships appearing high
over every
city of the planet for a period lasting seven days and
nights. The
ships perform light displays that indicate universal
greetings of
peace, joy and fraternity…







_________________________________________________________________
Do You Yahoo!? -- Une adresse @... gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com


________________________________________________________________________
________________________________________________________________________

Message: 4
Date: Tue, 27 Jan 2004 04:59:44 -0800
From: "Delmar" <delmar@...>
Subject: How to solve Updaterecordtypes

I´m migrating from BDE to IBO and I get some problem:

I don´t have found the command updaterecordtypes in IBO 4.2.Ie. I like
one suggestion to substitute this command

This is the example code:

if (state=dsdragenter) and (source=ListBox1) then
begin
dmq.QcomporTurma.UpdateRecordTypes:= [rtDeleted]; {torna somente
os deletados visiveis}
dmq.QcomporTurma.DisableControls;
dmq.QcomporTurma.First; {move to beginning of dataset}
if
dmq.QcomporTurma.locate('codigo',strtoint(listaAluno.strings[listbox1.it
emindex]),[]) then
dmq.QcomporTurma.RevertRecord; {undelete the current record}
dmq.QcomporTurma.UpdateRecordTypes := [rtModified, rtInserted,
rtUnmodified];
dmq.QcomporTurma.EnableControls;
listaAluno.Delete(listBox1.itemIndex);
listbox1.Items.Delete(listbox1.ItemIndex);
edit2.Text:=inttostr(listbox1.Items.Count);
end;

[Non-text portions of this message have been removed]



________________________________________________________________________
________________________________________________________________________

Message: 5
Date: Tue, 27 Jan 2004 14:25:38 -0000
From: "fabiano_bonin" <fabiano@...>
Subject: Re: Size mismatch for field...

> I don't know what your story is. It's a long time since I used
BCD fields
> but, AFAIR, you always had this error if the scale of the stored
numeric or
> decimal was smaller than the BCD precision setting.

I think my story isn't different from others. I just use 'add all
fields' within TIBOQuery and it adds the BCD fields. I don't know a
way (or why) of don't use BCD fields.

Ok, i did a simple test case that maybe help somebody to identify
what is causing the problem.

First of all, i created this table:

create table bcd_test (
field1 numeric(5,2) );

Then, i created a new project in Delphi, added a TIBODatabase and a
TIBOQuery in the form.
After setup the TIBODatabase, i changed the SQL property of the
TIBOQuery to 'select * from bcd_test'.
So i double-clicked the TIBOQuery, right-clicked the fields editor
and selected 'Add all fields'.

I did the same step above with both 4.2Gc and 4.3Aa.

Below are 3 DFM's:
A) generated with IBO 4.2Gc
B) generated with IBO 4.3Ga
C) same as A), but after the project was opened with IBO 4.3Ga
(nothing changed)

As you can note, the field generated with IBO 4.2Gc is a
TIBOBCDField, while the field generated with IBO 4.3Ga is a
TBCDField. Is it a known behavior change?

A) generated with IBO 4.2Gc

object Form1: TForm1
Left = 192
Top = 114
Width = 696
Height = 480
Caption = 'Form1'
Color = clBtnFace
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -11
Font.Name = 'MS Sans Serif'
Font.Style = []
OldCreateOrder = False
PixelsPerInch = 96
TextHeight = 13
object IBODatabase1: TIBODatabase
SQLDialect = 3
Params.Strings = (
'PATH=teste'
'USER NAME=SYSDBA'
'SQL DIALECT=3'
'SERVER=interbase.leonilda.com.br'
'PROTOCOL=TCP/IP')
Left = 8
Top = 8
end
object IBOQuery1: TIBOQuery
Params = <>
DatabaseName = 'interbase.leonilda.com.br:teste'
IB_Connection = IBODatabase1
RecordCountAccurate = True
SQL.Strings = (
'select * from bcd_test')
FieldOptions = []
Left = 40
Top = 8
object IBOQuery1FIELD1: TIBOBCDField
FieldName = 'FIELD1'
end
end
end


B) generated with IBO 4.3Ga

object Form1: TForm1
Left = 192
Top = 114
Width = 696
Height = 480
Caption = 'Form1'
Color = clBtnFace
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -11
Font.Name = 'MS Sans Serif'
Font.Style = []
OldCreateOrder = False
PixelsPerInch = 96
TextHeight = 13
object IBODatabase1: TIBODatabase
SQLDialect = 3
Params.Strings = (
'SERVER=interbase.leonilda.com.br'
'PATH=teste'
'PROTOCOL=TCP/IP'
'USER NAME=SYSDBA'
'SQL DIALECT=3')
Left = 8
Top = 8
end
object IBOQuery1: TIBOQuery
Params = <>
DatabaseName = 'interbase.leonilda.com.br:teste'
IB_Connection = IBODatabase1
RecordCountAccurate = True
SQL.Strings = (
'select * from bcd_test')
FieldOptions = []
Left = 40
Top = 8
object IBOQuery1FIELD1: TBCDField
FieldName = 'FIELD1'
Precision = 9
Size = 2
end
end
end


C) same as A), but after the project was opened with IBO 4.3Ga
(nothing changed)

object Form1: TForm1
Left = 192
Top = 114
Width = 696
Height = 480
Caption = 'Form1'
Color = clBtnFace
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -11
Font.Name = 'MS Sans Serif'
Font.Style = []
OldCreateOrder = False
PixelsPerInch = 96
TextHeight = 13
object IBODatabase1: TIBODatabase
SQLDialect = 3
Params.Strings = (
'PATH=teste'
'USER NAME=SYSDBA'
'SQL DIALECT=3'
'SERVER=interbase.leonilda.com.br'
'PROTOCOL=TCP/IP')
Left = 8
Top = 8
end
object IBOQuery1: TIBOQuery
Params = <>
DatabaseName = 'interbase.leonilda.com.br:teste'
IB_Connection = IBODatabase1
RecordCountAccurate = True
SQL.Strings = (
'select * from bcd_test')
FieldOptions = []
Left = 40
Top = 8
object IBOQuery1FIELD1: TIBOBCDField
FieldName = 'FIELD1'
end
end
end



________________________________________________________________________
________________________________________________________________________

Message: 6
Date: Tue, 27 Jan 2004 14:52:55 -0000
From: "rlssv" <rene@...>
Subject: Using TIB_Script for creating procs/triggers

How can I dynamically create triggers/stored procedures ?
When using TIB_Script and having "set term ^;" in the script
it is not recognized !?

René/SSV



________________________________________________________________________
________________________________________________________________________

Message: 7
Date: Tue, 27 Jan 2004 16:24:42 +0100
From: Lucas Franzen <luc@...>
Subject: Re: Using TIB_Script for creating procs/triggers

René,


rlssv schrieb:
> How can I dynamically create triggers/stored procedures ?
> When using TIB_Script and having "set term ^;" in the script
> it is not recognized !?

SET TERM _IS_ recognized within the TIB_Script component (since I'm
using it all the time).

But you have to make sure, you're also ending your trigger / procedure
definition with a "set term ;^" then...

Luc.



________________________________________________________________________
________________________________________________________________________

Message: 8
Date: Tue, 27 Jan 2004 15:27:18 -0000
From: "rlssv" <rene@...>
Subject: Re: Using TIB_Script for creating procs/triggers

Sorry, I missed the space after term.
It's working now !

--- In IBObjects@yahoogroups.com, "rlssv" <rene@s...> wrote:
> How can I dynamically create triggers/stored procedures ?
> When using TIB_Script and having "set term ^;" in the script
> it is not recognized !?
>
> René/SSV



________________________________________________________________________
________________________________________________________________________

Message: 9
Date: Tue, 27 Jan 2004 16:33:36 -0000
From: "skander_sp" <skander@...>
Subject: QUERY-BY-EXAMPLE

No doubt... QBE it's a nice and powerfull tool in IBO

but... what about documentation and examples?

some link to synax available in dssSearch mode?

Tks in advance.

Alejandro



________________________________________________________________________
________________________________________________________________________

Message: 10
Date: Tue, 27 Jan 2004 11:40:56 -0500
From: Lee Jenkins <lee@...>
Subject: Re: User queries

Daniel Rail wrote:
> Hi Lee and Salvatore,
>
> At January 26, 2004, 15:27, Lee Jenkins wrote:
>
>
>>As I've mentioned, I am thinking about purchasing this component
myself.
>> Do you know if it works with the IBO TDataSet component?
>
>
> The TIBOInfo component uses the TDataset components, but it can be
> adapted to use the native components instead. The only task of this
> component is to retrieve the table names and fields information(name,
> datatype and size).
>
> If I misunderstood your question, let me know.
>


Nope, that was what I wanted to know, Daniel.

Thanks
--

Warm Regards,

Lee



________________________________________________________________________
________________________________________________________________________

Message: 11
Date: Tue, 27 Jan 2004 14:20:03 -0200
From: "Diego - DM2" <diego@...>
Subject: Help installing

Hello friends,

I need your help! I'm trying to install IBObjects(the last
evaluation
version that i got from the site)following the help on the site, but
when I
get to the item:

3. Go to the Project menu and choose Build All Projects. This will
compile all
the packages, both run-time and design-time.

I get the error:

Undeclared Identifier: 'sLoginUserName'
Undeclared Identifier: 'sLoginPassword'

both on the unit IB_WebSnap; line 307:


procedure TIB_CustomLoginFormAdapter.ImplGetFieldsList(AList: TStrings);
begin
AList.Clear;
AList.AddObject( sLoginUserName, TObject(TAdapterUserNameField));
AList.AddObject( sLoginPassword, TObject(TAdapterPasswordField));
//!!! AList.AddObject( sLoginEmail,
TObject(TIB_AdapterEmailLoginField));
end;

Can someone help me on what to do?

Thanks,
Diego



________________________________________________________________________
________________________________________________________________________


________________________________________________________________________
___
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
________________________________________________________________________
___
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !


------------------------------------------------------------------------
Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
------------------------------------------------------------------------


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.569 / Virus Database: 360 - Release Date: 1/26/2004


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.569 / Virus Database: 360 - Release Date: 1/26/2004