Filemaker 6, Serial number and ODBC #2

Hi all,

I'm inserting into a FM6 table via ODBC, and the table has a
non-modifyable serial number (auto-entered).

any idea how i can get the value of that column for the record i just
inserted?

Thanks
Andy

0
ajohnstone (24)
6/22/2005 4:01:49 PM
comp.databases.filemaker 11109 articles. 0 followers. amosw01 (46) is leader. Post Follow

7 Replies
588 Views

Similar Articles

[PageSpeed] 29
Just put the serial-number field on your layout. Or isn't that what you 
need?

Ursus

"Andy" <ajohnstone@capcitypress.com> schreef in bericht 
news:1119456109.758033.19970@g14g2000cwa.googlegroups.com...
> Hi all,
>
> I'm inserting into a FM6 table via ODBC, and the table has a
> non-modifyable serial number (auto-entered).
>
> any idea how i can get the value of that column for the record i just
> inserted?
>
> Thanks
> Andy
> 


0
ursus
6/22/2005 9:11:20 PM
ursus,

I'm accessing soley through ODBC... so no layouts involved.

What i did is basically the equivolent of the @@IDENTITY variable in
SQL Server.

I *could* do the insert, and then Select Max( ID ) FROM table... but
i'm not sure that guarantees me the ID of the row I just inserted (as
opposed to a row inserted *after* my insert, but *before* my select).

Hope that clears what I'm looking for up a bit.

Andy

0
Andy
6/23/2005 12:59:10 PM
I am absolutely a nitwit regarding ODBC. But what I gather is that you want 
to see a value inside FMP before through a ADBC connection. I don't think 
that would be possible.

have you tried the FMP helpfile? it has some info on how to use OBDC. This 
is the list of instructions and elements that FMP can handle. It sdoesn't 
mention the @@IDENTITY. But as I don't know anything about OBDC I could be 
talking rubbish.

SELECT
INSERT (ook in een subopvraag)
UPDATE
DELETE
CREATE TABLE
DROP TABLE
ALTER TABLE
CREATE INDEX
DROP INDEX
FROM-instruction
ORDER BY-instruction
GROUP BY-instruction
HAVING-instruction
WHERE-instruction
UNION-operator
FOR UPDATE-instruction
: SUM, AVG, COUNT, MAX, MIN
DISTINCT SQL-operator
Inner Join-instructions
Left Outer Join-instructions
Subopvragen
Scalaire instructions
Current of Cursor-instructions
ROW ID

"Andy" <ajohnstone@capcitypress.com> schreef in bericht 
news:1119531550.117832.207040@g43g2000cwa.googlegroups.com...
> ursus,
>
> I'm accessing soley through ODBC... so no layouts involved.
>
> What i did is basically the equivolent of the @@IDENTITY variable in
> SQL Server.
>
> I *could* do the insert, and then Select Max( ID ) FROM table... but
> i'm not sure that guarantees me the ID of the row I just inserted (as
> opposed to a row inserted *after* my insert, but *before* my select).
>
> Hope that clears what I'm looking for up a bit.
>
> Andy
> 


0
ursus
6/23/2005 1:21:41 PM
ursus,

Yes, I've looked through the help, and haven't found what I need, which
is why I'm asking here if and how it can be done.

The best I could do is a select immediately after the insert.. but I'm
not sure that would ensure I have the row i inserted, and not someone
else.

Thanks
Andy

0
Andy
6/23/2005 2:10:11 PM
If you use a log-in system for your fmp file,  (accounts & privileges) you 
could do the following.

Create a script that
Imports your original ODBC record-serial-number together with all the data 
you need for the record
then puts the original ODBC record-serial-number into a global field.

With a user based system, globals are user-specific. So gMyGlobal can hold a 
value of UrsusSerial on my console (computer in the network) and at the same 
time hold a completely different value AndysSerial on your console. This way 
you will allways know what serial came out of the ODBC connection and that 
you are the one that put it there in the first place. Be aware that normally 
globals are stored when you shutdown a file. But with multi-user systems 
only the last one gets stored. But then again you should almost never rely 
on globals to hold data that does change to be retrieved in a new session.

Ursus

"Andy" <ajohnstone@capcitypress.com> schreef in bericht 
news:1119535811.102568.265530@f14g2000cwb.googlegroups.com...
> ursus,
>
> Yes, I've looked through the help, and haven't found what I need, which
> is why I'm asking here if and how it can be done.
>
> The best I could do is a select immediately after the insert.. but I'm
> not sure that would ensure I have the row i inserted, and not someone
> else.
>
> Thanks
> Andy
> 


0
ursus
6/23/2005 4:13:09 PM
Why don't you create a unique ID in your SQL database and send that to
FileMaker along with the other information. Then when you wanted to get
FM's unique ID, you could do

SELECT filemakerID FROM Table WHERE sqlID = 'known ID'

When you're synchronizing between two databases, it's a commonly used
technique to have a different unique identifier for each one that you
replicate on both sides. This has added benefits, such as the ability
to tell if a record has been synchronized (look to see if both ID
fields are populated). 

Kevin

0
audleman
6/23/2005 5:01:50 PM
Kevin & ursus,

Sorry, I think I created more confusion then I cleared :-)

I don't have any other DBs right now.. FM6 is the sole database
provider, I'm just writing an application to be a front end to the
database..

I threw out the @@IDENTITY from SQL server just to ask if there's
anything similar in FM ODBC, since thats basically the functionality
I'm looking for.

Andy

0
Andy
6/24/2005 2:40:48 PM
Reply:
Similar Artilces:

FileMaker Server 7, Filemaker Developer v7 WinALL Mac, IBM VISUALAGE FOR COBOL V3.0.6, Fujitsu NetCOBOL Suite v7.0L10 Enter. Edition, Intel Fortran Compiler Pro With IMSL V8.0.048, Clarion.v6.0.Enter
FileMaker Server 7, Filemaker Developer v7 WinALL Mac, IBM VISUALAGE FOR COBOL V3.0.6, Fujitsu NetCOBOL Suite v7.0L10 Enter. Edition, Intel Fortran Compiler Pro With IMSL V8.0.048, Clarion.v6.0.Enterprise.Edition.Incl, Capesoft.NetTalk.for.clarion.6.v3.04.Retail.WinAll, MICROSOFT VISUAL STUDIO NET PROFESSIONAL 2003, MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Services, (Enterprise), Developer Edition 64 Bit, other ... FileMaker Server 7 ...

Question about From Workspace block #2
Hi, I am planning to use Simulink to run a complex scenario that utilizes time and data imported from the workspace. Before I run this scenario, I want to make sure that I am using the "From Workspace" block properly. I have set up a very simple scenario, where I want to add two sine waves. Here is the data I have set up in the workspace: t = [0:0.2:10]'; x = sin(t); y = 10*sin(t); Within Simulink, I have a model set up with the following: (1) A "From Workspace" block with Data = [t x], sample time = 0.2, "Interpolate data" and "Enable ze...

Re: [Uniface-L] timeout #2
QnJhY2hhIEJhci1TaGFsZXYNCg0KQmVmb3JlIHRpbWVvdXQsIGFueSB0cmlnZ2VyIG9yIGNvZGUg aXMgcnVuPyBJZiBubywgM2dsXHNhbXBsZXNcYXN5bmNcYXN5bmMuYyBpcyBvay4NCgkNCg0KPT09 PT09PSAyMDA3LTA3LTA5IDE1OjAwOjQ4ID09PT09PT0NCg0KPkhpICsqIChhY3R1YWx5IGdvbGQg KyAqKQ0KPkRpZCBhbnlvbmUgaGFzIGltcGxlbWVudCBhIHNvcGhpc3RpY2F0ZWQgdGltZW91dCBm b3IgbW9yZSB0aGVuIDYwIG1pbnV0ZXMgPw0KPmZvciBleDogdGltZW91dCBvZiA0IGhvdXJzPw0K PlhudGgNCj5CYXJ1Y2gNCj5fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fXw0KPlVuaWZhY2UgVXNlciBHcm91cCBEaXNjdXNzaW9uIEZvcnVtDQo+Rm9yIG1vcmUg aW5mb3JtYXRpb246IGh0dHA6Ly9saXN0cy51bWFuaXRvYmEuY2EvbW...

Printing headers
Before I installed 6.1 when I printed a received message, a header, in bold type and underlined, showing the e-mail address of the sender, and the date and time of the message. Now, all I get is the word "in", not in bold and not underlined. Can anyone please tell me whether I can get a bold underlined header showing the sender and the time and date? I've tried the Eudora web site, and I've also looked in the manual, but so far I have failed. Any help would be very gratefully received. Brian In article <memo.20040507161952.1636A@brianphillip...

Looking for more information. #2
Hi I am interested in more information. Where is the best spot? You can email me at any of the following addresses: Thanks, Sam sam_brandt111@samsroverdogs.com sam111@gantabot.com beenie_baby111@slickbillspoliticalbiz.com beenie111@getthefourthedition.com franklins_mint111@slowmovingtrains.org franklins111@gillionpossibilities.com dell_watkins111@spacemanspifflandsonthemoon.com dell111@goodmedicalinformation.org michael_bolton111@spanishtires.net michael111@goodwalkinggroup.com backstreet_boyz111@spotteddogteam.com backst...

Install 2.6.4 as non-admin on Windows
How do I install python 2.6.4 on Windows without admin privileges? Can I install it on a machine I control, zip up the contents, copy it across to an admin-restricted machine, and set up a couple of environemtn variables? Does python install files to system directories, making this impossible? On 18 =DC=D0=E0, 16:45, Mark Carter <alt.mcar...@googlemail.com> wrote: > How do I install python 2.6.4 on Windows without admin privileges? > > Can I install it on a machine I control, zip up the contents, copy it > across to an admin-restricted machine, and set up a couple...

VS 6.0 and bit fields
I'm having a bit of a problem trying to find the correct way to code a bit field structure to handle 32 bits of data. I've created a union of 32 bits and 4 bytes. typedef struct _FRAME { union { unsigned long sync : 12; unsigned long start : 1; unsigned long x1 : 2; unsigned long change : 1; unsigned long cr : 2; unsigned long ext : 2; unsigned long frm : 1; unsigned long done : 1; unsigned long emp : 2; unsigned long freg1 : 4; unsigned long freq2 : 2; unsigned long pad : 1; unsigned long stop : 1; char data[ 4 ]; } u;...

Serial authentication protocol with AES
I've been following the similar thread (getting too old and disappearing), since we have same requirements. Due to the discussions, we moved up our development schedule for it. I copied the homework of an UCSB student (Jeff Tikkanen, CS178 Winter 2010) for the AES code. Yes, i know, i'll get a C for the class. The AES code takes around 2K on an AVR, but the inverse-AES adds some more. We don't use the inverse. Just AES on both ends and compare. Here is a dialog of our device: ---------------------------------------------------------------------------------------------------...

Core dump in realfree with Solari8 with Forte 6 update 2 compiler
Hi, I am running a program which was working in Window, Suse linux, united linux. But, my program is failing in Solaris8 with Forte 6 update 2 compiler. Can anybody clarify why this happens? Please help me regaridng this. Thanks in advance. ...

Nvidia GeForce 6600GT AGP on QNX 6.3.2
Hi Folks, Only the vesa driver seems to be available if I use a GeForce 6600GT AGP video card. Anyone using a 6X00 video card w/Photon and know how to make it work? Thanks! Nick ...

Your remove request has been successfully processed! #6
We have processed your remove request successfully. ...

Photo Ipods #2
Check out this cool site. You can get a free photo 60 gb ipod. My friend has done it and it is so cool. I just need to get referrals to sign up and complete a promotion. This will also help you get your free ipod. Check it out. http://photoipods.freepay.com/?r=21666162 ...

Filemaker network sharing error 10048
Am using FM Pro 5.5v2 on Windows XP SP2 PC Create a new database, try to make it multi user and share it and get error "Filemaker cannot host a file because of a network error. Files marked as multi user will not be available over the n/w 10048" I've opened up port 5003 in XP firewall (TCP and UDP), and I'm stuck ! Have to use 5.5 for various reasons (ie upgrading not an option at the mo) There are a few articles on Net but no answers posted that I can see... Any help much appreciated ! Hummm if my memory is correct FM5.5 was not XP compatible ?!?!, may work, but som...

FS: Five PRINCIPLES of Business Leadership MULTIMEDIA COURSE PC BASED #2
Visit http://www.seals4deals.co.uk The Five Principles of Business Leadership Multimedia PC CD-ROM learning Environment Contains PC CD-ROM & supporting book. The software is a complete interactive learning environment with 24 tasks, an action and activity planner, an interactive brainstorming area, a section of interactive learning games and a library of supporting documents. Energise and motivate your TEAM Define you CORE values Improve PRODUCTIVITY Build on your STRENGTHS Identify your GOALS Create a VISION Interested in the Item See link for details: http://search....

Moving to iPhoto 6 from earlier versions
iPhoto 6 rebuilds your library if you had previously been using iPhoto 5. I didn't realize what this meant until it was too late. I count on the yyyy/mm/dd format iPhoto used prior to 6. When the library is converted to 6, all your images get moved to originals and modified directories and renamed yyyy/roll-name. Then they are copied to a data directory. That means you have two copies of each image and I have no idea why that is necessary. At any rate, data has all the images in one place and I use it to do a unix ln of each image to a yyyy/mm/dd catalog. The danger here is t...

PLATINUM SOFTWARE COLLECTION #2
WE WANT YOU TO BE RICH! and offer software for technical analysis of stocks/commodities/ futures/forex markets: AATS - Accurate Trading CCI ZLR Trading System (EasyLanguage Open Code) AATS - LTC ES Scalper System (EasyLanguage Open Code) AIQ Trading Expert and AIQ Option Expert v8.2 APS v4.8 (http://www.tradingpatterns.com) ART Charting Software for TS8 (EasyLanguage Open Code) ART System for eSignal ATS-3200 (http://www.ats3200.com) ATS-6400 Trading Software (http://www.ats3200.com) AXIOM Index Swing System (EasyLanguage Open Code) for TS2000i, TS8 + manual (http://www.axiomindex.homestead.c...

problem when use debug perl in win2000 os #2
Hi,all I have such a problem, someone can help me? When I debug a program written in perl using "perl -d foo.pl" The following message show up: ================================ Unable to connect to remote host: 127.0.0.1:2000 Compilation failed in require. main::BEGIN() called at D:/Perl/5.8.0/lib/perl5db.pl line 0 eval {...} called at D:/Perl/5.8.0/lib/perl5db.pl line 0 BEGIN failed--compilation aborted. ================================ My OS is win2000, and the perl version is 5.8.0. If I don't debug it, just run it ( perl foo.pl), everything is fine. Any comm...

GFA-BASIC Compiler v3.6 r14 released
GFA-BASIC Compiler release 14 notes: Missing procedures and labels are now detected RESTORE missing_label !fixed Program would still run, but the wrong DATA line was restored GOTO/RESUME missing_label !fixed ON ERROR/ON BREAK GOSUB missing_proc !fixed EVERY/AFTER x GOSUB missing_proc !fixed ON MENU GOSUB missing_proc !fixed ON MENU KEY/IBOX/OBOX/BUTTON/MESSAGE GOSUB missing_proc !fixed ON x GOSUB missing_proc1,miss...

=?UTF-8?B?4pWD4pyW4pWD4pyW4pWD4pyWIFBheXBhbCBXaG9sZXNhbGUgRmFtb3VzIEJyYW5kIEhhbg==?= =?UTF-8?B?ZGJhZ3MgJiBQdXJzZXM9QnVyYmVycnksQk9TUyxMVixDaGFuZWwsQ2hsb2UsRCZHLERpb3IsR3VjY2ks?= =?UTF-8?B?SGVybW #2
=E2=95=83=E2=9C=96=E2=95=83=E2=9C=96=E2=95=83=E2=9C=96 Paypal Wholesale Fa= mous Brand Handbags & Purses=3DBurberry,BOSS,LV,Chanel,Chloe,D&G,Dior,Gucci,Hermes,JIMMY CHOO,JUICY,KOOBA,LOEWE,FENDI,PRADA,VERSACE,etc...Welcome To Site www.guomeitrade.com Handbags AAA True Leather http://www.guomeitrade.com/category-1201-b0-AAA-True-Leather.html Burberry Handbags http://www.guomeitrade.com/category-1202-b0-Burberry-Handbags.html Balenciaga Handbags http://www.guomeitrade.com/category-1203-b0-Balenciaga-Handbags.html Balenciaga Purse http://www.guomeitrade.com/category-1204-b0-Bale...

Modular toolkit for Data Processing 2.5 released!
We are glad to announce release 2.5 of the Modular toolkit for Data Processing (MDP). MDP is a Python library of widely used data processing algorithms that can be combined according to a pipeline analogy to build more complex data processing software. The base of available algorithms includes, to name but the most common, Principal Component Analysis (PCA and NIPALS), several Independent Component Analysis algorithms (CuBICA, FastICA, TDSEP, JADE, and XSFA), Slow Feature Analysis, Restricted Boltzmann Machine, and Locally Linear Embedding. What's new in version 2.5? --------...

VC++ 6 Processor Pack and SP6 for Visual Studio 6
Hello I have a question. The Visual C++ Processor Pack works fine with the Visual Studio 6.0 Service Pack 6? If the answer is yes, what install first? Processor Pack o SP6? (i have visual studio 6.0 installed without service packs) thanks. IDandT I'm sorry: I must read more... "The Visual C++ 6.0 Processor Pack is not compatible with Visual C++ Service Pack 6. If you install the Visual C++ Service Pack 6 on a machine on which the Processor Pack is already installed, the Processor Pack functionality will become unavailable. Likewise, if you install the Pr...

inheritance problem with 2 cooperative methods
Here is a problem I am having trouble with and I hope someone in this group will suggest a solution. First, some code that works. 3 classes that are derived from each other (A->B->C), each one implementing only 2 methods, __init__ and setConfig. ------------------------------------------------------- #!/usr/bin/python class A (object): def __init__(self): super(A, self).__init__() self.x = 0 def setConfig(self, config): self.x += config['x'] class B (A): def __init__(self): super(B, self).__init__() self.y = 0 def setConfig(self, co...

ORACLE / FINANCIALS DBA
Note: We want someone that is very technical, lots of application DBA experience particular to e-business but also a manager at present, not just a project leader. So someone that been a DBA customizing EBS and then became a manager and has been in that role for the past 6-12 months. 6 - 12 month engagement in NY City (midtown). MUST currently reside within a reasonable commute distance to midtown. Our client is offering a right2hire option with this position. We are looking for a senior Oracle EBS R12 consultant who is: * Very technical * Has lots of application DBA experience particular to...

1PPS signal on Solaris 10 #2
I have been having enormous amounts of trouble detecting a 1PPS signal on a 4200 (Intel x86) running Solaris 10. There is no direct serial port connection, so I am looking for a PCI board or some other alternative way of receiving this signal. I tried a serial-to-USB connection, but the USB port does not support the DCD pin (which PPS comes over on). I've also tried a Performance Technologies board, but the ioctl calls TIOCSPPS, TIOCGPPS, and TIOCGPPSEV all return invalid values. I also have a Symmetricom BC635 board which would support the 1PPS signal if they were to have a driver for Sol...

Random Number #6
Hello, I need to create a column array with random numbers between 0 and 1. I tried Matlab's random function but I was not able to do this. Can somebody help me out? Thank You, Miguel >> rand(4,1) ans = 4.447033643531942e-001 6.154323481000947e-001 7.919370374270354e-001 9.218129707448025e-001 Shapper wrote: > Hello, > > I need to create a column array with random numbers between 0 and 1. > I tried Matlab's random function but I was not able to do this. > > Can somebody help me out? > > Thank You, > Miguel > What indicat...