Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / FileMaker Topics / February 2004

Tip: Looking for answers? Try searching our database.

How do I Update a record with a result of a SQL from an oracale DB?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
adrian - 26 Feb 2004 18:30 GMT
I builded a script with the following:

select count (*) from v_employee
where home = '345'

how do I update a record with the result of my SQL? Appreciatte any help.
Matt Wills - 27 Feb 2004 21:10 GMT
If I understand correctly, you have a SQL script which produces the results
of the formula (or whatever it is called) you provided. Not knowing
Oracle/SQL in the least, I will just assume that you can send the results of
that formula to a text file.

You tell script FileMaker to import that file's record(s), using an
intermediate file which would, in turn, provide the source for updating the
records in the master file. You would need something common which would tell
FMP what record the SQL output belongs to, so a relationship could be
established.

You could then either do a lookup to permanently populate the master file
with the updated info, or just display the related information.

Matt

> I builded a script with the following:
>
> select count (*) from v_employee
> where home = '345'
>
> how do I update a record with the result of my SQL? Appreciatte any help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.