SQL portal filter

Hi

FM9 Windows XP

I have 2 tables, both SQL and I use a key field to link them and display
data into a portal.
The data is job history, every project we have done with this customer, for
invoicing cost purpose we also create a a job number for service contract.

So I have job number like (Years)-XXXX

99-
00-
01-
02-

and service contract start with letters....
PV-
PA-
AE-

Since it's possible to add calculation field in FM SQL Table I create a
field with calculation that return 0 and 1 if it's a project number or
service contract.

In the customer I also create a field the is equal to "1" and global
calculation field is not working !??! search me why

So I have my database table set to:
Customer_ID = Customer_ID
AND
Cal_1 (value 1) = Calculation_Contract

So normally in FM standard database I will only list those with identical
Customer_ID and those with Calculation_Contract that have a value of "1"

But in SQL it's not working....

I check, in both table value are set to 1, but they don't link in a
relationship table with SQL data ?!?!

What's is wrong? what did I miss, or it's another FM limitation.

Is it possible to right my own SQL Qwery ?? not use the dumb FM fields link
only.... the limitation of the field to field is soon reach
no way to have link with
ID=ID
AND
ID2>2000

the "2000" can't be enter manually, it has to be a field, and the only way
to get those number is to create a Calculation that will be equal to 2000,
but it's not working anyway ?!??!

Any clue ??
Thank you


JF

Re: SQL portal filter

I think I may have awnser myself to the question..... is it possible because
FM is not storing the calculation result of an add calculation field in a
SQL Table, the relationship is not working?!?!

JF


"JF Fortier" a écrit dans le
message de news: mM13j.41198$_V.23556@weber.videotron.net...
> Hi
>
> FM9 Windows XP
>
> I have 2 tables, both SQL and I use a key field to link them and display
> data into a portal.
> The data is job history, every project we have done with this customer,
> for invoicing cost purpose we also create a a job number for service
> contract.
>
> So I have job number like (Years)-XXXX
>
> 99-
> 00-
> 01-
> 02-
>
> and service contract start with letters....
> PV-
> PA-
> AE-
>
> Since it's possible to add calculation field in FM SQL Table I create a
> field with calculation that return 0 and 1 if it's a project number or
> service contract.
>
> In the customer I also create a field the is equal to "1" and global
> calculation field is not working !??! search me why
>
> So I have my database table set to:
> Customer_ID = Customer_ID
> AND
> Cal_1 (value 1) = Calculation_Contract
>
> So normally in FM standard database I will only list those with identical
> Customer_ID and those with Calculation_Contract that have a value of "1"
>
> But in SQL it's not working....
>
> I check, in both table value are set to 1, but they don't link in a
> relationship table with SQL data ?!?!
>
> What's is wrong? what did I miss, or it's another FM limitation.
>
> Is it possible to right my own SQL Qwery ?? not use the dumb FM fields
> link only.... the limitation of the field to field is soon reach
> no way to have link with
> ID=ID
> AND
> ID2>2000
>
> the "2000" can't be enter manually, it has to be a field, and the only way
> to get those number is to create a Calculation that will be equal to 2000,
> but it's not working anyway ?!??!
>
> Any clue ??
> Thank you
>
>
> JF
>
>

Re: SQL portal filter

JF Fortier wrote:
> I think I may have awnser myself to the question..... is it possible because
> FM is not storing the calculation result of an add calculation field in a
> SQL Table, the relationship is not working?!?!
>
> JF
>
>
>

yes, I had this situation two days ago. It is essentially like a calc
evaluating a related tale, can't be indexed.