Hi

I've been working with FM6 and I have been importing-Updatting my FM
database with my SQL main database for years.

Now I have the possibility to upgrade to FM9 with SQL (by the way I have SQL
Server 97 and it also work with FM9)

Simple question; In my business solution I have two types of customer file
#1- the SQL data that is use for invoicing, open account etc etc
#2 The FM database that is use for my Service department and we have the COD
type customer AND import the SQL data base on the unique Row# and when it's
a COD type customer the field is set to "EMPTY" so when updating from SQL
all the Empty COD data is put a side and all the other one are updated, and
also new data in SQL are created if require.

I use a script scheduler that run every 30 mins to do the update

Now how can I manage this with FM9 and get rid of the update and script
schedule using two set of data in FM
and I don't whant to create new data in my SQL database for those COD
customers that I only use in FM

I had one idea, but this will implicate lots of calculated field
Create Table_SQL with a link to SQL
One Table_FM with the COD FM database
Create one table of data that will be a calculation result, if
(ROW="empty";"Table_FM";"Table_SQL")

But this will require a lot of calculation on every screen, and may cause
other problem when need for linking tables and calculation ?!?!

What do you thing ??

Thank you, Merci beaucoup.

JF

I'm sorry I don't understand completely what you are trying to do. But
when you set up your external SQL source (ESS) in FM9, you will have a
table occurrence (TO) on your relation graph. You can then set up a
relationship from your FMP table to the ESS table. At that point, you
would script this (or whatever you need to do) just like any other
script where you need to transfer data between two tables. So this
really becomes a script that, for all intents and purposes, has nothing
at all to do with the SQL table. It's just any other TO as far as your
scripting goes.

Hope that helps. If not, maybe you can indicate exactly where your
question lies.

Thanks...
Howard


JF Fortier wrote:
> Hi
>
> I've been working with FM6 and I have been importing-Updatting my FM
> database with my SQL main database for years.
>
> Now I have the possibility to upgrade to FM9 with SQL (by the way I have SQL
> Server 97 and it also work with FM9)
>
> Simple question; In my business solution I have two types of customer file
> #1- the SQL data that is use for invoicing, open account etc etc
> #2 The FM database that is use for my Service department and we have the COD
> type customer AND import the SQL data base on the unique Row# and when it's
> a COD type customer the field is set to "EMPTY" so when updating from SQL
> all the Empty COD data is put a side and all the other one are updated, and
> also new data in SQL are created if require.
>
> I use a script scheduler that run every 30 mins to do the update
>
> Now how can I manage this with FM9 and get rid of the update and script
> schedule using two set of data in FM
> and I don't whant to create new data in my SQL database for those COD
> customers that I only use in FM
>
> I had one idea, but this will implicate lots of calculated field
> Create Table_SQL with a link to SQL
> One Table_FM with the COD FM database
> Create one table of data that will be a calculation result, if
> (ROW="empty";"Table_FM";"Table_SQL")
>
> But this will require a lot of calculation on every screen, and may cause
> other problem when need for linking tables and calculation ?!?!
>
> What do you thing ??

My english is not perfect, so.....

I have 2 set of Data in my FM6 solution (but both are combine in one file) I
have the COD customer with no relation to any table or Unique ID from the
SQL database
and the other set of data that is imported in the FM6 using the Unique Row
#, so after it's imported in FM6, it's now part of the FM database and I use
it as any other data, and I run script to update every 30mins all the data
from the SQL so my FM6 database is update with the SQL Database

Now with the option to insert the SQL into a Table in FM9, how I'm going to
"mix" or merge my data in my solution ?!?!
Previously I import/update the data from SQL, now I can Have a live
connection.... but 70% of my data is not in the SQL database, those data are
only in FM..... and for many raisons, I don't want them in the SQL database.

Hope this clarify the need that I have ??

JF
"Howard Schlossberg" <howard [at] nospam.fmprosolutions.com> a écrit dans le
message de news: 13ac4jnmhbv4u99 [at] corp.supernews.com...
> I'm sorry I don't understand completely what you are trying to do. But
> when you set up your external SQL source (ESS) in FM9, you will have a
> table occurrence (TO) on your relation graph. You can then set up a
> relationship from your FMP table to the ESS table. At that point, you
> would script this (or whatever you need to do) just like any other script
> where you need to transfer data between two tables. So this really
> becomes a script that, for all intents and purposes, has nothing at all to
> do with the SQL table. It's just any other TO as far as your scripting
> goes.
>
> Hope that helps. If not, maybe you can indicate exactly where your
> question lies.
>
> Thanks...
> Howard
>
>
> JF Fortier wrote:
>> Hi
>>
>> I've been working with FM6 and I have been importing-Updatting my FM
>> database with my SQL main database for years.
>>
>> Now I have the possibility to upgrade to FM9 with SQL (by the way I have
>> SQL Server 97 and it also work with FM9)
>>
>> Simple question; In my business solution I have two types of customer
>> file
>> #1- the SQL data that is use for invoicing, open account etc etc
>> #2 The FM database that is use for my Service department and we have the
>> COD type customer AND import the SQL data base on the unique Row# and
>> when it's a COD type customer the field is set to "EMPTY" so when
>> updating from SQL all the Empty COD data is put a side and all the other
>> one are updated, and also new data in SQL are created if require.
>>
>> I use a script scheduler that run every 30 mins to do the update
>>
>> Now how can I manage this with FM9 and get rid of the update and script
>> schedule using two set of data in FM
>> and I don't whant to create new data in my SQL database for those COD
>> customers that I only use in FM
>>
>> I had one idea, but this will implicate lots of calculated field
>> Create Table_SQL with a link to SQL
>> One Table_FM with the COD FM database
>> Create one table of data that will be a calculation result, if
>> (ROW="empty";"Table_FM";"Table_SQL")
>>
>> But this will require a lot of calculation on every screen, and may cause
>> other problem when need for linking tables and calculation ?!?!
>>
>> What do you thing ??